View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Terry Pinnell[_4_] Terry Pinnell[_4_] is offline
external usenet poster
 
Posts: 192
Default Macro organisation?

Many years ago I wrote quite a few Excel macros using 'XLM Macros'.
After some googling today I understand that there's no simple way to
convert these automatically to VBA? Is that correct, even roughly?

If so I guess I'll delete those that are no longer useful to me and
live with the rest making a this drop-down list rather hard to use:

https://dl.dropboxusercontent.com/u/...-29May2016.jpg

(Note that I've combined successive small screenshots to show this in
its entirety, largely for my own reference, as I see no way to export
the list as text.)

What has me puzzled is why recently added VBA macros from Claus which
I've pasted in don't get assigned to PERSONAL.XLS!? In contrast, I
just added an ultra simple VBA macro myself (with the Recorder) and,
as you see, that did.

--
Terry, East Grinstead, UK