penfold1992
Registered User.
- Local time
- Today, 04:07
- Joined
- Nov 22, 2012
- Messages
- 169
Hello All,
so I have scheduled a macro using the following settings within task scheduler:
Actions: Start a program
Program/Script: "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE"
Arguements:
"\\firo\Testing\dbname.accdb" /x PropReport
and the macro I am trying to run(PropReport) extracts a query and then saves it to the hdd.
the macro contains:
so...
on scheduled time, the database opens but it gives me the following error:
Microsoft Acces cannot find the object 'PropReport.'
if 'PropReport' is a new macro or macro group, make sure you have saved it and that you have typed its name correctly.
anyone have any ideas?
so I have scheduled a macro using the following settings within task scheduler:
Actions: Start a program
Program/Script: "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE"
Arguements:
"\\firo\Testing\dbname.accdb" /x PropReport
and the macro I am trying to run(PropReport) extracts a query and then saves it to the hdd.
the macro contains:
Code:
Option Compare Database
Public Function PropReport()
DoCmd.TransferSpreadsheet acExport, 10, "Main_Query", _
"[COLOR=#0066cc]\\firo\Testing\"[/COLOR] & _
"Reporting Test.xlsx", -1
Application.CloseCurrentDatabase
Application.Quit
End Function
so...
on scheduled time, the database opens but it gives me the following error:
Microsoft Acces cannot find the object 'PropReport.'
if 'PropReport' is a new macro or macro group, make sure you have saved it and that you have typed its name correctly.
anyone have any ideas?