September 15th, 2004, 09:56 AM
|
|
Contributing User
|
|
Join Date: Sep 2004
Location: Braunschweig , Germany
Posts: 39
Time spent in forums: 44 m 5 sec
Reputation Power: 5
|
|
check wether an excel file is open or not and search for a value in that workbook
Hallooo all
I have to open and search a value in an excel file from Access VBA searching alone is ok but if I run this programme again its opening one more copy even it is already opened. so please help me how to check and search in both cases ( I mean if it is not open we have to open and search other wise only activate that work book and Search for a value).
Please help me I tried for 6 days for this and I can't wait any more.
I appriciate any response.
Thanks a million in advance.
Kiran Karnati. 
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
