I have a spreadsheet with 130 sheets, I need to be able to save sheets 61-130 as html, preferrably the name would be the sheetname.html.
Can one of you wizards hook me up with a script so I don't have to go through each one and set it up to publish on save?
Normally this wouldn't be a problem for me, but I intend to create several other workbooks based on this one and if I can do this via VB, then it would be easier to modify the new ones which could have a different number of sheets.
Thanks!
Brad
Can one of you wizards hook me up with a script so I don't have to go through each one and set it up to publish on save?
Normally this wouldn't be a problem for me, but I intend to create several other workbooks based on this one and if I can do this via VB, then it would be easier to modify the new ones which could have a different number of sheets.
Thanks!
Brad