VB Code to copy without opening the file

[rizmomin]

Hello:

Please refer to attached 2 excel files, one named as "Source" and other called "Destination".

I need VB Code in "Destination" file to perform following:

Without opening the Source file, I would like to copy cell B2:D12 from "Source" file to "Destination" file @ column letter shown in cell D1.

I have manually copied as shown in "Destination" file.

Please have a look and let me know if any questions.

Thank you

Riz Momin

[rizmomin]

Hello:

Can someone help with this thread please.

Appreciate all the help i can get.

Thank you

Riz Momin

[notreallyIT]

There are ways to do this, querying the file as you would an sql database, but this is over my head to help with.


Can I ask why you dont want to open the file?

[rizmomin]

Hello:

I will be copying data from lots of different files and hence i do not want to open.
Just to let you all know that i am already using this feature with the below code successfully to paste at the fixed location at Cell "E5".
I need to modify the code so that the column # reference is picked up from cell D1 of the active sheet.
Please open the 2 excel file uploaded at the BEGINNING of this thread.

Example: if Cell D1 = L, then "E5" needs to be replaced with L5.

Please Login or Register  to view this content.

Basically I want to modify the last line in above code where "E" needs to be variable and value can come from String called colpaste1.


I hope this clear and would appreciate for any help.
Thank you

[rizmomin]

Hello:

I have managed to solve the problem.
Have changed the last line of the above code to:

Please Login or Register  to view this content.

And works great.

Riz Momin