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:

Sheets("CCSUM_Repair_CallDrivers").Select
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:
"ftp:\techgate.cs.rogers.wave.ca~rwynterpublic_htmlRepairCallDrivers.htm"




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!

Categories