ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Bug on macros! (https://www.excelbanter.com/excel-programming/294998-bug-macros.html)

aiyer[_14_]

Bug on macros!
 
A custom button was created in a toolbar. The custom button was rename
to 'Static Analysis'
and a macro (stati) was assigned to it. There is a 'Main' menu and
sub menu 'Analysis Type' was created within the 'Main' menu. Th
custom button named 'static analysis' was then linked to the sub men
'Analysis Type', by normal drag method, with the 'Customize' box/windo
still open.

Another macro 'fev' does the writing operations and creates the *.fe
file and saves the file. (Let's say c.fev crated in the same folde
where the Excel workbook is located. The user can browze pick th
location to save the file). Certain public/global variables ar
declared which are used both by the macro 'fev' and macro 'stati'. Th
Excel workbook is closed. The next time when the same Excel workbook i
opened and the same operations performed gives some error messages lik
quote "c.fev' cannot be found". It should'nt be refering to/searchin
for this 'c.fev' file at all for any of the operations it performs
'c.fev' is just a generated file from the previous run.

I don't understand why it would do this. Would appreciate your help o
this.

Thanks,
Arun Iyer

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


pikus

Bug on macros!
 
To be of any real help we'll need you to post your code. - Piku

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



All times are GMT +1. The time now is 11:03 AM.

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