Pre-determining or setting DivID for publishing from Excel t

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.
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,455
Members
410,612
Latest member
MrACED
Top