I currently have several hundred excel files which each have 3 sheets. Some of the files have been saved with the first sheet open, some with the second sheet open, and some with the third sheet open. When one of these files is opened it automatically opens to the sheet that was displayed when it was saved last.
I need to write a program that opens each of these files, does some formatting, makes sure cell A1 is selected in each sheet, and make sure the first sheet is open when it is saved, so it opens with the first sheet showing. I'm new to ActiveX, but I've already figured out the formatting, and I'm doing formatting in all 3 sheets. I just can't figure out how to choose which cell is selected and which sheet is displayed.
Thanks for the help,
Jeremy
Jeremy Backer
CLAD
