Copy content of one workbook to another workbook without opening both the file

[Mansoor_naz2002]

Hello All,

I am looking for a help to resolve the below scenario using macros:

I have a file called "list.xls" with the list of spreadsheet names e.g AcctA.xls, AcctB.xls, AcctC.xls, AcctD.xls,etc.,(spreadsheet name will be unique) in the column C. All these listed spreadsheets are already available in directory. I have another spreadsheet named "Printing list.xls" which is acting as master. Now, i would like to copy the content of the spreadsheet AcctA.xls, Acct B.xls, etc, which i ever i select using input box and paste it in the Printing list.xls. I would like to copy Column A, D, E and F based on the filter applied to column F has "Print" and paste it into Column D of Printing.xls

In simple words, I want to copy and paste the details without opening any spreadsheets except the list.xls which has the list of all these spreadsheets.

I hope i explained in detail which may helps to understand my requirements easily.

Thanks in advance. Early help would be much appreciated...

Mansoor

[pike]

Hi Mansoor_naz2002,
to transfer the data you have to know the full workbook paths, names and open the workbooks.

[Mansoor_naz2002]

Hello Pike,

I could able to work out partially using ado instead of opening and closing each workbook. While using getdata i could able to get and paste the data in the master file "List.xls" whereas i would like to change the destination.

GetData ThisWorkbook.Path & "\AcctA.xls", "AcctA", _
"E13:H17", Sheets("Sheet1").Range("B8"), True, False

any suggestion on changing the highlighted destination file to "Printing.xls" which is available in different path.

Also, i am able to transfer entire details from the acctA.xls instead i require Column A, D, E and F from acctA.xls to printing.xls...

Looking forward the help.....

Mansoor

[pike]

no, not really
what the complete code??

can you use

Please Login or Register  to view this content.

[Mansoor_naz2002]

Please Login or Register  to view this content.

[Mansoor_naz2002]

Thanks for your time Pike, above is the code i have modified for my requirement. but could not able to change the destination file. Also, is there any way that i can give the fields to be selected using SELECT query. because from the above codes, output shows all the COLUMNS where the ROWS meet WHERE clause criteria. I would like to select Col A, D , E & F.

[pike]

Hi Mansoor_naz2002,
can you please add code tags and your previous post

[Mansoor_naz2002]

Hello Pike, here is the tagged code, from the below code i would like to select column A, D, E & F from source file, and paste in the different destination file name.

Please Login or Register  to view this content.

[pike]

Hi ,Mansoor_naz2002

still looking with "INSERT INTO" but cant get the columns

Please Login or Register  to view this content.