Hopefully simple copy question

ArchiEMS · May 15th, 2002, 07:59 AM

I'm hoping this is a simple copying question. I have a macro that is copying data from one workbook to another. But I am closing the workbook I am getting the data from first. The save clipboard message pops up. Is there a piece of vba that I can insert in my macro that will answer this question yes so the user does not have to.

Thanks All,
EMS

Vas · May 15th, 2002, 08:10 AM

Haven't tested for this particular type of alert, but one common way is the DisplayAlerts property.

Application.DisplayAlerts = False
...

Application.DisplayAlerts = True

Ivan F Moala · May 15th, 2002, 08:15 AM

Quote:

On 2002-05-15 06:59, ArchiEMS wrote:
I'm hoping this is a simple copying question. I have a macro that is copying data from one workbook to another. But I am closing the workbook I am getting the data from first. The save clipboard message pops up. Is there a piece of vba that I can insert in my macro that will answer this question yes so the user does not have to.

Thanks All,
EMS

Hi ArchiEMS
Just clear the clipboard via
Application.CutCopymode = False
Place this after your last Copy & Paste action.

ArchiEMS · May 15th, 2002, 08:30 AM

Thanks for the help.

Vas- I tried yours with no luck, the question still waits for my answer.

Ivan- I think the problem is I want to close the workbook I am copying the data from before I have pasted it in the other workbook. I guess I need to switch to the other workbook and paste it then go back and close the other workbook. It would have been easier to just close it first. Oh well, thanks for all the help.

Thanks Again All for the help.

Sincerly,
EMS

May 15th, 2002, 08:10 AM	#2
Vas Board Regular Join Date: May 2002 Location: Gothenburg, Sweden Posts: 74	Haven't tested for this particular type of alert, but one common way is the DisplayAlerts property. Application.DisplayAlerts = False ... Application.DisplayAlerts = True __________________ /Niklas Jansson

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 07:59 AM	#1
ArchiEMS New Member Join Date: May 2002 Location: Charleston,sc Posts: 9	I'm hoping this is a simple copying question. I have a macro that is copying data from one workbook to another. But I am closing the workbook I am getting the data from first. The save clipboard message pops up. Is there a piece of vba that I can insert in my macro that will answer this question yes so the user does not have to. Thanks All, EMS

May 15th, 2002, 08:30 AM	#4
ArchiEMS New Member Join Date: May 2002 Location: Charleston,sc Posts: 9	Thanks for the help. Vas- I tried yours with no luck, the question still waits for my answer. Ivan- I think the problem is I want to close the workbook I am copying the data from before I have pasted it in the other workbook. I guess I need to switch to the other workbook and paste it then go back and close the other workbook. It would have been easier to just close it first. Oh well, thanks for all the help. Thanks Again All for the help. Sincerly, EMS