export report to excel

[AMRI YULIANDI]

DoCmd.RunSavedImportExport "EXPORT-STARS"



i have run this query on access 2003, and working fine.. but when im running on access 2007 i got a problem..
here the error messagge..

"run-time error '3044':
'c:\Users\my\desktop\stars.xls' is not a valid path. make sure the path name is spelled correctly and that you are connected to the server on which the file resides.

anyone can help me?
thank before, i'm still newbie

[JoeM]

Did you check to verify that the file path really exists, i.e. can you browse to:

c:\Users\my\desktop

?
Is your username really "my"?

[trevor40]

Hi,
you may need to allow the location as a trusted location/site.

[AMRI YULIANDI]

btw where can i change the path?

newbie here..

thank for the help..

[JoeM]

Not sure. I really don't used Saved Imports/Exports. You may just want to create a new one going to the correct place.