A macro needs to be in the personal.xls workbook to be accessible to all Excel workbooks. Making a variable Public is irrelevant

----- aiyer wrote: ----

Hi all

A quick question. I had declared certain variables as public in
*general* module and used them in different macros to create a *.fe
file

However, I ran the macros once and it ran fine and generated a *.fe
file (let's say c.fev). I close the Excel and open it again to run th
same macros again. But this time, I get the following message quote
C:\Ansys/Model\c.fev!stati not found, where stati is one of the macro
associated with a toolbar button.

Notice that the c.fev was the one created previously and does'nt hav
to be refered any time at all. We r interested in creating more *.fe
file like that each time

Actually the Excel workbook with all the macros in it is within sa
c:\Ansys\Model. I dunno why Excel is searching the previously create
c.fev when executed the second time

Is this a bug? Is anything getting corrupted? I would appreciate you
help guys

Thanks alot
Arun....
Vtec Corp


--
Message posted from http://www.ExcelForum.com