M
Mishelle Graney
I've looked for some mention of this problem in the newsgroups and on
microsoft, but haven't found anything. I'd like to verify that my
problem is indeed a problem, and not just something I'm doing wrong.
I have a web application that uses the Excel Office Web Component. At
several points I want to find a cell with a particular value, so I use
the Find method to do so. In OWC9, I use the following command which
works:
Set c = Template.Constants 'Template is my OWC instance
Set rngFoundCell = rngSearchRange.Find(strStringToFind,
rngSearchAfterRange, c.ssValues, c.ssWhole)
In OWC10/11, I have the following (the constants have changed names)
Set c = Template.Constants
Set rngFoundCell = rngSearchRange.Find(strStringToFind,
rngSearchAfterRange, c.xlValues, c.xlWhole)
This works only for non-hidden cells. If the string I want to find is
in a hidden cell, it won't find it. At this point, my choices are to
loop cell by cell, or unhide everything, do the find, then hide
whatever was hidden. Both of these options are more time consuming
than I would like. I've tried using xlFormulas, since that appears to
solve the issue in Excel, but it does not seem to solve the issue in
the OWC.
Can anyone provide any insight into this issue?
Mishelle Graney
microsoft, but haven't found anything. I'd like to verify that my
problem is indeed a problem, and not just something I'm doing wrong.
I have a web application that uses the Excel Office Web Component. At
several points I want to find a cell with a particular value, so I use
the Find method to do so. In OWC9, I use the following command which
works:
Set c = Template.Constants 'Template is my OWC instance
Set rngFoundCell = rngSearchRange.Find(strStringToFind,
rngSearchAfterRange, c.ssValues, c.ssWhole)
In OWC10/11, I have the following (the constants have changed names)
Set c = Template.Constants
Set rngFoundCell = rngSearchRange.Find(strStringToFind,
rngSearchAfterRange, c.xlValues, c.xlWhole)
This works only for non-hidden cells. If the string I want to find is
in a hidden cell, it won't find it. At this point, my choices are to
loop cell by cell, or unhide everything, do the find, then hide
whatever was hidden. Both of these options are more time consuming
than I would like. I've tried using xlFormulas, since that appears to
solve the issue in Excel, but it does not seem to solve the issue in
the OWC.
Can anyone provide any insight into this issue?
Mishelle Graney