VBA, Excel Run-time error 1004. Application-defined or object-defined error.

[Tendajay]

Hi Guys

I have this problem with our VBA Sub-routine, when i press a command button it's suppose to automatically save the excel sheet as a pdf in a certain folder. it works perfectly in my boss's laptop (who created the sub-routine) however in my laptop it gives Run-time error application-defined or object-defined error.

Is there a setting on my computer that is different and throwing it off on my laptop .

 

[Marc L]

Hi, check at least if the folder path already exists …​

​

 

[Tendajay]

Hi, after checking i realised that the filepath was the problem, it's my boss's filepath that is in the code hence it's giving an error when i am using it.

We work on the same work book so if i change the filepath to mine, he will start having the same problem as mine.

Is there a way both our filepath can be included in the code.

 

[Marc L]

Different ways but as I can't guess the missing so try the VBA UserName property for example …​

​