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

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?
--
TomThumb

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

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

"TomThumb" wrote in message
...
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?
--
TomThumb

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

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


"NickHK" wrote:

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

"TomThumb" wrote in message
...
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?
--
TomThumb

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

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...Sear ch&meta=

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

NickHK

"TomThumb" wrote in message
...
Is there some standard, existing software that will install my program
from
CD to the user's hard drive?
--
TomThumb


"NickHK" wrote:

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

"TomThumb" wrote in message
...
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?
--
TomThumb

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

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.
--
TomThumb


"NickHK" wrote:

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...Sear ch&meta=

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

NickHK

"TomThumb" wrote in message
...
Is there some standard, existing software that will install my program
from
CD to the user's hard drive?
--
TomThumb


"NickHK" wrote:

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

"TomThumb" wrote in message
...
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?
--
TomThumb

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

Start he
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

"TomThumb" wrote in message
...
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.
--
TomThumb


"NickHK" wrote:

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...Sear ch&meta=

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

NickHK

"TomThumb" wrote in message
...
Is there some standard, existing software that will install my program
from
CD to the user's hard drive?
--
TomThumb


"NickHK" wrote:

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

"TomThumb" wrote in message
...
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?
--
TomThumb

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

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


"NickHK" wrote:

Start he
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

"TomThumb" wrote in message
...
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.
--
TomThumb


"NickHK" wrote:

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...Sear ch&meta=

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

NickHK

"TomThumb" wrote in message
...
Is there some standard, existing software that will install my program
from
CD to the user's hard drive?
--
TomThumb


"NickHK" wrote:

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

"TomThumb" wrote in message
...
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?
--
TomThumb

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

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

"NickHK" wrote in message
...
Start he
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

"TomThumb" wrote in message
...
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.
--
TomThumb


"NickHK" wrote:

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...Sear ch&meta=

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

NickHK

"TomThumb" wrote in message
...
Is there some standard, existing software that will install my
program
from
CD to the user's hard drive?
--
TomThumb


"NickHK" wrote:

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

"TomThumb" wrote in message
...
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?
--
TomThumb

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

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


"NickHK" wrote:

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

"NickHK" wrote in message
...
Start he
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

"TomThumb" wrote in message
...
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.
--
TomThumb


"NickHK" wrote:

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...Sear ch&meta=

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

NickHK

"TomThumb" wrote in message
...
Is there some standard, existing software that will install my
program
from
CD to the user's hard drive?
--
TomThumb


"NickHK" wrote:

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

"TomThumb" wrote in message
...
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?
--
TomThumb