Open an Excel file using Word VB Editor

[Krispy2293]

I am trying to open a certain Excel file using VB editor in Word. I have used the Shell function to open Excel, but am having trouble opening the spreadsheet. Does anyone know how to do this?

Thanks!

 

[Nikita6003]

Why not go for the good ol' automation way:

Dim l_objXL as Excel.Application
Dim l_wkbToOpen as workbook


Set objXL = CreateObject("Excel.Application&quot
l_objXL .Visible = True
Set l_wkbToOpen = l_objXL .Workbooks.Open ("C:\Path\File.xls&quot

'<code to do stuff with the xl file, if needed>

'Close workbook
l_wkbToOpen.Close

'Release objects
Set l_wkbToOpen = Nothing
et l_objXL = Nothing


HTH

Cheers
Nikki ;-)

 

[Krispy2293]

Thanks! It's working great!