D
D. Pirate Roberts
I have a vbscript that does the following:
1. Opens Excel file A
2. Copies data from a range of cells
3. Opens Excel file B
4. Pastes data copied from step 2 above
5. Closes Excel file A
6. Closes Excel file B
When the script reaches step 5, an Excel message says there is a large
amount of data on the clipboard and asks if I want to save the data. Is
there a way to either supress this message or feed it a Yes/No value from
within my script?
1. Opens Excel file A
2. Copies data from a range of cells
3. Opens Excel file B
4. Pastes data copied from step 2 above
5. Closes Excel file A
6. Closes Excel file B
When the script reaches step 5, an Excel message says there is a large
amount of data on the clipboard and asks if I want to save the data. Is
there a way to either supress this message or feed it a Yes/No value from
within my script?