abdb469
asked on
excel project - macro tasks need amending 2
I need the existing macro in this template to be amended please so that a new "Application ref" number column to be inserted between line count column and Fund name column. The application reference (only the number prefix part) could be taken either from the name of the file or from a field I can create from one of the "criteria selections" on worksheet 2.
Thanks.
Summary-macro-test--1-.xls
Thanks.
Summary-macro-test--1-.xls
ASKER
If its a time consuming issue, dont worry about it. i will simply rename the x in the name to something else (as long as that wont get read either!). I only have 40 or so, it wont take me more than a few mins.....but it was just the principle that if had files with a slightly different name....
Thx.
Thx.
Oh, I am working on a solution - wont take too long.
It's silly that VBA wont just see numerics as numerics!!
It's silly that VBA wont just see numerics as numerics!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect. :)
thanks.
thanks.
Currently working on a way to check each digit and see if it is a 0 through to 9.