View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alain-79 Alain-79 is offline
external usenet poster
 
Posts: 16
Default Problem in Saving the Activeworkbook on a network drive

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 ?