Minty
AWF VIP
- Local time
- Today, 14:54
- Joined
- Jul 26, 2013
- Messages
- 10,354
I would use something like
Code:
Dim xlApp As Object 'Excel.Application
Dim xlWB As Object 'Workbook
Dim xlWS As Object 'Worksheet
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set xlWB = xlApp.Workbooks.Open(strSaveFile )