ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   find value without openig the file (https://www.excelbanter.com/excel-discussion-misc-queries/262627-find-value-without-openig-file.html)

Radhakant Panigrahi

find value without openig the file
 
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

walrus

find value without openig the file
 
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


"Radhakant Panigrahi" wrote:

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



All times are GMT +1. The time now is 12:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com