topic Re: Browse file macro code in QlikView

Browse file macro code

bindu_apte — Tue, 24 May 2016 05:46:10 GMT

Hi,

When I searched for an sample to browse files from local machine to some path using qlikview macro.

But using that I can browse for only word or excel files, I wanted to upload jpeg or other image files.

Hence please let me know what changes I need to do in this code.

Re: Browse file macro code

tamilarasu — Tue, 24 May 2016 07:00:45 GMT

Hi,

Try this code.

Sub BrowseFolder
 Set oXL=CreateObject("Excel.Application")
 File_Name=oXL.GetOpenFilename("All Files (*.*),*.*",,"Select file",False)
 If File_Name = "False" then
 Msgbox "Try Again"
 Set oXL=nothing
 Exit sub
 End If
 ActiveDocument.Variables("vFileName").SetContent File_Name, True
 End Sub

Re: Browse file macro code

bindu_apte — Tue, 24 May 2016 09:35:40 GMT

Hi,

I tried this code but taking long time to browse and not able to copy files after browsing

Re: Browse file macro code

tamilarasu — Tue, 24 May 2016 18:18:37 GMT

Hi,

I just showed the method to browse the image file and not to copy the file to some other locations. You can use existing subroutine (second one) in your attached example.

I have suggested the above method because there are multiple reasons.

You cannot use the attached file code for certain file types (DOC, TXT nd VBS ). I was not sure about the image files. I did a test and it's not working for image file as expected.

how to browse for a file in Windows 7 (x64) ? - VBScript - Tek-Tips ‌

I found various methods to browse the files. But most of them are not elegant and not working in Windows 7.

Re: Browse file macro code

tamilarasu — Wed, 25 May 2016 08:27:45 GMT

Bindu,

You can use the below attachment.

Re: Browse file macro code

bindu_apte — Wed, 25 May 2016 09:19:39 GMT

Hi Nagaraj,

Missed the attachment. Please share.

Re: Browse file macro code

tamilarasu — Wed, 25 May 2016 09:24:40 GMT

Hi Bindu,

I have already attached the file. Please check the above reply.