| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting from another file
I am combining information from one file to another. I ran a macro to cut and paste the information and it works except that the macro will stop and say the standard 'there is information on the clipboard, do you want to be able to paste..." that I have to answer yes to before it will transfer the information to the second file. Is there something I can wirte in the coding so I can bypass this? My macro is
Sheets("Graph Data").Select Range("b134:G258").Select Workbooks.Open Filename:= _ "C:\Retail\DirectConsolidated.xls" Sheets("Graph Data").Select Range("B4:G128").Select Selection.Copy ActiveWindow.Close ActiveSheet.Past I would appreciate any help!! Thanks Marie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extracting a date from a comment field in an excel file | Excel Discussion (Misc queries) | |||
| Extracting data from one xls file and input into another xls file | Excel Discussion (Misc queries) | |||
| Extracting First Name | New Users to Excel | |||
| Extracting text from one file to another | Excel Discussion (Misc queries) | |||
| Extracting File Names and Properties | Excel Worksheet Functions | |||
Threaded Mode
