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

Toggling save warning message on or off 9
Save to all computers on network from Excel 2007 2
Save Dialog pops up now - Excel 2007 1
Hiding an Excel file using VBA 1
Network path in cell 3
Macro to Put network path in cell 2
VBA Save As problem with file that already exist 2
File owner attributes through Excel VBA 4

Top