how do i extract numbers from alphanumeric file name?

**LonesomeTwin** · 02-07-2011, 12:31 PM

I'm developing (playing around!) with VBA, just getting the hang of it. How would I extract the number from my testfile_007.docm so that I can rename it as testfile_008, thus not inadvertantly wiping out anything important while i stumble around?

Thx in advance - Steve

**DonkeyOte** · 02-07-2011, 12:36 PM

If the naming convention is that consistent

Please Login or Register  to view this content.

would give you the number - where strFName is a variable which holds "testfile_007.docm"

**LonesomeTwin** · 02-07-2011, 01:08 PM

Reputation++

**LonesomeTwin** · 02-08-2011, 05:52 AM

Sorry about this but I'm a C programmer and this is all a bit... odd. I'd like to include the leading zero's for proper directory display. Yes I know explorer does it any way but humour me?

Please Login or Register  to view this content.

**DonkeyOte** · 02-08-2011, 05:56 AM

Perhaps you mean:

Please Login or Register  to view this content.

**LonesomeTwin** · 02-08-2011, 06:03 AM

Exactly so. From this shaky begiining I'm supposed to put out a report generated auotmatically from a machine. Wish me luck.

Back to solved we go then. See you again I should think.