View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
jfp[_2_] jfp[_2_] is offline
external usenet poster
 
Posts: 3
Default Not the issue: running a macro saved as a string

Tom Ogilvy wrote:

http://www.cpearson.com/excel/vbe.htm


OK -- thanks.
I skimmed through this; i need to create a module in the spreadsheet,
paste the saved macro string into it, and then run the macro.
Is there a shorter/simpler way?
This is a "one-time" macro -- it reformats certain cells / column widths
etc. to make the spreadsheet more legible than that created by Access.
There is no need to save it in the spreadsheet. Seems like the ability
to build a string containing some commands and then execute it directly
would be a nice feature in a language this powerful ...