P
pswanie
hi..
i got this to open a workbook. in it i tell it where to look for the
workbook. i would however like it to go and look on the entire system for
it...(including removeble drives etc..) i use it on about 14 branches and the
users (for out of stupidity?) go and move my file.....!!! thanx
The file from what the macro run is called inventry.xls
the two should be in the folder inventry. but from time to time they move
the inventry.xls to for example the desktop.
(if it can.... first look in outlook if there is a email with a attachment
with the name ghostINVENTRY.xls and then the entire system)
Phillip
************************************************************
Workbooks.Open Filename:= _
"C:\maykent\inventry\ghostinventry.xls"
************************************************************
i got this to open a workbook. in it i tell it where to look for the
workbook. i would however like it to go and look on the entire system for
it...(including removeble drives etc..) i use it on about 14 branches and the
users (for out of stupidity?) go and move my file.....!!! thanx
The file from what the macro run is called inventry.xls
the two should be in the folder inventry. but from time to time they move
the inventry.xls to for example the desktop.
(if it can.... first look in outlook if there is a email with a attachment
with the name ghostINVENTRY.xls and then the entire system)
Phillip
************************************************************
Workbooks.Open Filename:= _
"C:\maykent\inventry\ghostinventry.xls"
************************************************************