Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Open an populated Excel file
#1
Solved: 11 Years, 3 Months, 3 Weeks ago
I know to open a new Excel file, I must
Code:
Set oExcel = CreateObject("Excel.application")

But what does Set oExcel = when i want to open a previosly crerated?
Reply
#2
Solved: 11 Years, 3 Months, 3 Weeks ago
after the above you should open workbook by below like code and remaining to read cells. (googe it)

Code:
Set oWorkbook = oExcel.Workbooks.Open(excelfilepath)

Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How to export the output value of a webedit object to a new excel file. mounika6677 1 1,516 04-14-2019, 05:18 PM
Last Post: mounika6677
  Access not saved excel file randhirsinghskhn 0 1,028 09-04-2018, 07:26 AM
Last Post: randhirsinghskhn
  dtLocalSheet empty even though excel file contains data cantorre 2 2,428 05-10-2017, 12:47 PM
Last Post: vidhi
  unable to open file-new functionlibrary sirim 2 1,901 03-03-2017, 12:22 PM
Last Post: vinod123
  Getting an error to open UFT using vbs file Naresh 1 5,384 06-11-2015, 06:34 PM
Last Post: venkatesh9032

Forum Jump:


Users browsing this thread: 1 Guest(s)