Macro is not running in Accesspoint

[#1]

Hi,

I am using Qlikview Personal Edition 11.2

I wrote macro as:

By selecting patient in list box, it should  the read the chart properties and create an excel with that data in a specified path.

In my PE version, its working. But when I try to run from accesspoint, its showing issue.

I am opening the dashboard with IE plugin only.

Can anyone reply how to run macro in accesspoint.

Thanks,

Sahithya

[#2]

Macro : Reading chart 148 properties into excel named patient ina a specified path.

Macro is as below :

Sub Test

XlsPath = "c:\lab\patient.xls"

Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Add()
Set objWorksheet = objWorkbook.Worksheets(1)

set table = ActiveDocument.GetSheetObject( "CH148" )

For RowIter = 0 to table.GetRowCount-1
For ColIter = 0 to table.GetColumnCount-1
set cell = table.GetCell(RowIter,ColIter)
objWorksheet.Cells(RowIter+1,ColIter+1).Value=cell.Text
Next
Next

objWorkbook.Saveas XlsPath
objWorkbook.close
objExcel.quit

end sub

[#3]

Hi Sahitya Garu,

Myself I am Sireesha.I am from Hyderabad.Don't mind me as this rely is not related to your question.I am entirely new to Qlik View and i have working experience on cognos.I am very much interested to learn Qlik View.I have seen your posts in Qlik community and thought you are the one from whom i can get help.i want to get trained from a real time employe rather than an institute over here.

Please let me know if anyone is giving training for the same...

Looking forward to hear from you...

Thanks for your help in advance..

Regards,

Sireesha Meka

[richard_chilvers]

I have the same problem with a macro which is designed to create a file on the external network.

I look forward to more ideas on what the issue is.

[#5]

You can go through reference manual and Qlikview tutorial.

[aveeeeeee7en]

Check this:

http://community.qlik.com/message/540526#540526

[#7]

Thank you Sahitya...

Regards,

Sireesha

[richard_chilvers]

Have you checked that Access Point is using the IE plugin?

When you load AccessPoint, next to where it says Welcome Sahithya, it will say Favourites & Profile.

Click here to make sure the PlugIn is being used.

[#9]

IE plugin only selected there