[Joe G]

Thanks for the fast response, however, although the solution seemed to work the first time and created the result I wanted: 0001 , there were two spaces (or nulls) in the macro following the 0001. When I ran the increment step the second time to increment the macro to 0002, I got the following error:

*******************************************
10/9/2008 5:07:04 PM: Building project step 'Increment_macro_number'...
Error expanding macros or script in property MacroValue: <Error at Line 1, Column 23 (Expected ')')
Code: vbld_PadLeft(CStr(0001>

10/9/2008 5:07:04 PM: Step 'Increment_macro_number' failed
***********************************************

When I went back to the Macro "PRODUCT_VERSION_NUMBER" and trimmed the trailing spaces(nulls, blocks?), the increment solution worked and the result was 0002, however, again there were spaces or nulls trailing the 0002.

Is there a way to eliminate or trim the spaces (nulls or blocks)?

TIA