Macro Used on Networked PC's

[tanderson]

I created a Macros for a spreasheet that works wonderfully up until it saves. It works just fine on my PC but when someone trys to run it on another Networked PC it bug's out at the place in red below:

Dim dtDate As Date
dtDate = Date
Dim strFile As String
strFile ="E:\Elvis\Franchises\Client\Data Documents\Data Team Reports\Client Data Broadcast Data " & Format(dtDate, "mm-dd-yyyy")& ".xlsm"
ActiveWorkbook.SaveAs Filename:=strFile,FileFormat _
:=xlOpenXMLWorkbookMacroEnabled,CreateBackup:=False

I'm getting Run-timer error '1004':
Method 'SaveAs' of object'_Workbook' failed.

So I understand that it's an issue with the other Networked PC's understanding 'Workbook' but I'm not understanding how to fix this. Any suggestions?

 

[Gerald Higgins]

This isn't my area of expertise, but could it possibly be because the directory / filepath are somehow not recognised on those other machines ?

 

[tanderson]

Thanks for the feedback! The filepath is accessible for all networked PC's, it's directing toward one of the main shared drives so that should be the issue. The other users can get to those locations manually. With your message I did go to the specific folder where this file is being saved to check permission on it since I created it. It wasn't officially marked read only but I when ahead and marked everyone as full control. I had another user try this again and same error

 

[LockeGarmin]

Does it save successfully when you preform this action manually?

 

[tanderson]

Yes they can save it manually after they exit out of the error box. I'm stumped.

 

[LockeGarmin]

What happens when you put the following into their Windows Explorer Navigation Bar?

E:\Elvis\Franchises\Client\Data Documents\Data Team Reports

 

[dazfoz]

I had a similar issue, try adding

ChDrive "E"

before your save command.