I am trying to export a table from a QlikView document but one of the columns has a field value "DEC08" within it. When pasting the table to Excel from within VBScript it is converting this value into an integer which Excel is then formatting as a date.
I do not want this to be converted into a number as it is a Document Number and not a date. Does anyone know if there is a way to stop this happening?
This is the part of the VBScript I'm trying to fix:
'Create the files
set XLApp = CreateObject("Excel.Application")
XLApp.Visible = false 'you can make it false, if you want to make it in the background
set XLDoc = XLApp.Workbooks.Add
XLDoc.Sheets(1).name = "SB_Export"
set XLSheet = XLDoc.Worksheets(1)
set MyTable = ActiveDocument.GetSheetObject("CH147")
SET p = MyTable.GetProperties
set XLSheet = XLDoc.Worksheets(1) 'Select sheet where data should be pasted
Mytable.CopyTableToClipboard true 'Copy data to Clipboard
'you can remove another line if you have subtotal that you want to remove