Transferring infomation from one .xls to another

[carpoolguy]

Hi, forgive me if I seem ignorant but I don't know much vba only a few bits and pieces I use at work.

Basically what I want to do is take information from a spreadsheet, process it, then write it to another spreadsheet with the data in specific cells, yet whenever I use

Please Login or Register  to view this content.

all it does is space the information, it doesn't actually place it in a seperate cell.

So I would be very grateful if somebody could demonstrate how they would write, for example, the variables a, b and c to a spreadsheet in cell locations a2, b3 and c4 respectively.

Apologies if I haven't given enough information or I was unclear, I would appreciate help on this though.

[mehmetcik]

Please Login or Register  to view this content.

[carpoolguy]

Do you mind giving some explanation to your code? Are you saying that I don't have to specify the opened .xls file once i've opened it in vba?

[carpoolguy]

Just to clarify - the information is in two seperate files and I want to transfer it across using a third file.

[mehmetcik]

It does not matter where the macro resides so your third file is not relevent.

Just make sure all three files are opened in the same instance of excel.

I mean make sure that you ope excel once. And then open the files from within excel.

[carpoolguy]

I think I understand now, thankyou very much for your help.

[carpoolguy]

I still cannot get this to work.


Say I have input.xls like this -
input.png

I want to add A1 and B1 to create variable sum1 and display that number in C3 in output.xls in the same folder.

[mehmetcik]

Save these in the same folder

Open Book1 and click on the Button.

Please Login or Register  to view this content.

[carpoolguy]

Okay thanks that should work now.