L
luxeterna70
I want to link fields in an Access query to the same fields in an already
exisiting Excel template (with set up formulas etc). Basically so I don't
have to retype everything. This would be similiar to how you can link
workbooks in Excel so that if changes are made to one, the specifically
linked fields will adjust their data as well upon opening the other linked
workbook. Can someone point me in the right direction? Do I want to write a
macro in Access/Excel or do I need to write VBA. I just need to know where
to start my reading on this...
thanks
exisiting Excel template (with set up formulas etc). Basically so I don't
have to retype everything. This would be similiar to how you can link
workbooks in Excel so that if changes are made to one, the specifically
linked fields will adjust their data as well upon opening the other linked
workbook. Can someone point me in the right direction? Do I want to write a
macro in Access/Excel or do I need to write VBA. I just need to know where
to start my reading on this...
thanks