Installing Personal.xls on other computers

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

Hey guys

I have a code in my Personal.xls module that I would like
to put on alot of other peoples computer. Is there anyway
to do this without having to mannualy do it? Now Bob
Phillips game me the link to Chip Pearsons website
http://www.cpearson.com/excel/vbe.htm
that allows you to update code on the fly, but I have been
unable to go to that site since I am at work(behind
firewall). I will have to do this when I go home. Im not
sure if this will also work for my issue with Personal.xls.

Any help is appreciated.

Thanx
Todd Huttenstine

Thank you
 
Todd,

Loading over Personal.xls is not recommended, as it is as it says, a
personal file Many people will have personal customisations in that file
that you may destroy.

A much better way is to create your code in an addin, distribute that, and
get all the users to load that addin. This is an instruction set on
creating an addin that I got off the net, which I haven't test-run, but I
reprint in lieu of your firewall

Create an addin in Excel 97, 2000, 2002 using VBA in Microsoft Excel




1.. Start the Visual Basic Editor by pressing Alt+F11.
2.. Select Debug, Compile VBA projectname. In previous versions of Excel
the VBA-code was automatically
compiled when you saved the addin. This is no longer true, you have to do
it yourself before you save the addin.
3.. If you want to lock the project from viewing you can select Tools,
Properties for VBA projectname.
In this dialog you activate Protection and check the option Lock project
for viewing.
Fill in a password and click the OK-button.
4.. Activate Excel by pressing Alt+F11.
5.. Select File, Properties..., Summary and fill inn information for the
fields Title and Comments.
The title will be the name that appears in the Add-Ins dialog (the dialog
displaying available add-ins),
the comment will be the description that appears when you select the addin
in the Add-Ins dialog.
Click the OK-button to close the Properties dialog.
6.. Select File, Save as..
7.. Change the option Filetype: to Microsoft Excel addin (*.xla) (the last
choice in the dropdown).
The add-in must contain at least one worksheet if this option is to be
displayed.
8.. Click the Save-button to save the workbook as an addin.
The locking of the project will not take effect until you close and re-open
the workbook.

You can convert a workbook to an addin by changing the property IsAddin to
True for the ThisWorkbook-object.
This must be done from the Visual Basic Editor. When the property is changed
you can save the workbook by
clicking on the Save-toolbarbutt on.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You might want to explore putting the code in an XLA add-in
that can be placed on the users' computers, in their start-
up
directories.
Otherwise make a Reference to VBA Extensibility and then
check out the help files

Kevin Beckham
 
Todd,

modifying someone elses personal.xls file is not really sound practice. If
you want to distribute your code you would be better off saving your own
personal.xls under a new name as an addin, then distributing that to your
audience. They can then load the addin and control whether they want your
code loaded or not.

You may also find that attempts to modify personal.xls run into security
problems depending on the users security settings. They may not want to
trust you as a source, may have security set to high, or may have disabled
access to vb projects, all of which would result in errors.

Robin Hammond
www.enhanceddatasystems.com
 
Back
Top