Excel Doubts

[vinay]

Hi can anyone please answer the following questios thank you

1. You have 7 attachments in your mail, how wil extract their ids?
2. I have some used rows in excel like I have 350 rows in first excel sheet, 550 rows in second and 700 rows in third one Everyone it is changing how to find that?
3. I have some data in excel, I have one data item has string, how to find that string is available in That excel sheet or not?

 

[VJR]

Hi Vinay,

I have a few questions on your requirements-

1. Are you using MapiEx or Email object for getting the attachments?
Is there any specific purpose for finding the IDs?
And what are Ids of attachments?
Are you not able to get the file names when you save the attachments?

2. A solution that I provided you earlier in another post already had the answer but you totally ignored that and asked the same query again .
Are you not doing the initial research on the actions of the existing MS Excel VBO. I suggest you to do that first. Only then learning can happen and this is for your own good.
There is a ready made action for this.
Can you find out and come up with the action name here.

3. How many columns are there in this sheet?