Saving an excel on webserver

[me_gem69]

Hi,

I am generating an pdf from excel & i have to save it on my webserver.
But when ever i give the webserver address it is giving me an error 1004.

Please help

following is the code i use


ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:="/opt/shared/apps/3.7.5/test.pdf", _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=True

 

[Andrew Poulsom]

Can you save as PDF to the webserver manually? If so, and you record it, what VBA code do you get?