I am trying to create a macro that will open and excel file and run the excel macro, and then run the Access macro in the data base. I currently have the macro built in excel and it runs perfectly. Not sure if it matters, but I am transferring data from text, to excel, and then importing the data into access. Any ideas?
Also, how do you turn off the box that asks if you want to delete the records when then macro is deleting files? Thanks.
Also, how do you turn off the box that asks if you want to delete the records when then macro is deleting files? Thanks.