WWW This site

Application Development

---

Comments

Showing last 8 comments of 102 in total (Show All Comments):

 

---

Comment by: Peter (12/22/2009 10:35:26 PM)

Italy is found on his many on multiple sheets and workbooks, but you want to find yourself on the specified workbook.
Sample
His fourth workbook is open Wb1 "Sheet1wb1, Sheet2wb1" WB2 "Sheet1wb2, Sheet2wb2" Wb3 "Sheet1wb3, Sheet2wb3" WB4 "Sheet1wb4, Sheet2wb4 and just want to find their data is" Perter "on Wb1" Sheet1wb1 "and the WB4 "Sheet1wb4. If you select "All" it will find all four workbook if the data is "Perter, also comments that his own fourth workbook still open but only to find themselves on Wb1" Sheet1wb1 and the WB4 "Sheet1wb4" and display data on the second workbook and sheet 2 is "Sheet1wb1" and "Sheet1wb4.
In short comments you want to choose to find their workbook, Sheet, Range discretion not to find out all workbook, sheet open. (4 workbook open, but only found on two or three workbook workbook rather than All workbook)

 

---

Comment by: Jan Karel Pieterse (12/23/2009 4:15:47 AM)

Hi Peter,

I see. This is not something I was planning to add however, but thank you for the suggestion.

 

---

Comment by: R Timmerhoff (1/12/2010 9:17:40 PM)

I am a newbeeee. So do you sell your code so I can try and adapt it for my use? I have many pages of data. I want to search for a word then also list several additional attribuites that are resident on the same line as the word.

 

---

Comment by: Jan Karel Pieterse (1/12/2010 11:48:52 PM)

Hi R Timmerhoff,

I'd suggest to combine your data on one sheet and use built-in functions like INDEX and MATCH or VLOOKUP to find your data from that single sheet.

 

---

Comment by: M. Block (1/15/2010 9:43:15 AM)

Good morning,

I was using the FlexFind addin and it works for searching in text boxes (via "values" and "objects" selected. However, when searching in text boxes in a paricular Excel file, an error is produced: Error 91: object variable or With block variable not set in modObjSearch.ScanObjects. This spreadsheet has a lot of fields and some pictures and text boxes; could that be contributing to the problem?

Thanks for the help,

 

---

Comment by: Jan Karel Pieterse (1/16/2010 11:40:48 AM)

Hi Monica,

It may be related to just a specific kind of object you have on that sheet. Maybe you can pin down which type by removing some objects (on a copy of your file of course!) and trying if it starts working?

 

---

Comment by: Rodp (2/4/2010 7:17:12 AM)

Hi,

I've used this program for a few years now (fantastic might I say!) however, just recently, it's been struggling a little and started to run really slow. I find that it tends to search through the given excel files (5 normally) returns the text but then doesn't return control back to the user for sometime thereafter. It seems to do a lot of extra processing / searching close to the end of the search.

I'm telling it to simply search in values across all sheets - not objects. Is there a way (through the error log perhaps)to find out what it's slowing down on?

Many thanks in advance

Rod Pestell

 

---

Comment by: Jan Karel Pieterse (2/4/2010 7:22:10 AM)

Hi Rod,

I am not aware of any Flexfind changes that might cause this. Maybe your one of files has an unexpectedly large worksheet (hit control+end to find out)?

 

---

Have a question, comment or suggestion? Then please use this form.

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].