- John Vanleeuwe
- PowerBuilder
- Friday, 24 August 2018 12:02 PM UTC
Hi all,
I need to find a certain string in an excel sheet through OLE automation. The value can be anywhere in the sheet.
Here's a small snippet of what i have got till now.
In this example i want to look in the active sheet for the word "#STARTPOSITION"
i can use the function Find for this.
Problem is , how do i know if the word was on the sheet or not ? Can i convert the result of the Find function into a string or ... ?
....
ll_last = lole_MainWorkBook.Worksheets.count
lole_MainWorkBook.Activate
lole_sheet = lole_MainWorkBook.WorkSheets(ll_ctr)
lole_sheet.Activate()
lole_sheet.Cells.Find('#STARTPOSITION')
....
TIA
John
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.