Hi!
I have a link table and by that when i write in excel sheet , the value are changing in Access table. But when i write in access table (thorugh a formaula for example) then I have to INITIALIZE the link using LINK MANAGER and then i have the values updated in excel sheet. Is it poosible to have a macro , when executed, update the link by itself??
This new macro i will connect in SWITCHBOARD for example.
I have a link table and by that when i write in excel sheet , the value are changing in Access table. But when i write in access table (thorugh a formaula for example) then I have to INITIALIZE the link using LINK MANAGER and then i have the values updated in excel sheet. Is it poosible to have a macro , when executed, update the link by itself??
This new macro i will connect in SWITCHBOARD for example.