| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| re-install excel 2007 (macros remain?) | Excel Discussion (Misc queries) | |||
| Install or protect an Excel spreadsheet? | Excel Programming | |||
| Can I create an Excel User Form without VB install on my PC? | Excel Programming | |||
| Can I create an Excel User Form without VB install on my PC? | Excel Discussion (Misc queries) | |||
| Hyperlinks change when Excel file is saved to a different director | Excel Worksheet Functions | |||
Linear Mode
