If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
I modified my code and removed the portion of saving (Save As) to another excel file. Now the problem is gone, the application quits properly now.
I simplified my code and opted to just copy the records from one source file to a destination file. The excel macro file is just the middle man. Now, got another problem though, I can't save the destination file after copying the records.
Here's my code:
Dim xlsAppSource As Excel.Application
Dim xlsAppDest As Excel.Application
Dim rowDestSheet1 As Integer
Dim rowDestSheet2 As Integer
Dim cntFiles As Integer
cntFiles = 1
rowDestSheet1 = 5
rowDestSheet2 = 5
Set xlsAppDest = New Excel.Application
xlsAppDest.Workbooks.Open ActiveWorkbook.Path & "\" & "Report-CONSOLIDATED.xls"