how to store all current selection in all sheets in a single BookMark object?

[#1]

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

[#2]

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

[kaushiknsolanki]

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

[#4]

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

[#5]

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

[kaushiknsolanki]

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

[#7]

Thanks kasushik very helpful answer

with Regards

vasu.I

[#8]

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

[kaushiknsolanki]

Hi,

   By bookmark you mean to say the Selections...?

Regards,

Kaushik Solanki

[#10]

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

[kaushiknsolanki]

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