topic '4th sheet' in excel macro problem in QlikView

'4th sheet' in excel macro problem

Wed, 23 Jul 2014 12:20:39 GMT

Hi All,

Have a macro that was quite happy in excel until I added the 'bold' line (which I added because later I need to use sheet4, sheet5 etc.)

Now it fails on the 'set xlsheet bit' with 'object doesn't support this property or method 'xldoc worksheet'

Any ideas please ?

Thanks in advance

Bob

sub weeklyexport

set XLApp = CreateObject("Excel.Application") XLApp.Visible = True

set XLDoc = XLApp.Workbooks.Add

set XLDoc = XLApp.Worksheets.Add

set xlSheet=XlDoc.Woksheets("Sheet1")

xlSheet.Activate

......

end sub

m_woolf — Wed, 23 Jul 2014 13:27:22 GMT

Your bold line changes the XLDoc object from a Workbook object (previous line) to a Worksheet object

You have also misspelled worksheet in the set xlSheet line

Wed, 23 Jul 2014 13:39:30 GMT

Thanks Michael - it was the object issue