Unable to fetch data from unsaved excel

Question

I am accessing one application.Through application one excel file is getting open(not saving it in downloads,directly opening).Now I need to read data from the unsaved excel.Is it possible that without saving the file,can we read the data??I have tried the below code:

Set objExcel = GetObject(,"Excel.Application")
Set objWorkbook = objExcel.WorkBooks("143317473_1.xls")
Set NewSheet = objWorkBook.Sheets.Item(1) 
GetValuesFromUnsavedExcelFile = NewSheet.Cells(2, 1)

I am getting error: "Subscript out of Range at line 50".

So,is it necessary to save file before reading it??

Did the solution help?

Gurmanjot Singh
– Gurmanjot Singh

2017-05-26 06:08:10 +00:00
Commented May 26, 2017 at 6:08 — Gurmanjot Singh
– Gurmanjot Singh, Commented May 26, 2017 at 6:08
yes..@Kira.. thanks..

Rupali
– Rupali

2017-05-31 02:24:42 +00:00
Commented May 31, 2017 at 2:24 — Rupali
– Rupali, Commented May 31, 2017 at 2:24

Gurmanjot Singh · Accepted Answer · 2017-05-23 17:22:27Z

3

I ran your code and it worked fine for me only If I provide the correct name of the workbook. I got the error mentioned by you only when I provided incorrect workbook name, so you need to be sure about the workbook Name.

Also, If there is only one workbook opened at the time this code is running, you can very well use the currently active workbook as below:

Set objWorkbook = objExcel.ActiveWorkBook

Also, to answer the 2nd part of your question, No, It is not necessary to save the excel before you can read it.

answered May 23, 2017 at 17:22

Gurmanjot Singh

10.4k2 gold badges22 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to fetch data from unsaved excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related