Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi... thanks for any help concerning that topic...
I am facing a problem with that simple code line ActiveWorkbook.Save... But the problem appears only on Network Drives and this - Only when connected to them through Internet... - Not when connected directly through a LAN... as if connection speed would be a problem! When it fails I receive this message ... is currently in use... Try again... and on the network drive I can see that a temp file as been created... and not deleted... On the other hand, I have no problem to realise the save function by simply clicking on the save function through the Excel interface... I have no problem also when I create first a file on this network drive through a save as... while a save as on an existing file also produce an error... Thanks for whom who would have any idea about the problem I am facing Regards Alain PS: my connection is established through a VPN... woud it mean that in such circumstances, vba would be acting as another user on the same file ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving Excel File to a Network Drive | Excel Discussion (Misc queries) | |||
Error Trapping saving file to network drive | Excel Programming | |||
Problem saving to network drive | Excel Programming | |||
Sporadic errors when saving to network drive | Excel Programming | |||
Excel 2003 - problem saving to a mapped network drive | Excel Discussion (Misc queries) |