I'm new to VB and I've written a macro that opens a second spreadsheet,
pulls data, and then closes the spreadsheet. What kind of code can I
put in the macro to automatically choose the "read only" option when
opening the spreadsheet and then automatically not save changes made to
the spreadsheet and automatically not save the data on the clipboard to
use later? Any help would be appreciated. Thanks all.


--
sefus12
------------------------------------------------------------------------
sefus12's Profile: http://www.excelforum.com/member.php...o&userid=32755
View this thread: http://www.excelforum.com/showthread...hreadid=526842