Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 macros - how to merge 5 macros together into one Sue Excel Discussion (Misc queries) 1 April 16th 08 08:36 PM
Macro Size Limit / open macros with macros? andycharger[_7_] Excel Programming 6 February 13th 04 02:00 PM
Macros not appearing in the Tools Macro Macros list hglamy[_2_] Excel Programming 5 October 24th 03 09:10 AM
Suppress the Disable Macros / Enable Macros Dialog Shoji Karai Excel Programming 5 September 24th 03 03:10 AM
List the Macros that can be executed from Tools-Macros Rob Bovey Excel Programming 1 July 10th 03 05:34 PM


All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"