I don't know how to tell whether they use Roaming Profiles. I expect so, only because when you log in there is an AppData directory which has three subdirectories: Local, ?LocalLow (or something like that), and Roaming. Excel creates a 2K .pip file in the Roaming directory structure when it runs. However, this file does not change when Excel gets reconfigured (configure the add-in and enable macros), so it looks like that is not where these settings are stored.
I do not know what server they run (I don't have access to any of their systems). Is there some way to determine this from the client end? I am confident it is something relatively recent, although maybe not the latest and greatest. We tend not to be leading edge on upgrades, as you can see from just now starting to install Win7 client systems.
So, these Roaming Profiles - how would one configure the Add-Ins for the users? I assume there is an admin app that configures things somehow? Or, they configure things for one user and then capture those settings somehow?
And yes, I know I am opening a slight window of problems by enabling macros. However, I am confident that students are not downloading Excel spreadsheets (other than my own). My sheets have some macros, I don't know any other way to make them work.
--- In ExcelVBA@yahoogroups.com, "Pascal" <pascaldaulton@...> wrote:
>
> I'm no expert on this, but does the college use Roaming Profiles?
> I'm fairly sure excel add-ins are included in such a profile.
> What server version is being used?
>
> re: "I'm being told by my IT people that this just cannot be done"
> Yes, this sort of answer always leads to a raised eyebrow or two; perhaps they don't know how to do it, or can't be bothered to do it or it's against 'policy' and they're not telling you that to save you/them taking it further.
>
> Having a roaming profile that includes what add-ins are available/installed in Excel would seem like a very-common-and-useful-thing-to-have - I cannot see it that Windows 7 and a modern Server would not allow it.
>
> However, when it comes to enabling macros automatically, that may be a bit more difficult - for obvious reasons.
>
>
>
> --- In ExcelVBA@yahoogroups.com, "robert_brewington" <robert_brewington@> wrote:
> >
> > Not sure if this is the right place for this; I'm being told by my IT people that this just cannot be done, so I'm looking for cleverer people that make it happen.
> >
> > The problem: I have a number of computers in three separate computer labs in a high school environment (roughly 30 computers in each room). Students will sit at any of the computers on any given day and log in through the network.
> >
> > I need the computer to have Excel2007 configured for the student when they log in:
> > - I have an Excel add-in which needs to added to the add-in list.
> > - macros need to be enabled (so the add-in works).
> >
> > Up until now (Win XP), we created a default user which was configured as desired. When the student logs in the first time their account is created based on the default account. Apparently Windows 7 does not work this way and "there isn't any way to do it".
> >
> > I have certainly established that the students cannot configure Excel when they log in. Well, they can eventually get it, but it takes 20 minutes of a 40 minute period:( The next time they come in they have to do it all over again - another half period gone.
> >
> > One thing I tried: I thought maybe I could find registry entries corresponding to the Excel configuration settings, so I could write a program to update the registry when the student logs in. Unfortunately, I couldn't find anything that looked like that; maybe someone knows where the settings are maintained?
> >
> > I have a pretty extensive background in programming, but not much experience in system admin. If I need to do admin stuff, I will have to relay the information to my IT people and try and convince them to do it....
> >
> > Googling around, it sounds like this is a big problem for colleges and schools with large computer labs where students log into various different computers at any time.
> >
> > Looking forward to some ideas,
> >
> > Robert Brewington
> > Chemistry/Physics Teacher
> >
>
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar