Hi!
I´m fairly new at VB.
I have an a bit complicated issue that i hope someone can help me solve.
I want to use a script to open the last excel spreadsheet in an increment range as for example Order-1.xls, Order-2.xls, Order-3.xls and so on, in a partly known directory name in an unknown parent directory, based on the partly known directory-name as search criteria.
Eks.
F:\Order\xxxxx\093011141534_zzzzz\Order-3.xls
Folder: F:\Order\ is known
Folder: \xxxxx\ is unknown
Folder: \093011141534_zzzzz\ is partly known, and 093011141534_ is the unique search criteria
File: Order-3.xls I want to open the last file in an increment range starting with Order*
Is it possible to solve, or is it to many variables?
If anyone could help, it would make my day!
I´m fairly new at VB.
I have an a bit complicated issue that i hope someone can help me solve.
I want to use a script to open the last excel spreadsheet in an increment range as for example Order-1.xls, Order-2.xls, Order-3.xls and so on, in a partly known directory name in an unknown parent directory, based on the partly known directory-name as search criteria.
Eks.
F:\Order\xxxxx\093011141534_zzzzz\Order-3.xls
Folder: F:\Order\ is known
Folder: \xxxxx\ is unknown
Folder: \093011141534_zzzzz\ is partly known, and 093011141534_ is the unique search criteria
File: Order-3.xls I want to open the last file in an increment range starting with Order*
Is it possible to solve, or is it to many variables?
If anyone could help, it would make my day!
