Attached file name extension problem using Groupwise

[popper]

I am using vba in Access to attach and send files via Groupwise and use a statement of the type

.Attachments.Add "C:\test.xls"

as I am sending Excel Spreadsheet files.

It works fine on one machine but on another, it will not tolerate the ".xls" part. When I remove that, the file is attached and sent, but no longer recognised by Windows as an Excel file. Why does this behave differently on different machines. Where is this setting stored?

I would appreciate any help with this problem.

With thanks

 

[AnotherHiggins]

Are you trying to recreate the module on the second PC? If so:

In the VB Editor, go to Tools > References

Make sure that the 2nd PC has all of the same references selected as your original module.

If, on the other hand, you are using the same Access DB and just opening it on another PC, the references will follow so that's not the problem. If that's the case, what error are you getting when you try to run the code?

[tt]-John[/tt]
The Member Profiles are finally working again!
________________________
To get the best answers fast, please read faq181-2886