does this require a macro in access?

  • Thread starter Thread starter J_J
  • Start date Start date
J

J_J

Hi,

I have two problems...associated with access & excel
I need to display an excel worksheet region on an access form.
My XL workbook beeing "abc.xls" and the involved region C3:F12 on Sheet3.

I can do that by activating the excel workbook, copying the region to memory
and then after running the access file pasting it to the involved form space
in "design" mode of Access Form. And after that when I save the changed
access file it holds the pasted excel info as it "was"...
So far so good. But unfortunately the info that is beeing pasted from the
excel sheet includes some "time" informatin and that changes each munite as
the XL macro executes at minute intervals. Now the "abc.xls" file is active
and the time figure changes on the excel file but not on the access form.

Here are my questions:

1. What should I do to activate my "C:\data\abc.xls" file automatically just
before my access file is beeing executed?
2. How can I configure my access file so that when the data imported from my
"abc.xls" file changes (due to the macro running in excel) the displayed
data on access form also will change?
Hope my questions are not to easy or hard for the NG.

Sincerely
J_J
 
Back
Top