Is it possible to pass a variable from Excel to Access?

[XLEAccessGuru]

If I have an excel worksheet and want to pass a boolean variable from the worksheet to Access, is this possible?

 

[KeithG]

What you could do is save the variable to a cell on the spreadsheet and then write a function in Access to look up the value in the Excel cell.

 

[XLEAccessGuru]

Great idea. Why didn't I think of that?

 

[KeithG]

Sometimes you just need an outside opinion.

 

[XLEAccessGuru]

Oh you have no idea how often that happens! You know how you get so close to a project and you're working on it all day long? You tend to lose sight of the obvious! It takes another person to tell you.

Thanks!!!