Hey guys,
I'm trying to design an auto-import for an employee which will automatically import Access table data directly into Excel.
The easiest way I found is to record myself manually doing the import and save it as a macro. Then create a command button that will launch the macro.
I was able to do this with my initial testing, but they need to run this import process each month so how can I repeat the process on new spreadsheets without having to recreate the macros each time? Kinda defeats the purpose that way.
Can anyone help?
I'm trying to design an auto-import for an employee which will automatically import Access table data directly into Excel.
The easiest way I found is to record myself manually doing the import and save it as a macro. Then create a command button that will launch the macro.
I was able to do this with my initial testing, but they need to run this import process each month so how can I repeat the process on new spreadsheets without having to recreate the macros each time? Kinda defeats the purpose that way.
Can anyone help?