Import data macro

  • Thread starter Thread starter Ro477
  • Start date Start date
R

Ro477

I have an Access2002sp3 Access.mdb database with a macro in it which
exports data to a costdata.xls workbook or file (it has only one sheet in
it).

Is it possible to have a macro in my excel2002sp3 report.xls workbook to
import the data from the costdata.xls file into a new sheet created in the
report.xls workbook ?

thanks .. Roger
 
Yes, you can setup a routine that first will open the file costdata.xls copy
Sheet1 into report.xls and then close the costdata.xls file to keep it as
the original set of data.
 
Dear Michael

thanks for your reply, but it lacks the actual detail that I am looking for.
I certainly am able to manually open anothe file and copy/paste the data
into my report.xls sheet, but I am still puzzled in regard to whether it can
be done using a macro. The reply from Mike on this same post is interesting,
and I will try that to see how it goes

.... Roger

ps ... I can see no "YES" button at the foot of your reply !
 
Back
Top