Hi, i have two folders, one for source and the other for reports
I have 20 linked tables to the xls files in the source folder
and 50 reports that write to the report folder
The paths are now all hard coded
How can i parametrize the linked tables path?
Also want to parametrize the path of the report output path, so that in future if the source and report folder locations are changed then i should be able to update the access db by just changing the path parameter
Thanks
-srinivas y.