Variable Scope - XLM Macro calling VBA Macro
Posted by Bill on September 22, 2000 11:11 AM
I have a worksheet with macros written in XLM - the old Excel 4 macro language. The XLM code sets a variable and then later calls my VBA program:
=SET.NAME("FileNm",GET.DOCUMENT(88))
=RUN(vbCreate)
From within the VBA program, is there any way to expose the XLM variables so I can get the data in the VBA program?
It appears to me that the SET.NAME actually sets up a name in the Insert Names box, but I can not seem to access it from VBA.
Any help would be appreciated.