[RESOLVED] Linking Two Excel Documents Together

[Sasaraii]

I've got something I'm working on here for a client at work, but suddenly do not know if this is even possible.

Now, basically he wants a macro or something in excel to take values out of one spreadsheet and put them into another spreadsheet.


I figured I would just create a button for him to click on and it could do its thing.


The problem is that I'm not sure if its possible to do something like this in the first place. These are two seperate excel documents that I'm working with here. Is there any way to work with two documents at the same time to do what I want?

The only thing I can think of is to press the button on the first document, grab the information and store it in a file or something somewhere. And then for him to open the other document, hit a button and it would grab that information from the external file and store it in that document.


I've only been programming for a year, and have not done much VBA at all and certainly not something dealing with two completely seperate documents at once. I'd love for him to be able to press one button and it all happens, but I have a feeling that this is either not possible dealing with excel or that it would take a lot of work.

If anyone knows anything about this please let me know. Or any other ideas would be appreciated as well.


I was thinking I could try and link it together with a few windows scripts, but that might just make it more confusing for the client anyway, and I want to avoid that.