Excel Interop with Existing File?
-
I've found numerous examples on doing interop by creating a NEW Excel file, but would like to open an existing Excel file from VB.NET and interop with that. I've tried "guessing" how to modify the examples, but with no luck. Can anyone point me to an example of how to open an existing Excel file in VB.NET so I can interop with it? Thanks for any help on this...:confused: Hal in AZ
-
I've found numerous examples on doing interop by creating a NEW Excel file, but would like to open an existing Excel file from VB.NET and interop with that. I've tried "guessing" how to modify the examples, but with no luck. Can anyone point me to an example of how to open an existing Excel file in VB.NET so I can interop with it? Thanks for any help on this...:confused: Hal in AZ
hey hal, try...
myExcel.Workbooks.Open(pathToFile)
hope this helps
-jim
-
hey hal, try...
myExcel.Workbooks.Open(pathToFile)
hope this helps
-jim
Jim, Worked fine. Thanks very much! Funny that out of 3 different books no one mentioned this. Thanks again, Hal Hal in AZ