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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Calculate the median value before a specified list 0
Access Lock File .LACCDB / Now shows as a notepad file 0
Drop down list control value in vba 2
Update several ppt documents from a single excel file 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Internal Data Integrity (Type 4) Details Needed 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0

Top