Hi,
I've got a database that updates to Excel by exporting a Union Query to a text document and importing in Excel. What I need to is to get my Excel file to open "Excel.xls" from a macro without having to go through any sort of database action first, ie. Update to Excel. I just want to open that Excel file when the macro is run. Any suggestions?
Thanks,
-Fort
I've got a database that updates to Excel by exporting a Union Query to a text document and importing in Excel. What I need to is to get my Excel file to open "Excel.xls" from a macro without having to go through any sort of database action first, ie. Update to Excel. I just want to open that Excel file when the macro is run. Any suggestions?
Thanks,
-Fort