joefrench
Active Member
- Joined
- Oct 4, 2006
- Messages
- 357
I am creating an excel file with which i'd like to automate publishing to HTML format. Can I have one macro that will publish the "active sheet". It seems that I am running into a problem with the "DivID" portion of it. I know of no way to predetermine this value or set it to accept the "active sheet".
This is what I currently have:
With ActiveWorkbook.PublishObjects.Add(xlSourceRange, _
"\\Cjdata1\design engineering common\ENGINEERING_STANDARDS\customer\" & ActiveSheet.Range("a1").Value & ".htm", "2821227", "$A$1:$T$38", _
xlHtmlStatic, , "1952_27894", "281227")
.Publish (True)
End With
My problem being the "1952_27894"
Any suggestions or comments are welcome.
This is what I currently have:
With ActiveWorkbook.PublishObjects.Add(xlSourceRange, _
"\\Cjdata1\design engineering common\ENGINEERING_STANDARDS\customer\" & ActiveSheet.Range("a1").Value & ".htm", "2821227", "$A$1:$T$38", _
xlHtmlStatic, , "1952_27894", "281227")
.Publish (True)
End With
My problem being the "1952_27894"
Any suggestions or comments are welcome.