MrExcel Publishing
Your One Stop for Excel Tips & Solutions

importing data on workbook_open


Posted by carter on November 01, 2001 12:54 PM

i created a macro for imported data using "record":
1. open the file
2. copy data
3. paste data
4. close file
Problem is: At (4) it asks the user if they want info on clipboard. It gets annoying after a few times.

Is there a better (but still easy) way to automate importing?


Posted by Mark W. on November 01, 2001 12:59 PM

Take a look at 4161.html (nt)