in my web application i need to export details from the dtabase to the excel sheet
the excel sheet is macro enabled
the macro needs to take data from database & fill some controls on Excel sheet
currently i have hardcoded the connectinstring in the VBA & is working fine
but is there any way in which the connection string can be taken from web config file