Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to export objects to different excel sheet
I know there is an excellent from Stefan but I have not yet got an understanding
QlikTip #32: Exporting multiple QV objects to a single Excel document
So just want to ask about the following code
Why, if I replaced the SaveAs path with an xls extension, will the file fail to be recognized as a proper xls format?
Warning like "The file you are trying to open is in a different format than specified by the file extension..."
Set xlobj = CreateObject("Excel.Application")
xlobj.DisplayAlerts = false
Set wrkbook = xlobj.Workbooks.Add
Set newwrksht = xlobj.Application.Worksheets.Add
wrkbook.SaveAs "C:\test.xls" |
Thanks
I got it already, you need to define the file format as 56 for xls
wrkbook.SaveAs "C:\test.xls", 56
I got it already, you need to define the file format as 56 for xls
wrkbook.SaveAs "C:\test.xls", 56