A command button to import from closed workbook

[breynolds0431]

Hello. I am attempting to create an analysis workbook with three tabs. The first would be a variance table using formulas to compute differences between the other two tabs (which would be "Old Data" and "New Data"). My question is, how would I create a command button on "Old Data" to import from a separate workbook into the "Old Data" tab, as the first tab is using formulas from "Old Data"? I would then apply the same method to the "New Data" tab, if this is a possibility.

Thank you for any ideas.

 

[Smitty]

See: ADO/DAO to retrieve data from closed workbooks.

 

[breynolds0431]

It seems like ADO/DOA require the import location to be predetermined. Does this work with using a open file dialogue box to select the workbook to import?

See: ADO/DAO to retrieve data from closed workbooks.

 

[Smitty]

It seems like ADO/DOA require the import location to be predetermined. Does this work with using a open file dialogue box to select the workbook to import?

I don't see why you couldn't capture the filename before you launch into the import routine. You could use the GetOpenFileName method to do that. I can post code for it if you like.