kelly_huffman
15 years agoNew Contributor
Capturing window name using Exel 2007
Hi,
I'm trying to capture a windows name using Set window = process.Form("New Folio - Crossfire Designer"). It never returnes a value. (Took the code snip from the help files Work with the ribbon command bars.) What the heck am I doing wrong?
OS - XP service pack 3.
Excel 2007 (Crossfire is an add in)
Here is the code so far.
Sub Test
Dim process, window, ribbon, tabs, tagging_tab
Dim ribbon_area
Set process = Sys.Process("EXCEL") - returns the process yay!
Set window = process.Form("New Folio - Crossfire Designer") - Fail
End Sub
I'm trying to capture a windows name using Set window = process.Form("New Folio - Crossfire Designer"). It never returnes a value. (Took the code snip from the help files Work with the ribbon command bars.) What the heck am I doing wrong?
OS - XP service pack 3.
Excel 2007 (Crossfire is an add in)
Here is the code so far.
Sub Test
Dim process, window, ribbon, tabs, tagging_tab
Dim ribbon_area
Set process = Sys.Process("EXCEL") - returns the process yay!
Set window = process.Form("New Folio - Crossfire Designer") - Fail
End Sub