Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macro Size Limit / open macros with macros? | Excel Programming | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
List the Macros that can be executed from Tools-Macros | Excel Programming |