topic Re: Open File Dialog that Works with Win7 in QlikView

Open File Dialog that Works with Win7

Fri, 14 Dec 2012 11:11:29 GMT

Hello there! The old open file dialog that I used with QLikView no longer works on Win7. The sub used "MSComDlg.CommonDialog" and this was the code for the Sub.

' Sub to show open/save dialog SUB OpenSave (varOpenSaveInputBox, varOpenSaveType, varOpenSaveFilter) ' Create object SET objComDlg32 = CreateObject("MSComDlg.CommonDialog") ' Set memory buffer objComDlg32.MaxFileSize = 260 ' Set filter objComDlg32.Filter = varOpenSaveFilter ' Show dialog IF varOpenSaveType = 0 Then objComDlg32.ShowOpen ELSE objComDlg32.ShowSave End IF ' Get filename from dialog strOpenSave = objComDlg32.FileName ' Check IF dialog is cancelled IF strOpenSave <> vbNullString Then ' Set to variable objOpenSave.SetContent strOpenSave, TRUE End If END SUB

Can anyone suggest an open file dialog that works? Thanks.

Re: Open File Dialog that Works with Win7

Anonymous — Fri, 14 Dec 2012 12:42:01 GMT

I've not tried this before, but this post (http://social.technet.microsoft.com/Forums/en-US/ITCG/thread/bd96d326-59f2-42b0-b04d-4ed65c4ce692) suggests it may be necessary to register MSCOMDLG32.OCX, albeit for Vista.

Re: Open File Dialog that Works with Win7

Fri, 14 Dec 2012 12:58:27 GMT

Yes it might work in a 32-bit system but my win7 is 64-bit. I have tried this before.