topic Re: Macro to paste from Clipboard to Qlikview variable in QlikView

Macro to paste from Clipboard to Qlikview variable

Fri, 11 Jul 2014 07:31:28 GMT

Can anybody help me write a macro to paste a string/number from Clipboard to QV variable.

Thanks

Abhishek

m_woolf — Fri, 11 Jul 2014 12:08:20 GMT

A little Internet research hints that vbscript can't access the clipboard directly.

A suggestion is to use an application (Excel?) to paste from the clipbaord.

Then store the value into the QlikView variable.

Fri, 11 Jul 2014 12:14:16 GMT

Thanks for the suggestion.

I am currently using excel only. But when I use excel , I need to perform a reload to get the results back to Qlikview.

Can we copy data from excel to a Qlikview variable using Macro?

Thanks in advance for the solution.

m_woolf — Fri, 11 Jul 2014 12:35:56 GMT

sub ClipboardToVariable

Set XLApp = CreateObject("Excel.Application")

XLApp.Visible = False

Set XLWorkbook = XLApp.Workbooks.Add

Set XLSheet1 = XLWorkbook.sheets("Sheet1")

XLSheet1.select

XLSheet1.Range("A1").select

on error resume next

XLSheet1.Paste

set v = ActiveDocument.Variables("vFromClipboard") 'Replace vFromClipboard with your QlikView variable name

v.SetContent XLSheet1.Range("A1").value,True

XLWorkbook.Close False

set XLSheet = nothing

set XLWorkbook = nothing

XLApp.Quit

set XLApp = nothing

set v = nothing

end sub