Global Variables

[Homegrownandy]

I've never used one and I don't anticipate this to work first time. I'm curious (Yes I have googled, couldn't see what I'm looking for)



Can I create a global variable in access and use that in excel?

In access I'm generating a file based on some fields. This file will be saved in a specific location.

Excel will then open up and run a macro of its own. At them moment I am using the file dialog (defaulted in the correct place) to pick the file I have just made.

I am trying to eliminate this step.

I'm happy creating a function and calling it, but does it matter it's in a different application?

Just some general advice is what I'm after to avoid wasting time if I'm wrong.

[Minty]

You can open the Excel file from Access (as you know the location), wouldn't that achieve the goal ?

[Homegrownandy]

Im opening the excel file already and I'm calling the macro within excel.

This opens the file dialog to select a word document I have just made in access.

Edit: sorry for not being clear, but the file dialog is ran in excel and is used to find a new file just created with a unique name in a specific location.

[Minty]

Ok, why not store the file path in the newly created excel document in a specific cell, and use that?

[Homegrownandy]

The excel file is constant, but thats a good idea. Didn't even think of doing it that way.
Thanks a lot.