two questions about screenshots/exports

[kemperohlmeyer]

1) How do i tell vba to cycle through sheets in a workbook? Essentially i need a macro to run through each sheet, export as html (i know that part) and then go to the next sheet and repeat.

2) Each of the aforementioned sheets is very wide (about 80-150 columns). When i export i need the first five columns on the left and then some random (and changing) columns in the middle. It is easy to view with a simple pane freeze, but i don't know how to translate that into an exported view.

Thanks in advance.

ko

 

[hatman]

1) like this:

Dim Item as WorkSheet

{code}

for Each Item in ThisWorkbook 'note, any workbook object will work here

  {code}

Next Item

2) Depending upon how you are performing the export, it may be sufficient to Hide the columns that you don't want displayed, perform the export, then unhide them when you are done...