Excel 4.0 macros - yikes!

[perp1exed]

Hi,

I need to convert an Excel 4.0 xlm macro file into Excel 2010.

Currently, when I open the file in 2010 I get errors on some functions.

One of these erroneous functions is:

=ADD.MENU(B5,Main!File)

The "File" name is defined as:

File
Return to Excel ReturnToExcel r
--------------
Open... Open o
Close Close w
--------------
Save Save s
Save As... SaveAs
--------------
Print... Print p
--------------
Quit Quit q


I have no clue what kind of menu operation is going on here! Any help appreciated. In the meantime I am trying to get an Excel 4.0 environment up and running so i can see what this file actually does!

thanks,

KS

 

[mortgageman]

Hi,

I need to convert an Excel 4.0 xlm macro file into Excel 2010.

Currently, when I open the file in 2010 I get errors on some functions.

One of these erroneous functions is:

=ADD.MENU(B5,Main!File)

The "File" name is defined as:

File
Return to Excel ReturnToExcel r
--------------
Open... Open o
Close Close w
--------------
Save Save s
Save As... SaveAs
--------------
Print... Print p
--------------
Quit Quit q


I have no clue what kind of menu operation is going on here! Any help appreciated. In the meantime I am trying to get an Excel 4.0 environment up and running so i can see what this file actually does!

thanks,

KS

I believe that this subroutine is attempting to generate a custom menu.

Gene Klein