drill through to SSAS CUBE


G

Guest

I use the drilthrough macro posted on MS site for drilling through from
Excel to the cubes and i get
a runtime error1004 when drilling through

Happens only when the xls is put in a IIS Web server virtual directory and
when i try to open it from the browser then it gives an error

After clicking end in the error screen the drill through continues, but it
seems that the code to delete the temporary sheet does not work.

(Delete the temporary sheet Application.DisplayAlerts = False ws.Delete … )

Result: the drill through result is shown twice: once in the sheet: sheet2 ,
once in the sheet Drill Results1

Can somebody help
 
Ad

Advertisements

G

Guest

Sub copysheet()

Windows("book1.xls").Activate
Workbooks("book3.xls").Worksheets("Mar 07").Copy _
after:=Worksheets("Sheet1")
ActiveSheet.Name = "newsheetname"


End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top