Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    East Tennessee
    Posts
    179
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Old Macros (Excel 97)

    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
    Win 8, Firefox 16.0.2, Thunderbird 15.0.2

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Old Macros (Excel 97)

    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
    [MS MVP - Word]

  3. #3
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Old Macros (Excel 97)

    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. <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

    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.
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  4. #4
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    East Tennessee
    Posts
    179
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Old Macros (Excel 97)

    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!
    Win 8, Firefox 16.0.2, Thunderbird 15.0.2

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Old Macros (Excel 97)

    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.
    Legare Coleman

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Old Macros (Excel 97)

    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 :<pre>Sub ShowXMSheets
    Dim ws As Worksheet
    For Each ws In ThisWorkbook.Sheets
    If ws.Type = xlExcel4MacroSheet Then
    ws.Visible = True
    End IfNext
    End Sub</pre>

    Hopefully that will expose them.

    Andrew C

  7. #7
    Lounger
    Join Date
    Oct 2001
    Location
    Isleworth, Gtr London, England
    Posts
    28
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Old Macros (Excel 97)

    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.

  8. #8
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    East Tennessee
    Posts
    179
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Old Macros (Excel 97)

    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.
    Win 8, Firefox 16.0.2, Thunderbird 15.0.2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •