Public variable usage!
Sorry misread your question. But the module with the public variables would still have to be in Personal.xls to be available to all excel workbooks
----- 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 |
All times are GMT +1. The time now is 03:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com