View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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/