topic Why this code is not working in qlikview with 64 bit? in QlikView

Why this code is not working in qlikview with 64 bit?

jagannalla — Mon, 11 Jul 2011 09:38:59 GMT

Hi,

The following code is working in qlikview 32bit but, it is now working in 64 bit.

Can one help me y it is not working. To work in 64 bit what steps i need to take it.

// Code for Open save dialog box

Function SaveQuery

Set objDialog = CreateObject("MSComDlg.CommonDialog")

objDialog.MaxFileSize = 256

objDialog.Flags = &H80000 + &H4 + &H8

intResult = objDialog.ShowSave()

BrowseForFile1 = objDialog.FileName

MSGBOX(BrowseForFile1)

End Function

Why this code is not working in qlikview with 64 bit?

magavi_framsteg — Mon, 11 Jul 2011 09:52:24 GMT

So......

What is it that's not working with your function?

It would REALLY be a lot more easy to help you if you could just provide us with a little more detail.

Re: Why this code is not working in qlikview with 64 bit?

jagannalla — Mon, 11 Jul 2011 10:31:45 GMT

Sure Magavi...Actually i implemented this code in qlikview 32bit to open save dailog box when i click the button. It is working fine. But, when i implemented in another system which having qlikview 64bit it throughs an error.

I'm attaching my qvw file also.

Why this code is not working in qlikview with 64 bit?

Thu, 13 Oct 2011 10:04:41 GMT

Plz tell me someone, so that i can also work on it....

Need your help..

Why this code is not working in qlikview with 64 bit?

Thu, 13 Oct 2011 10:24:28 GMT

Jagan N ,You can go in the tool properties in status bar and then there is a Edit Module option . You can write there any type of MACROS.

Why this code is not working in qlikview with 64 bit?

swuehl — Thu, 13 Oct 2011 11:23:11 GMT

Sometimes searching the outer MS world is quite helpful (just putting MSComDlg.CommonDialog and X64 in Google):

http://www.msghelp.net/showthread.php?tid=88579

So, maybe use GetOpenFileName function instead?