VBA copy sheet to new workbook path/file access error

[hunker]

Hi all,

I checked many solutions to fix my issue but i am not able to correct it, I have a file placed on a server and I would like to copy the sheet "PO" to a new workbook via VBA.

My VBA code is really simple :

Sub CopyPO()

ActiveWorkbook.Sheets("PO").Copy

End Sub

The macro work well when I run it from the file placed in on my desktop but when i run it from the server i got Path/file access error VB???.tmp (the ??? always change if i run the code severals times)

I tried many ways without viable solution.

I will be glad to get some help.

Thx
Geoffrey

[hunker]

Hi,

To give more details, i tried to manually copy the sheet and i got the same issue, i also tried to create a new empty file and try to manualy copy the sheet and it s works, so i think it s an issue with the file itself but i cannot find out what it is.

[seercoven]

Hi Hunker,

Are you able to run the macro in the server? I presume you're using a shared drive/server and having issue running the excel.

If so, you can try below method.
Control Panel > Internet Options > Change security settings.
In the trusted site, include the IP address of the drive and see if it's working.

[hunker]

I checked and it s not that issue, I tried to delete all my macro and at that time i was able to manually copy the sheet but once have maccro in the file it s only working on my desktop and not on my shared server.

So strange...

[seercoven]

As there is no sample file provided, the vba code you've provided works fine to me. I've tried it on my shared server and it's also working.

I'm not sure what do the others think but based on the errors, its looks like some issue with the path and file name. There might be something you used in other part of macro.

[hunker]

Hello,

Thanks for your feedback, there are severals VBA code on my file, i cannot upload it here because it s too heavy, i uploaded it on wetransfer, let me know if it s running on your server.

File : https://we.tl/t-OB7m9XBtay

The maccro to copy sheet is linked to a bouton on sheet "PO" , colunm F , bouton "PO Confirmation".

Let me know if it s run on your server.

Thx mate,
Geoffrey