importing data on workbook_open

Posted by carter on November 01, 2001 12:33 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 Todd on November 01, 2001 12:47 PM

Try:
before step 4,
Application.DisplayAlerts = False
After step 4,
Application.DisplayAlerts = True

Posted by Richard S on November 01, 2001 6:14 PM

Or Application.CutCopyMode = False ? (nt)