Martin Reid
mwp.reid at qub.ac.uk
Tue Sep 19 13:45:51 CDT 2006
Given the string shown below does anyone know how to using VBA Before you can use the GUIDs from the address as arguments in this macro action, you must replace each %7B string with the { character, replace each %2D string with the - character, and replace each %7D string with the } character. Do not include the & (ampersand) character that follows the %7D string in the list GUID. The string would be of the form http://MySite12/_layouts/ViewEdit.aspx?List=%7B2A82A404%2D5529%2D47DC%2DAE13%2DAC1D9BC0A84F%7D&View=%7B357B4FE6%2D44CF%2D4275%2DB91F%2D46558301579B%7D This is out of the Access 2007 help file. Your response will be published by the way as I cant do it. Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477