Posted to microsoft.public.excel.programming

Paul

external usenet poster

Posts: 661

Problem With A Pesky Question during a Macro

When running the below macro I get a dialog box asking if I want to keep &
use the data on the clipboard, which of course I do since I am pasting it
just a few lines down.
How can I keep this from happening?

Sub CopyTable

Windows("table.csv").Activate
Range("A1:G486").Select
Selection.Copy
ActiveWorkbook.Close
Range("W6").Select
ActiveSheet.Paste

End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pesky spaces	Richard	Excel Discussion (Misc queries)	1	February 7th 08 06:53 PM
Pesky VLookup !!!	Lacklustre	Excel Worksheet Functions	4	February 24th 05 04:51 AM
Pesky little problem with no solution?	Bony Pony	Excel Worksheet Functions	5	February 2nd 05 03:15 PM
Pesky Autofilter Toggle	Digory	Excel Programming	4	November 14th 04 03:06 PM
Pesky Ckeckboxes !	Neil	Excel Programming	0	September 10th 03 04:06 PM

All times are GMT +1. The time now is 03:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us