Small bit of VBA not working

[durdle]

Good day,

I have a small piece of code setup under a command button, which is not working properly on everyone?s computer except mine.

The code is:

On Error GoTo errorhandler

DoCmd.OutputTo acOutputQuery, "Phone_Stats", "MicrosoftExcel(*.xls)", , False

errorhandler:

Exit Sub

I get the prompt to save the file but when I check the location, it did not put the file there. The db is used to extract data, I am the only person who updates the data(once per day). The db is located on a file server.

Any help would be great
________
oregon marijuana dispensary

 

[Mile-O]

Comment this line out:

On Error GoTo errorhandler

to

' On Error GoTo errorhandler


and you'll see if you are getting an error or not.

 

[durdle]

Hey Mile,

I recieve no error??
________
r1150r