Importing Disaster

[mriggio]

I am importing data from a mdb database and am running into a problem. I have formulas in the excel file that refer to the imported data however, when the data is imported from Access it automatically inserts a new sheet (is. Data_Results). Now, if I put formulas in the excel file and refer to Data_Results!, then save it; when the file is imported nothing works. A dialogue box appears saying information is being taken from a separate file and all this and that but I want the file to be "ready" to refer to the imported sheet everytime it is opened (the imported sheet always is inserted with the same name).

Thanks!!

 

[dtaylor]

you will need to code the file to always import to a predefined sheetname. just add a few lines that ativates the desired sheet and copies the imported data to that sheet. this way you will be able to always ref that sheet.

something like this before the import process begins.

Sheets("DataTransit").Activate
ActiveSheet.Range("a1").Select

hope this helps

dan