G
Guest
I have code to export certain data from Access to Excel. The code open a
Save As Dialog box where the user specify the location and name for the newly
reated Excel file. I also have an Excel Macro (ain my Personal macro
Workbook) that i than run against the spreadsheet.
Since I know the name of the Excel File and the Name of the Excel Macro, is
there a way to execurte the Excel macro from within the MS Access code?
The File name is something like 'C:\Documents and
Settings\595930\Desktop\VCP_IT_Reports\VCP_IT_mmddyy.xls
The macro in Excel is named: PERSONAL.XLS!Format_VCP_IT.Format_VCP_IT
Thanks
Save As Dialog box where the user specify the location and name for the newly
reated Excel file. I also have an Excel Macro (ain my Personal macro
Workbook) that i than run against the spreadsheet.
Since I know the name of the Excel File and the Name of the Excel Macro, is
there a way to execurte the Excel macro from within the MS Access code?
The File name is something like 'C:\Documents and
Settings\595930\Desktop\VCP_IT_Reports\VCP_IT_mmddyy.xls
The macro in Excel is named: PERSONAL.XLS!Format_VCP_IT.Format_VCP_IT
Thanks