Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA Save file to Network in Vista and Office 2007
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA Save file to Network in Vista and Office 2007
Hi,
What is the file extension you are using? Take a look at this. http://www.developersdex.com/vb/mess...2677&r=6464967 John "TMazzotta" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Install Office Standard XP on Vista. Uninstall Office 2007 Trial? | Excel Discussion (Misc queries) | |||
Excel 2007 and Office 2007 stink (so does Vista) | Excel Discussion (Misc queries) | |||
Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
office 2007 excel and windows vista ultimate | Excel Discussion (Misc queries) | |||
how can i view or save as a .dbf file in excel 2007/vista ? | Excel Discussion (Misc queries) |