searching directories for a workbook

  • Thread starter Thread starter kimt
  • Start date Start date
K

kimt

I am getting close to having completed a program (shell) which processe
new employee information into several formats and manages an operation
personnel functions. The questions I am faced with are;

This is not a networked operation, the program will be installed o
each ops manager comp. which means that the worksheet names wil
always be the same ( I can control that) but the program itself will b
in various directories. I am searching for a way to have the followin
take place from a VB 6 shell.

Is there a way to search through a computers drives (regardless o
their designation) and find, then open the file with the following
type of code

prjPersonnel
frmMenu
cmdPrintCards

search mydocuments (will always be my documents) Employee Maste
Data.xls

open the excel application

Locate and load the workbook'

I suspect "My Documents" will likely be in C: drive, but not always.

Anyway, will entertain any ideas.

Thanks in advanc
 
This would scare me a little. I'd be afraid that I'd pick up a
backup/historical version in the wrong folder.

Maybe you could have the user just specify its location--by pointing at it???

Or keep track of where you found it last time (ini file??) and have them start
there.
 
Thanks Dave, your probably right...somehow It would get messed up.
think I will have the shell open with the workbook.
It won't be as slick but will take a lot of the potential problems ou
of it.

Thanks agai
 
Back
Top