Hi,
Does anyone have sample code to 1) open an excel spreadsheet, 2) gather the contents of a range, 3) close the spreadsheet, and repeat the process in a loop? I had partial success until Excel starting a dialog asking me if I want to save the spreadsheet. I didn't change anything, so I don't know why it would ask. I tried issuing a command to save before I quit, but that didn't work. I don't know how to either respond to that dialog, or prevent it from appearing in the first place. Any and all help would be appreciated.

Thanks,
Don Pieta