I’m new to VBA and I would like to automate some routine data extraction tasks. Is there a solution that VBA can do to extract interest rates from Capital IQ and put them in an excel sheet ?
VBA is not generic. It is specific to your workbook. Supply a sample workbook which is representative of your actual data 8-15 records and then mock up a manual solution.