fahadakbar
Board Regular
- Joined
- May 15, 2014
- Messages
- 63
Hi Guys,
I have been using this code successfully to save my file to our company's intranet
Workbooks("Value Added Service Pivot.xlsx").SaveAs Filename:="http://sharedapp/marketing/Marketing Department Dashboard/Daily Activity/Value Added Service Pivot.xlsx"
this code has all of sudden has stopped working and gives me a " Run time Application Defined or Object Defined Error"
I am so confused why would this happen all of a sudden when it was working until two days ago
If i change the location to a local drive, it works fine
Any help would be much appreciated
Thanks
Fahad
I have been using this code successfully to save my file to our company's intranet
Workbooks("Value Added Service Pivot.xlsx").SaveAs Filename:="http://sharedapp/marketing/Marketing Department Dashboard/Daily Activity/Value Added Service Pivot.xlsx"
this code has all of sudden has stopped working and gives me a " Run time Application Defined or Object Defined Error"
I am so confused why would this happen all of a sudden when it was working until two days ago
If i change the location to a local drive, it works fine
Any help would be much appreciated
Thanks
Fahad