I’m getting the Save & Save As window while opening the excel file with Excel VBO. Same pop up appeared when opened it manually. Can someone help me to disable this popup with out doing anything with object modeller.
I need to add new column in my existing collection ?
Once the column is created I need to write some values.
Is there any other approaches to deal this other than using loop stage.
How to extract the following sub string from input string using regex ?
Extract String : SP123456789.xls
Input String : I'm Indian - I like India - SP123456789.xls
[ The count of extract String always remain fixed but the number pattern will vary ]
Suggest some effective ways to search for a text in excel. (Output should be the cell reference)
- Input excel file contains 1000 of rows and columns
- Looping through each cell takes lot of time
- Need to reduce timing.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.