Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste in VBA
Look in the Data menu as the consolidation function.
-- Regards, Tom Ogilvy "James Weaver" wrote in message ... Is there a way to copy and paste data from one file to another WITHOUT opening the source data file? In addition, is it possible to do this from multiple files. I am trying to design a financial consolidation tool to add up the same worksheet from multiple versions of the same file. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste in VBA
I have about 20 files with about 9 columns and 400 rows of
data - this function will take ages to set up...is there any other way? I was thinking of trying to write some code that will paste - special - values the entire sheet from each workbook (without opening it) into the Consolidation file and then running a sum through each of the pasted worksheets. Am just struggling with the code to get the sheets into the Consolidation file...any ideas? James -----Original Message----- Look in the Data menu as the consolidation function. -- Regards, Tom Ogilvy "James Weaver" wrote in message ... Is there a way to copy and paste data from one file to another WITHOUT opening the source data file? In addition, is it possible to do this from multiple files. I am trying to design a financial consolidation tool to add up the same worksheet from multiple versions of the same file. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste in VBA
Try this James
It will open the files(you don't see that) You find a link to a example on this page http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "James Weaver" wrote in message ... I have about 20 files with about 9 columns and 400 rows of data - this function will take ages to set up...is there any other way? I was thinking of trying to write some code that will paste - special - values the entire sheet from each workbook (without opening it) into the Consolidation file and then running a sum through each of the pasted worksheets. Am just struggling with the code to get the sheets into the Consolidation file...any ideas? James -----Original Message----- Look in the Data menu as the consolidation function. -- Regards, Tom Ogilvy "James Weaver" wrote in message ... Is there a way to copy and paste data from one file to another WITHOUT opening the source data file? In addition, is it possible to do this from multiple files. I am trying to design a financial consolidation tool to add up the same worksheet from multiple versions of the same file. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) |