Is it even possible to pass a variable from Excel to Access? I have a report which has the source directory for all the files in cell M5, I then need to run a query in Access which needs to pick up this source directory in order to open and save all the files. I thought maybe declaring it as Public would work but somehow I doubt it's that easy. The Access macro is run with a simple .run command.