Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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






  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default 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








  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
re-install excel 2007 (macros remain?) Jason Excel Discussion (Misc queries) 2 June 9th 09 12:54 AM
Install or protect an Excel spreadsheet? web guy Excel Programming 1 December 13th 06 09:16 PM
Can I create an Excel User Form without VB install on my PC? Novice Excel Programming 1 April 12th 06 08:54 AM
Can I create an Excel User Form without VB install on my PC? Novice Excel Discussion (Misc queries) 1 April 11th 06 04:05 PM
Hyperlinks change when Excel file is saved to a different director ksg Excel Worksheet Functions 0 June 1st 05 08:22 PM


All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"