So the way it works, is that when the Scheduled Task runs, a database is opened, which launches a hidden form in the database and runs my VBA code. When the database opens, a form is launched: The code in the 'Load' event of the form is. Launch the Notepad application and paste the following code on the left into the text editor (the colors won't display in Notepad). 'Input Excel File's Full Path. ExcelFilePath = 'C: Users chris Documents My File.xlsm'. 'Input Module/Macro name within the Excel File. MacroPath = 'Module1.MyMacroName'.
Hi russelh,
It seems that the best way to automate your tasks is to:
Poedit pro keygen. i) run your queries automatically by building a macro that runs you desired queries and then exits Access.
ii) The next step would be to create a batch file that opens Microsoft access and runs the desired macro. The file would contain some command such as:
'C:Program FilesMicrosoft OfficeOffice14MSACCESS.exe' 'C:Program FilesMicrosoft OfficeOffice14samplesnorthwind.mdb' /x macroToRun
Manually delete temporary files. iii) The final step would be to run the batch files using windows task scheduler. You can make multiple batch files and run them at different times to account for the different queries for different times of the month etc.
Access Macro Task Scheduler
It seems that the best way to automate your tasks is to:
Poedit pro keygen. i) run your queries automatically by building a macro that runs you desired queries and then exits Access.
ii) The next step would be to create a batch file that opens Microsoft access and runs the desired macro. The file would contain some command such as:
'C:Program FilesMicrosoft OfficeOffice14MSACCESS.exe' 'C:Program FilesMicrosoft OfficeOffice14samplesnorthwind.mdb' /x macroToRun
Manually delete temporary files. iii) The final step would be to run the batch files using windows task scheduler. You can make multiple batch files and run them at different times to account for the different queries for different times of the month etc.
Access Macro Task Scheduler
Access Macro Scheduler Tutorial
Hope this helps
JCHutchinson
