Posts by dalgleishj72

I'm making slow progress and have been able to successfully record use and save simple macros. I did wonder whether you have the title of this book you refer to:

Microsoft issued a PDF in the 1990s which translated every Excel 4.0 macro command into a VBA equivalent ... I found that very useful during learning. I'll see if I can locate one via Google.

If I had the title I may well be able to find it in a library around here.

Thanks for your help - I don't think I would have accomplished what little I have without your encouragement and now I'm beginning to feel i could actually succeed! THANKS

An additional thought on your copy of the pdf. My brother who is England could pay you to ship it to me (I'm in the beer capital of the USA - San Diego). I'd scan it here and return it to you.

Just a thought if you trust the mail systems!

Glen this is loads of help. I've already been on the Microsoft excel board to ask if they have a copy of the pdf you mention. Your specific suggestions are illuminating to say the least and a little daunting. I learned basic in the early 70s which I found very simple (I was much younger then) and found VBA when I first looked at it had no relationship to the Basic that I had learned. That is essentially the moral here. The technology evolves. One of my macros does a series of regressions on about 50 mutual funds and interestingly it ran faster on a Mac IIfx in the early 1990s than it does today because of the increase in Excel overhead even though the computers today are way faster.

THANKS AGAIN

How difficult is it to translate into VBA. I tried when VBA came out but found it too complicated. Maybe there are better resources now. I'll look on Amazon

Yes indeed I am talking about the 'old macro sheets'.

First I apologize for not putting the code in the correct format. I had not read the forum rules - so apologies again!

I checked out your web site lots on VBA but nothing I could find on the old macros

I have pondered this for a long time. I am aware of the ability to run a second MacOS partition in a newer version of the MacOS and I'm sure Microsoft has trial versions but because most of the projects require action on spreadsheets the macros would require a lot of rewriting to effect those 'calls' on external sheets. Not impossible I accept but it just would be nicer to find someone who is using this old language and is more proficient than I, a 70 + retired person, am.

Reply to GlennUK. First I'm thrilled to hear from someone who is familiar with this wonderful old language. Do you remember if you got the old Macro Language to work with later versions of the MacOS and Excel?

The old Macro Language is excel is very different from VBA. To give you a couple of very simple examples. To format cells as a % is not something one can do with a key stroke but with these 4 lines in an excel spreadsheet you can:

Once you have designated the cell in which percentage is as an excel Macro with the keyboard equivalent of command option p. The language is very powerful and I use it to run regressions on ±50 mutual funds on a weekly basis. Excel for Mac 2011 works with this and Excel 2011 works with El Capitan so that is where I am stuck. I'm trying to find another user who has figured out what combination of Mac and Excel software will work. Hope this clarifies the issue I'm trying to get help on.

I am hoping there is someone who still uses the Excel Macro language as I do. I am currently using Mac OS El Capitan 10.11.6 and Excel for Mac 2011 on a Mac Mini late 2014. It's clear that I will have to upgrade in the future but noone I've talked to knopws about how forward compatible the excel macro language is. Does anyone here have any insight on this. Much appreciated.