George Too, very nice code for exporting. It solved many problems. What's the syntax for launching an Excel macro in the
With ExcelApp mode?
So far I have
Set ExcelApp = CreateObject("Excel.Application")
'With the new workbook do the following
With ExcelApp
.workbooks.Open "S:\RM\Hazmat\HazmatTraining Recap.xls" 'File to open
.Visible = True
'''''''need to launch a macro from this workbook here'''''''
'Save the results.
.ActiveWorkbook.Save
'Close and quit
.ActiveWindow.Close
End With
ExcelApp.Quit
Set ExcelApp = Nothing
much much appreciated. Thank you
With ExcelApp mode?
So far I have
Set ExcelApp = CreateObject("Excel.Application")
'With the new workbook do the following
With ExcelApp
.workbooks.Open "S:\RM\Hazmat\HazmatTraining Recap.xls" 'File to open
.Visible = True
'''''''need to launch a macro from this workbook here'''''''
'Save the results.
.ActiveWorkbook.Save
'Close and quit
.ActiveWindow.Close
End With
ExcelApp.Quit
Set ExcelApp = Nothing
much much appreciated. Thank you