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 |
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