Modifying a macro   

Hi, I've got a workbook with 27 web queries. I've set up a macro to modify a 
portion of those web query URLs. Each query has my account # 207853. I'd 
like to pass on this file to others, to where they can pull up their 
information with their separate acct #.

Now, I can tell them to go into Tools, Macros & select the macro, then edit 
it, and do a control E-E to replace my number with theirs and the next time 
they open the file, their data downloads.

Only thing is I'd like to make it even easier, by just plugging their acct # 
in a cell and it modifies the macro file automatically, so that they don't 
have to go putzing around the macro

Is that doable?

TIA

date: Sat, 10 Mar 2007 20:55:20 GMT   author:   Bob Smith

Re: Modifying a macro   

On Sat, 10 Mar 2007 20:55:20 GMT, "Bob Smith"
 wrote:

>Hi, I've got a workbook with 27 web queries. I've set up a macro to modify a 
>portion of those web query URLs. Each query has my account # 207853. I'd 
>like to pass on this file to others, to where they can pull up their 
>information with their separate acct #.
>
>Now, I can tell them to go into Tools, Macros & select the macro, then edit 
>it, and do a control E-E to replace my number with theirs and the next time 
>they open the file, their data downloads.
>
>Only thing is I'd like to make it even easier, by just plugging their acct # 
>in a cell and it modifies the macro file automatically, so that they don't 
>have to go putzing around the macro
>
>Is that doable?
>

Yes.  Post the code (or relevent parts thereof) that you have now.

-- 
Dick

date: Sat, 10 Mar 2007 15:49:56 -0600   author:   Dick Kusleika