Excel VBA Save file to Network in Vista and Office 2007

T

TMazzotta

I have a macro that saves a file to a network drive.. It has been working
fine for a while now.
Recently, one of our users upgrade to Office 2007 and Windows Vista.. Since
then, the VBA macro has been blowing up when trying to save the file to the
network. I've tried Save as well as SaveAs. They give a Method ‘SaveAs’ of
object_’Workbook’ failed error.

I also tried saving the file to the local harddrive and then copying the
file up to the network using FileCopy. The save to the hard drive works, but
the copy up to the network doesn't work.

This stuff all works OK under Windows XP/Office 2003.
I've checked permissions for the network folder.. That all seems clear (she
has both read and write access). My suspicion is this is some sort of
Windows Vista compatibility issue.

Any thoughts or suggestions?

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I save directly into the same folder every time in Office 365 / Windows 10? 0
Toggling save warning message on or off 9
Save to all computers on network from Excel 2007 2
Trying to save directly to .Doc and using save as MHTML 0
Network path in cell 3
Publisher 2000 will not "Save" or "Save AS" and says MS Publisher not Responding. 0
Bat file called from macro addressing network drives - NOT! 4
Macro to Put network path in cell 2

Top