Export to Excel not working.

[Anonymous]

Hi ,

we are facing an issue that export to excel is not working on Access point and working fine on qlikview designer(server).

what could be the possible reasons, we have added a links on trusted sites and IE v11 is installed on server.

Thanks

Manish

[vikasmahajan]

Please try this thread  Ashfauq given solution

Export to excel giving problem while export from Access Point

Vikas

[Anonymous]

Hi

I cant see Web tab on left side.

To enable that do we need to setup any other particular settings.

Thanks

Manish

[Anonymous]

typo Right* side

[ashfaq_haseeb]

Hi,

have a look at attached image.

Regards

ASHFAQ

[Anonymous]

seems to be same as you have mentioned.

have a look:

what next?

[ashfaq_haseeb]

Hi,

Do you have .csv too can you confirm?

Regards

ASHFAQ

[Anonymous]

yes.

[ashfaq_haseeb]

What exact error do you get.

Did you try from other browser?

Did you try from some other machine then server?

Can you share snapshots of error you get?

Regards

ASHFAQ

[Anonymous]

on server only IE v11 is installed i tried on that only there is nothing happening when i click on button.

below is macro script:

sub Export_reported

set XLApp = CreateObject("Excel.Application")

XLApp.Visible = true 'you can make it false, if you want to make it in the background

set XLDoc = XLApp.Workbooks.Add

XLDoc.Sheets(1).name = "Export"

set XLSheet = XLDoc.Worksheets(1)

set MyTable = ActiveDocument.GetSheetObject("CH171") 'Change TB01 to the object you want to export to Excel (Object Properties > General tab > far right)

set XLSheet = XLDoc.Worksheets(1) 'Select sheet where data should be pasted

Mytable.CopyTableToClipboard true 'Copy data to Clipboard

XLSheet.Paste XLSheet.Range("A1") 'Paste data starting at A1

End Sub

same macro is working on same server QV designer mode.

Thanks

Manish Madan