Open Workbook With Visual Basic (VB)Jul 10, 2007
I am trying to open a closed workbook, auto update and save. Here is the code i have so far:
Dim xlBook As Excel.Workbook
xlBook.Open(FileName:="C:Old Tanglewood Numbers.xls", UpdateLinks:=1)
Now, the xlBook.Add() line is something I just added. I am not sure if it works but i dont think it does. Everytime i try to use Workbooks.Open it tells me that i need to decalre Workbooks, which i thought i did with xlBook. Anyway, I cant get it to work, something is throwing it out of whack.