snapshot viewer problem - very strange

[Davros]

hi
i am using a macro with the outputTo method for a report. i have the report outputed as a snapshot file. it was working fine but now when it outputs the report the extension is missing; the file is created but with no extension. i tried changing the output format to excel but the extension was still missing. i also tried renaming my output report within the macro with the extension .snp and with .xls. snapshot viewer or excel would not open these programs.
anybody else come across this problem?
any ideas?

thanks

 

[Davros]

the problem seems to have corrected itself if i disgard the macro and write it in VB code.
still can't figure out why the macro would'nt work though?

the code i used is

Private Sub cmdsnapshot_Click()
On Error GoTo Err_cmdsnapshot_Click

Dim stDocName As String
DoCmd.OutputTo acOutputReport, "mem_main_search_report", acFormatSNP, "c:\cemeteries\mem_main_search_report.snp", True
Exit_cmdsnapshot_Click:
Exit Sub

Err_cmdsnapshot_Click:
MsgBox Err.Description
Resume Exit_cmdsnapshot_Click

End Sub