Hi,
What I want to do is to export selected data in to an existing sheet in an existing .xlsx file.
For instance this part I have:
sub exportToExcel
'==============================================================
' File Path & Name
Path = "C:\KPI\CARRIERS\2017"
FileName = "Carrier KPI v0.1"
strSaveFile = Path & FileName
'==============================================================
'Open Excel
set oXL = CreateObject("Excel.Application")
oXL.visible=True
oXL.Workbooks.Add
aSheetObj=Array("TB23") ' Chart ID's here
'==============================================================
The sheet name I want it to be added to, is "RawData", I also want to keep all existing sheets and have the exported data just added in the lines below of the data already in th sheet "RawData".
Hope you can help me.
Kind regards,
Ronnie
