| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extracting from another file
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 ActiveSheet.Past application.CutCopyMode = False ActiveWindow.Close -- Regards, Tom Ogilvy "Marie" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extracting from another file
Thanks Tom, It worked!! But...now it is asking me if I want to save the file I am extracting the information from. What code do I need to use to say yes to that?
"Tom Ogilvy" wrote: 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 ActiveSheet.Past application.CutCopyMode = False ActiveWindow.Close -- Regards, Tom Ogilvy "Marie" wrote in message ... 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 |
| Reply |
| 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 | |||
Hybrid Mode
