Hi,
I want to built a "find all" macro that will find all the shape with a specific shape data and list all these shape in a pop-up window (something like a list in a msgbox) and let the user to choose wich one he want to see. Something like the "findAll" in excel
Is there something already done into visio...
For the moment, I find a way to loop through all pages and all shapes to find the matching shape, and now I will need to built a custom form and redo what the "findall" in excel do... (big job)
Any suggestions
The enclosed file should get you started. But there's still a lot of work.
Consider units, sub-shapes, other pages, multiple conditions, etc.
Wow, perfect.
The ID of a item is unique on one page... but if I worked on multiple page, I will need to search throught all page (ok, no problem) and memorize the page and the ID of the found Item... what the best way to do that : create a structure an memorize that into the struct or just add it in the listresults in two column
Your code work perfectly... in fact, you already do 80% of what I need... (THANKS A LOT)
The last thing is I want to be able to clik on a shape and execute the search by using the filed PROP.A of the shape that I was click on... so, fill some parameters of the search windows by using the info of the clicked shape, or, pass some parameter to a function
Can you give my an idea
1) searching in multiple pages:
There are unique IDs that you could create (built in function --> google). But I haven't tried to address shapes independently from their pages. So I'd prefer to use a structure as suggest, but a two column list is already such a structure. So use this simpler solution.
2) pre-fill the dialog:
get the selected shape (set shp = activewindow.selection(1) )
iterate through its prop section (use the macro recorder to get the commands)
fill a fields list with the results.
Top notch would be to display ALL the fields of the shapesheet.
Cheers,
Y.
Browser ID: smf
(is_webkit)
Templates: 1:
Printpage (default).
Sub templates: 4:
init,
print_above,
main,
print_below.
Language files: 1:
index+Modifications.english (default).
Style sheets: 0:
.
Hooks called: 54 (
showintegrate_autoload, cache_get_data, integrate_pre_load, integrate_load_session, integrate_verify_user, cache_get_data, integrate_user_info, integrate_load_board, cache_get_data, integrate_board_info, cache_get_data, integrate_allowed_to_general, integrate_allowed_to_general, integrate_boards_allowed_to, integrate_mod_cache, integrate_allowed_to_general, integrate_pre_load_theme, cache_get_data, integrate_allowed_to_general, integrate_simple_actions, integrate_allowed_to_general, integrate_load_theme, integrate_pre_log_stats, cache_get_data, integrate_actions, integrate_pre_parsebbc, integrate_bbc_codes, integrate_bbc_print, integrate_post_parsebbc, integrate_pre_parsebbc, integrate_bbc_print, integrate_post_parsebbc, integrate_pre_parsebbc, integrate_bbc_print, integrate_post_parsebbc, integrate_pre_parsebbc, integrate_bbc_print, integrate_post_parsebbc, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general, integrate_menu_buttons, integrate_current_action, integrate_theme_context, integrate_allowed_to_general, integrate_allowed_to_general, integrate_allowed_to_general)
Files included: 25 - 922KB. (
show/home/iw0lkfe3x6cq/public_html/vgforum/index.php, /home/iw0lkfe3x6cq/public_html/vgforum/Settings.php, /home/iw0lkfe3x6cq/public_html/vgforum/cache/db_last_error.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/QueryString.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Subs.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Subs-Auth.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Errors.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Load.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Security.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Subs-Compat.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Subs-Db-mysql.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Cache/CacheApi.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Cache/CacheApiInterface.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Cache/APIs/FileBased.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Subs-Charset.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Unicode/Metadata.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Unicode/QuickCheck.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Session.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Logging.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Class-BrowserDetect.php, (Current Theme)/languages/index.english.php, (Current Theme)/languages/Modifications.english.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Printpage.php, (Current Theme)/Printpage.template.php, /home/iw0lkfe3x6cq/public_html/vgforum/Sources/Unicode/CaseUpper.php)
Memory used: 747KB.
Tokens:
post-login.
Cache hits: 8: 0.00180s for 22,301 bytes (
showget modSettings: 0.00057s - 19982 bytes, get known_languages: 0.00028s - 1277 bytes, get board_parents-0: 0.00027s - 2 bytes, get permissions:-1: 0.00014s - 50 bytes, get theme_settings-1: 0.00016s - 980 bytes, get hostlookup-216.73.216.125: 0.00001s - 0 bytes, get log_online-update: 0.00032s - 10 bytes, get menu_buttons--1-english: 0.00004s - 0 bytes)
Cache misses: 2: (
showget hostlookup-216.73.216.125, get menu_buttons--1-english)
Queries used: 11.
[Show Queries]