deyken
12-13-2011, 06:22 AM
Hi There,
Is there a reasonably easy function/method that I can use in code to locate a particular string in a large Excel spreadsheet.
At the same time, I need to perform this function to begin a loop iteration at the row directly after this string ocurs. Can I then use ActiveCell.Row to locate the row number of this string, once found?
Finally, is there a way I can put this Macro of mine into a globally accessible area, like the Quickaccess Toolbar? This macro iterates through several hundred rows of data and uploads it to a SQL Server Database on our work network. I want a few users to be able to use this Macro, without now having to build this macro into every new spreadsheet they need to work with...
Any help appreciated!
Is there a reasonably easy function/method that I can use in code to locate a particular string in a large Excel spreadsheet.
At the same time, I need to perform this function to begin a loop iteration at the row directly after this string ocurs. Can I then use ActiveCell.Row to locate the row number of this string, once found?
Finally, is there a way I can put this Macro of mine into a globally accessible area, like the Quickaccess Toolbar? This macro iterates through several hundred rows of data and uploads it to a SQL Server Database on our work network. I want a few users to be able to use this Macro, without now having to build this macro into every new spreadsheet they need to work with...
Any help appreciated!