Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.

Read the value of a cell from another excel file without opening it

Read the value of a cell from another excel file without opening it

You have an excel file at location D: (example D:fromdata.xlsx ) and you want to read its cell value E2 and put it inside the file located at C: (example C:todata.xlsx ) Open your file at C:todata.xlsx go to Developer Tab and then insert a button copy below codes and paste between the Command Button click (just below Button1_Click())

Dim wkbk1 As Workbook
Set wkbk1 = Workbooks.Open("D:fromdata.xlsx")
Dim cellvalueofdatafile As Variant
cellvalueofdatafile = wkbk1.Sheets("Sheet1").Range("E" & 2)

ThisWorkbook.Sheets("Sheet1").Range("A" & 1) = cellvalueofdatafile
now we have the cell value of E2 (of D:fromdata.xlsx, Sheet1) in the variable cellvalueofdatafile which can be put it inside your file A1 by using the formula ThisWorkbook.Sheets("Sheet1").Range("A" & 1) = cellvalueofdatafile Save it as macro enabled file

caa October 25 2023 129 reads 0 comments Print


Leave a Comment

Please Login to Post a Comment.
  • No Comments have been Posted.

Sign In
Not a member yet? Click here to register.
Forgot Password?