Old Macros (Excel 97)

Topic

New Reply

I have an Excel Workbook that I have been using for some time, it has been upgraded to EX 97. I thought that it was time to update the macros that I use with that sheet. They are from EX 4 and are in a .XLM sheet.

Now my problem, I can

Reply | Quote

Replies

Although I haven’t used Excel 4, I think you should find the macros are still in your workbook. Instead of being on a sheet, though, you’ll find them by pressing Alt+F8 (or Tools/Macros/Macros)

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

Or you can go straight to the Tools…Macros…Visual Basic Editor (Alt-11) to see where macros are stored now. Do this after you record a simple macro using Tools…Macro…Record and you have something to find when you get there.

The move from old-style keystroke macros to command macros and now…to object-oriented VB macros can be intimidating. I still remember my old File Save macro in Lotus: “/FS~” Simple!

Most people put their VB macros in a module attached to the Workbook, but only visible to you in the VB Editor. It’s not a tab in the Workbook. Experiment with the record macro feature and the VB editor and you’ll start to get the picture. In the VB editor there’s online Help specifically for macros.

Reply | Quote

I have tried all the sugeastions, and still can NOT find the connection between the worksheet and the old macros that are contained in a XXX.xlm sheet. But they do work!

I also do not have either a Personal.xls, nor Global.xlm.

Very mystified!

Reply | Quote

I have never worked with XL4 macros in later versions of XL, so I am not sure where they are kept. I do know that in XL4 they were kept on a worksheet. So, it would be worth a try to select Sheet from the Format menu. If Unhide is not disabled in the pop-up menu, select it and see if the XL4 macro sheet is hidden.

If the workbook is not propritery or too large, you can upload a copy ane we will see if we can find the macros for you.

Reply | Quote

You can still use Excel 4 macro sheets in all recent versions of Excel. The sheets may be hidden, and if you cannot unhide them by using Format. Sheet, Unhide try the following code in a general VBA module :

Sub ShowXMSheets
Dim ws As Worksheet
For Each ws In ThisWorkbook.Sheets
    If ws.Type = xlExcel4MacroSheet Then
        ws.Visible = True
    End IfNext
End Sub

Hopefully that will expose them.

Andrew C

Reply | Quote

If what you’re looking for is the connection between the workbooks and the Excel 4 XLM macros that are called, have you looked in defined names in the workbooks.

One way to call macros automatically in the old days ( Excel 2.1, Excel 3.0 ) was to insert a name in the workbook called AutoOpen and have the reference be the string of the path and name of the macro sheet with the required macro name. E.g. “C:ProgsMyProc.XLM!DoProcess”

Glenn.

Reply | Quote

Glenn;
Thanks a lot, you put your finger on it.

It had been quite a long time and I could not remember where to find it. Your info got me to it right away.

Now if I can just convert it.

Reply | Quote