I need an expert please! publish excel sheet to an intra web server

hi people i need help please
I can publish my excel report to my hard drive, but when i change it to the intranet server it will not go. Any ideas please help i'm on a deadline. Here is what i have that posts to hardrive:

ActiveWorkbook.PublishObjects.add(xlSourceRange, _
"S:CableGTA CentralCCOSBudget & ReportingWeb sitepublic_htmlRepairCallDrivers.htm" _
, "CCSUM_Repair_CallDrivers", "$A$1:$N$70", xlHtmlStatic, "CCSUM_30168", _
"Repair Call Drivers").Publish (True)

i'd like to replace the S: drive string with:

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!