Must be a simple way to do this ...

[we44]

I've hunted everywhere and found related answers but none that specifically do this simple request:

I have 2 excel files (excel 2000), call them file A and file B.
Each has a single worksheet with data.
I want to combine these two separate worksheets into a NEW file with 2 worksheets, ie. file C with Worksheets A and B.

I don't need any processing of the data or manipulation in any way, just a straightforward copy of the data into the new file.

Ideally I'd like a means to open a dialogue box pointing at a predefined NAS share (or C:/ drive) where I can select the two source files without the need to have them open. The target file will be created with the 2 tabs (in alphabetical order of source filename), and remain open on completion of the data transfer for user validation.

Any help appreciated.

 

[bensonsearch]

Hi,

for the dialog box to open you would need the macro in one of the files (or a separate third file) which then opens the workbooks, copies the data and closes them.

as far as i know the only way to do it. Is this something your after?

 

[we44]

Having the macro embedded in the target file would be OK as I could always ensure a "Save As" process follows from that to preserve the integrity of the "master" target file, if that makes sense.

I've come across add-ins too which sit within the core excel functionality and are therefore available to all excel files through the data menu option. I was thinking whether I could use this and convert the resulting macro to an add-in process.

 

[we44]

Have found the code I need and works as I want it to