Hi all,

I created a spreadsheet that a number of users have on their hard drives --
I'm wondering how I can make code updates to their files without actually
opening their files? I was wondering if there is a way that I can create a
"fix file" with the updated code that when the user clicks on a button in the
"fix file", the code in this "fix file" will do the following:

1 - Identify the file that needs to be updated (maybe by having a menu that
comes up that allows the user to navigate through their hard drive (like
windows explorer) and select and/or open the file that needs to be updated)
2 - Once the file on their hard drive is identified/open, the "fix file"
will copy the code that exists in say module 1 of the "fix file" and then go
to say module 8 of the user's file and paste over any existing code in module
8.
3 - The user's file will then save

Any help you can give me is appreciated! If there is something that exists
on the internet somewhere that details how to do this, that would be great.

Thanks.

--
Robert

Change your distribution method:

1. Create a public copy of the file on a shared network drive or SharePoint,
etc.

2. Establish some kind of publish/subscribe system to e-mail the user
community that a new version is available after you have made modifications

3. Give the users instructions to download the latest version


Basically this is a Burger King way of doing business rather than a Red
Lobster approach. Don't play waiter, bring meals to the counter, not the
individual tables.
--
Gary''s Student - gsnu200766


"robs3131" wrote:

> Hi all,
>
> I created a spreadsheet that a number of users have on their hard drives --
> I'm wondering how I can make code updates to their files without actually
> opening their files? I was wondering if there is a way that I can create a
> "fix file" with the updated code that when the user clicks on a button in the
> "fix file", the code in this "fix file" will do the following:
>
> 1 - Identify the file that needs to be updated (maybe by having a menu that
> comes up that allows the user to navigate through their hard drive (like
> windows explorer) and select and/or open the file that needs to be updated)
> 2 - Once the file on their hard drive is identified/open, the "fix file"
> will copy the code that exists in say module 1 of the "fix file" and then go
> to say module 8 of the user's file and paste over any existing code in module
> 8.
> 3 - The user's file will then save
>
> Any help you can give me is appreciated! If there is something that exists
> on the internet somewhere that details how to do this, that would be great.
>
> Thanks.
>
> --
> Robert

GS - love your illustration!
susan

On Jan 31, 6:37*am, Gary''s Student
<GarysStud...@discussions.microsoft.com> wrote:
> Change your distribution method:
>
> 1. Create a public copy of the file on a shared network drive or SharePoint,
> etc.
>
> 2. Establish some kind of publish/subscribe system to e-mail the user
> community that a new version is available after you have made modifications
>
> 3. Give the users instructions to download the latest version
>
> Basically this is a Burger King way of doing business rather than a Red
> Lobster approach. *Don't play waiter, bring meals to the counter, not the
> individual tables.
> --
> Gary''s Student - gsnu200766
>
>
>
> "robs3131" wrote:
> > Hi all,
>
> > I created a spreadsheet that a number of users have on their hard drives--
> > I'm wondering how I can make code updates to their files without actually
> > opening their files? *I was wondering if there is a way that I can create a
> > "fix file" with the updated code that when the user clicks on a button in the
> > "fix file", the code in this "fix file" will do the following:
>
> > 1 - Identify the file that needs to be updated (maybe by having a menu that
> > comes up that allows the user to navigate through their hard drive (like
> > windows explorer) and select and/or open the file that needs to be updated)
> > 2 - Once the file on their hard drive is identified/open, the "fix file"
> > will copy the code that exists in say module 1 of the "fix file" and then go
> > to say module 8 of the user's file and paste over any existing code in module
> > 8. *
> > 3 - The user's file will then save
>
> > Any help you can give me is appreciated! *If there is something that exists
> > on the internet somewhere that details how to do this, that would be great.
>
> > Thanks.
>
> > --
> > Robert- Hide quoted text -
>
> - Show quoted text -

Thanks Gary. Yeah, I thought about this after posting it last night -- the
reason I didn't want to go that way in the first place was because each user
will have their own set of unique data stored within the spreadsheet and I
wanted to avoid requiring the users to re-input data into the spreadsheet
everytime there was a new version. What I should have realized all along is
that I can have code within the new version that pulls the needed data from
each user's older version. I'm guessing that's the best way to do this. If
not, please let me know.

Thanks!

--
Robert


"Gary''s Student" wrote:

> Change your distribution method:
>
> 1. Create a public copy of the file on a shared network drive or SharePoint,
> etc.
>
> 2. Establish some kind of publish/subscribe system to e-mail the user
> community that a new version is available after you have made modifications
>
> 3. Give the users instructions to download the latest version
>
>
> Basically this is a Burger King way of doing business rather than a Red
> Lobster approach. Don't play waiter, bring meals to the counter, not the
> individual tables.
> --
> Gary''s Student - gsnu200766
>
>
> "robs3131" wrote:
>
> > Hi all,
> >
> > I created a spreadsheet that a number of users have on their hard drives --
> > I'm wondering how I can make code updates to their files without actually
> > opening their files? I was wondering if there is a way that I can create a
> > "fix file" with the updated code that when the user clicks on a button in the
> > "fix file", the code in this "fix file" will do the following:
> >
> > 1 - Identify the file that needs to be updated (maybe by having a menu that
> > comes up that allows the user to navigate through their hard drive (like
> > windows explorer) and select and/or open the file that needs to be updated)
> > 2 - Once the file on their hard drive is identified/open, the "fix file"
> > will copy the code that exists in say module 1 of the "fix file" and then go
> > to say module 8 of the user's file and paste over any existing code in module
> > 8.
> > 3 - The user's file will then save
> >
> > Any help you can give me is appreciated! If there is something that exists
> > on the internet somewhere that details how to do this, that would be great.
> >
> > Thanks.
> >
> > --
> > Robert