Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Every one,
i need a huge help form your side my requirment is store the all current selection in all sheets with single name...og book mark object
if i am selecting created book mark object all sheets with saves selection are all selected..
pleas help on this
Many Thanks
vasu.i
Hi Kaushik,
here we have a proble for displying logged useName in a Text object..
plz help me how the process is in Qlik view...
Many Thanks Kaushik
With Regards
vasu.I
Hi,
You can use the osuser() for user of operating system or qvuser() for qlikview user.
Create a textbox and put "=osuser()" or "=qvuser()"
Regards,
Kaushik Solanki
yes i foun this metho but what i am trying is....
my user name is vasu
and i have folder called vasu in my mechine
also i have different folders with respective user
ex: user satish has satish foler in my mechine...etc...,
so my problem
i need to tranfer the file what floder has for loges user it will store that folder only
if vasu was login then transfers the file will be moves into vasu's folder
if satish will login then transfers file will be moves into satish folder
Here my Macro code for transfering the text file from a table box object
Sub TabDelimitedText
set obj = ActiveDocument.GetSheetObject("TB36")
obj.Export "D:\Kumar\New\MyText"&Date()&".txt",","
End Sub
here i am trying like this obj.Export "D:\"&qvuser()&"\Filename.txt",","
it is not wroking
plz hlep me on this..
Many Thanks Kaushik
vasu.I
Hi kasuhik,
how to pass the variables in Marcos ....
in that process i store the user name in one variable like vUser
and it stors the data Qvuser()
then i need to use this variable in the above marco...
is it possible...........?
Many Thanks
vasu.I
Hi,
Use below code to get variable in macro and use its content.
set v = ActiveDocument.Variables("Variable1")
msgbox(v.GetContent.String)
Regards,
Kaushik Solanki
Thanks kasushik very helpful answer
with Regards
vasu.I
Hi kaushik i need one more help on exprting / improting the book marks when user click the button
for ex: all selections are done and output data set will be shown in one tablebox
when i am transfering the data that time only book mark will be export in xml formatt,,
how it is possible....
plz help me on this....
Many Thanks
vasu.I
Hi,
By bookmark you mean to say the Selections...?
Regards,
Kaushik Solanki
yes...
in bookmark we have a option like Import and export...right...
manually we r doing okay,,
but how to handle the with buttons.....those two process..(Import/Export)
Many Thanks
vasu.I
Hi,
You can use
ActiveDocument.ExportBookmarks "test.qbm" - For exporting
ActiveDocument.ImportBookmarks "test.qbm", 0 - For importing
Here 0 means Use most Recent
1 means Use CUrrent
2 means Use IMported
3 means Use All