find value without openig the file

  • Thread starter Radhakant Panigrahi
  • Start date
R

Radhakant Panigrahi

hello is there any way to find a specific value in excel file which is not
currently not opened howeveranother excel file is open...so is there any
wayout to find by giving any command...

Regards,
radha
 
W

walrus

Radha

One way is to type the whole path/address of the file and relelvant
sheet/cell reference:

like

='C:\Documents and Settings\User\Desktop\[Wars.xlsx]Sheet1'!$B$34
 
Top