Can I create an Environmrnt String from a Variable

[Scott A. Will]

I create a variable in an Access function. From Access I
invoke a MS Excel Macro. I want to pass the variable from
the function to the Excel Macro.

Since an excel macro can not use variables from an access
function I thought I could write the variable to an
environment string and then call the environment string
from the macro.

So with this said:
Can I create an Environmrnt String from a Variable?

Please advise

 

[Douglas J. Steele]

I'm not sure you can create global environment variables, and any variable
that you created in your Access session wouldn't be available to other
sessions.

Can you use Automation to invoke the Excel macro, passing it a value when
you do?

 

[M.L. Sco Scofield]

Even if you could, you shouldn't.

Information should be passed as arguments.

See http://support.microsoft.com/default.aspx?scid=kb;en-us;198571 for some examples of how to use automation (as Doug suggested) to
call an Excel function and pass information to it.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com