Macro to dinamicaly define the search string

[#1]

I want to do this: A user type in a field value to search in an input box and a macro defines what needs to be searched.

In example: the user types in C and 3 searches will be defined:

C,

*,C*

*C,*

I want to do this because when the user searches for C I don't want to include VC CS, etc, I just want C and C in a comma separated list.

The data source is a mess so sometimes a value is correct but someothers a row groups different values in a list (comma separated).

Can you guys help me?

[johnw]

Do you have the APIguide.qvw in your Documentation folder? If so, that's a very good reference for looking up things like this, and is pretty much how I'm answering your questions. For instance, go to the Automation Examples tab, type "bookmark" into the search box, and over on the left you'll see a member, "CreateBookmarkObject". That sounds promising, so click on it.

ActiveDocument.Sheets("Main").CreateBookmarkObject

Not exactly a complete answer, but it's a start, and at least lets us know it's possible.

For your other question, these are field methods, so clear and pick a class of Field. Looks like there's a GetPossibleValues method. You can also see this on the Automation Members tab. There are a number of different methods that return lists of values. Probably one or more of them are what you're looking for.

[#3]

Great, I'll try that.

Also I don't want to bother you with more questions besides this: Where can I find a full reference of these automation objects? In the pdf that comes with QlikView I found only a few examples.

[johnw]

So far as I know, the APIguide.qvw IS the full reference. I'm not aware of any PDF or other sort of documentation that covers them.