A
Alain-79
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 ?
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 ?