This is an update to my post under tables which I now have working.
The only thing I cant do is trigger (from the Access command button),the macro contained in the xl spreadsheet that i have exported to.
I have tried setting it as a module,and referring to that,which opens the module but doesnt run the macro script.
Any ideas appreciated
The only thing I cant do is trigger (from the Access command button),the macro contained in the xl spreadsheet that i have exported to.
I have tried setting it as a module,and referring to that,which opens the module but doesnt run the macro script.
Any ideas appreciated
