topic Re: Macro to save the QVW file with User Name in QlikView

Macro to save the QVW file with User Name

karthickv — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can you please share a macro which can help me to perform a reload & save the file with User Name ?

Lets say I have a Sales.qvw file, upon clicking the button, macro should run and the file should be reloaded & saved as Sales K1234.qvw. Where K1234 is the OSUser Name or QVUser Name.

Thanks,

Karthick V.

Re: Macro to save the QVW file with User Name

zhadrakas — Tue, 04 Apr 2017 11:16:39 GMT

hi,

create the variable "vUser" with Definition =subfield(OSUser(),'\',2)

Then use this macro

sub Reload_Save
set docprop = ActiveDocument.GetProperties
Filename = docprop.FileName

set v = ActiveDocument.Variables("vUser")
Username = v.GetContent.String

ActiveDocument.Reload
ActiveDocument.SaveAs left(FileName, len(FileName)-4) & " " & Username & ".qvw"
end Sub

Re: Macro to save the QVW file with User Name

tamilarasu — Tue, 04 Apr 2017 12:11:46 GMT

Tim,

Just thought of sharing this line without creating a variable.

sub Reload_Save

set docprop = ActiveDocument.GetProperties

Filename = docprop.FileName

Username = ActiveDocument.Evaluate("subfield(OSUser(),'\',2)")

ActiveDocument.Reload

ActiveDocument.SaveAs left(FileName, len(FileName)-4) & " " & Username & ".qvw"

end Sub

Re: Macro to save the QVW file with User Name

karthickv — Tue, 04 Apr 2017 13:44:41 GMT

Many thanks for your Response Tim. It worked.

Re: Macro to save the QVW file with User Name

karthickv — Tue, 04 Apr 2017 13:47:23 GMT

Thank you so much for your response.

Nanri Tamil.

Re: Macro to save the QVW file with User Name

tamilarasu — Wed, 05 Apr 2017 07:55:39 GMT

No problem bro. Have a good day!!