Excel 2007 VBA How can I install my spreadsheet in a user director

[Guest]

Is there a generic program that will autoexecute and load my spreadsheet into
a user directory, offering the user an opportunity to browse their hard drive?

 

[NickHK]

Not sure what you are asking...

- You want an Installer to copy a specific Excel file to a specific location
?
Plenty of installers available, Inno etc
- You want to allow the user to select a file:
Application.GetOpenFileName

NickHK

 

[Guest]

Is there some standard, existing software that will install my program from
CD to the user's hard drive?

 

[NickHK]

Well a batch file would do it. If you are talking about a single Excel
workbook, it shouldn't be that difficult.
Otherwise one of the installer apps can be configured to install various
components and register them etc.
If you have an Autorun file on the CD, it can execute when the CD is
inserted.

So I guess the answer is Yes, there is existing software to do the
installation, but have to configure it.
http://www.google.co.uk/search?hl=en&q=windows+installers&btnG=Google+Search&meta=

But none of this is really an Excel situation, unless you are asking how to
do it in VBA.

NickHK

 

[Guest]

Nick, Thanks for your responses. I have not been too clear about my
question because I only have a fuzzy idea myself. I will try to sharpen my
query:

I have a single spreadsheet with VBA macros. I want to place this on a CD.
I want the CD to autorun on another user's computer and install in his/her
excel directory. I just want the simplest way to accomplish this.

 

[NickHK]

Start here:
http://www.phdcc.com/shellrun/autorun.htm
http://www.cryer.co.uk/brian/windows/howtocacdtwar.htm

I haven't used autoRun much, so can't say much really.
Check the link at the bottom of the second site to avoid burning/testing
many CDs.

NickHK

 

[Guest]

Thanks, Nick, for spending time on my problems. It is vey kind of you to
loan me your brain.

 

[NickHK]

Unless anyone has a better idea:

<AutoRun.inf>
[autorun]
ShellExecute=Install.bat
</AutoRun.inf>

<Install.bat>
copy NewWS.xls C:\NewWS.xls
</Install.bat>

You can user other DOS elements (like %userprofile% etc) in the batch file,
although I don't see how you can get the Excel folder, but admittedly I know
very little about this bat file stuff.

You could always open the Excel file from the Autorun instead:
<AutoRun.inf>
[autorun]
ShellExecute=NewWS.xls
</AutoRun.inf>

and any code in its Workbook_Open event would run. From here you could get
the:
Application.StartupPath
Application.DefaultFilePath

Then do a .SaveCopyAs and then open the copy, whilst you close this WB.
This may not work depending on the users Excel security setting though.

NickHK

 

[Guest]

Thanks, Nick. I have copied much of your information into Word, where I can
refer to it at my leisure.
--
TomThumb

Unless anyone has a better idea:

<AutoRun.inf>
[autorun]
ShellExecute=Install.bat
</AutoRun.inf>

<Install.bat>
copy NewWS.xls C:\NewWS.xls
</Install.bat>

You can user other DOS elements (like %userprofile% etc) in the batch file,
although I don't see how you can get the Excel folder, but admittedly I know
very little about this bat file stuff.

You could always open the Excel file from the Autorun instead:
<AutoRun.inf>
[autorun]
ShellExecute=NewWS.xls
</AutoRun.inf>

and any code in its Workbook_Open event would run. From here you could get
the:
Application.StartupPath
Application.DefaultFilePath

Then do a .SaveCopyAs and then open the copy, whilst you close this WB.
This may not work depending on the users Excel security setting though.

NickHK

Start here:
http://www.phdcc.com/shellrun/autorun.htm
http://www.cryer.co.uk/brian/windows/howtocacdtwar.htm

I haven't used autoRun much, so can't say much really.
Check the link at the bottom of the second site to avoid burning/testing
many CDs.

NickHK


http://www.google.co.uk/search?hl=en&q=windows+installers&btnG=Google+Search&meta= how