DummyForAccess
Technical User
I'm trying to automate a very manual process. I have a database built in Access that will import and refresh tables. Then I need to have a macro that opens an Excel spreadsheet and calls an (Excel) macro. (This macro is necessary because it formats the spreadsheet in a certain way, populates worksheets with data from my refreshed tables, and creates dropdown pick-lists from those worksheets). Most of it works well, but I'm having a problem getting Accsess to get the Excel macro running...
I have code that I got to paste into a module to open excel and call the (excel) query. Problem is if I use "open Module" cmd in an Access Macro, it just opens the module in a vb development window. I know I'm missing a step or something???
I have code that I got to paste into a module to open excel and call the (excel) query. Problem is if I use "open Module" cmd in an Access Macro, it just opens the module in a vb development window. I know I'm missing a step or something???