Re: A challenge for RosAsm

My opinion about Macros:

> * + reduces source size on cost of 'direct readability'

No, just puts it somewhere else so you read the heading.

> bloats the .exe (in hidden form)

This is nonsense, you get what you write with a macro.

> * + minor convenience for lazy programmers

Major convenience for efficient ones.

> * - any change in it will affect many program parts.

Reusable code is like that.

> So if I need several similar code parts, I either
> write one routine which cover all wanted variations, or
> I just copy/paste and modify as desired.

One routine for all is bloated in comparison to a dedicated algo.
Copy/paste is slow, unreliable and error prone.

> And I never would hide any code block, as parts and trails
> often can be used more than one time, so I must see it.

Must be fun with a magabyte of source in hex. :)

Regards,

hutch at movsd dot com

.

Relevant Pages

  • Re: New form of application.run
    ... I still didn't see anything in that AllSetFileProps routine that needs anything ... Sub AllSetFileProps ... I have three macros. ...
    (microsoft.public.excel.programming)
  • Mac VBA compile error - Help!
    ... I'm developing a set of macros and testing them on iMacs. ... Workbook_Openroutine) a series of subroutines in our code module. ... ' Marketing Budget Toolkit - Repair Links after sheet import ... ' Macro written Jan 2006 by Steve Knowles ...
    (microsoft.public.excel.programming)
  • Re: Automatically it should be converted
    ... Did you copy/paste to the worksheet module? ... Macros are not working when i've pasted in VB.. ... Right-click on the sheet tab and "View Code". ... Copy/paste into that sheet module. ...
    (microsoft.public.excel.misc)
  • Help: Excel Macro window run button disabled for all code in 1 module?
    ... Excel macro security level medium. ... Macros window will disable all buttons except Cancel and Edit if I ... highlight any routine from one of these modules. ...
    (microsoft.public.excel.programming)
  • Re: macro to change number format of a highlighted range in Excel
    ... but I am running a routine to remove the ... protection. ... This routine is the same as in my other macros and is working ... following error message: ...
    (microsoft.public.excel.programming)