ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Public variable usage! (https://www.excelbanter.com/excel-programming/295010-re-public-variable-usage.html)

Tom Ogilvy

Public variable usage!
 
Sounds like you did a SaveAs of the workbook that contained the stati macro
to create the fev file. Therefore, the onaction property of control was
remapped to the .fev file.

--
Regards,
Tom Ogilvy


"aiyer " wrote in message
...
Hi all!

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

However, I ran the macros once and it ran fine and generated a *.fev
file (let's say c.fev). I close the Excel and open it again to run the
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 macros
associated with a toolbar button.

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

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

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

Thanks alot.
Arun.....
Vtec Corp.


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





All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com