Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drive Letter of current file
With the help of many in this usergroup, I have finished my Excel "setup"
file (to "install" my Excel Addin in the proper folders, with shortcuts and such). In this setupfile, I have an input box to get the "Source Drive" (which may be unknown to novice users). Since the entire setup hinges on the proper identification of the drive which contains this setup file (as well as all the accompanying spreadsheets), I feel bad about getting the drive letter by user input. Surely there must be a way to programmatically discover the letter of the drive which has this "setup" file ("MySetup.xls"), to avoid the problem of users mis-identifying where MySetup.xls resides. Is there? I hope this is clear. TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drive Letter of current file
left(Activeworkbook.fullname,2) will return c:, Z:, etc. as long as the file has been saved. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "zSplash" wrote in message ... With the help of many in this usergroup, I have finished my Excel "setup" file (to "install" my Excel Addin in the proper folders, with shortcuts and such). In this setupfile, I have an input box to get the "Source Drive" (which may be unknown to novice users). Since the entire setup hinges on the proper identification of the drive which contains this setup file (as well as all the accompanying spreadsheets), I feel bad about getting the drive letter by user input. Surely there must be a way to programmatically discover the letter of the drive which has this "setup" file ("MySetup.xls"), to avoid the problem of users mis-identifying where MySetup.xls resides. Is there? I hope this is clear. TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drive Letter of current file
Hi
try something like msgbox Left(Activeworkbook.Fullname,2) returns A: to Z: -- Regards Frank Kabel Frankfurt, Germany "zSplash" schrieb im Newsbeitrag ... With the help of many in this usergroup, I have finished my Excel "setup" file (to "install" my Excel Addin in the proper folders, with shortcuts and such). In this setupfile, I have an input box to get the "Source Drive" (which may be unknown to novice users). Since the entire setup hinges on the proper identification of the drive which contains this setup file (as well as all the accompanying spreadsheets), I feel bad about getting the drive letter by user input. Surely there must be a way to programmatically discover the letter of the drive which has this "setup" file ("MySetup.xls"), to avoid the problem of users mis-identifying where MySetup.xls resides. Is there? I hope this is clear. TIA |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drive Letter of current file
Try this:
Left(ActiveWorkbook.Path,3) HTH, Nikos "zSplash" wrote in message ... With the help of many in this usergroup, I have finished my Excel "setup" file (to "install" my Excel Addin in the proper folders, with shortcuts and such). In this setupfile, I have an input box to get the "Source Drive" (which may be unknown to novice users). Since the entire setup hinges on the proper identification of the drive which contains this setup file (as well as all the accompanying spreadsheets), I feel bad about getting the drive letter by user input. Surely there must be a way to programmatically discover the letter of the drive which has this "setup" file ("MySetup.xls"), to avoid the problem of users mis-identifying where MySetup.xls resides. Is there? I hope this is clear. TIA |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drive Letter of current file
Excellent. Thank you so much, guys.
st. "zSplash" wrote in message ... With the help of many in this usergroup, I have finished my Excel "setup" file (to "install" my Excel Addin in the proper folders, with shortcuts and such). In this setupfile, I have an input box to get the "Source Drive" (which may be unknown to novice users). Since the entire setup hinges on the proper identification of the drive which contains this setup file (as well as all the accompanying spreadsheets), I feel bad about getting the drive letter by user input. Surely there must be a way to programmatically discover the letter of the drive which has this "setup" file ("MySetup.xls"), to avoid the problem of users mis-identifying where MySetup.xls resides. Is there? I hope this is clear. TIA |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drive Letter of current file
Try this:
Left(ActiveWorkbook.Path,3) HTH, Nikos "zSplash" wrote in message ... With the help of many in this usergroup, I have finished my Excel "setup" file (to "install" my Excel Addin in the proper folders, with shortcuts and such). In this setupfile, I have an input box to get the "Source Drive" (which may be unknown to novice users). Since the entire setup hinges on the proper identification of the drive which contains this setup file (as well as all the accompanying spreadsheets), I feel bad about getting the drive letter by user input. Surely there must be a way to programmatically discover the letter of the drive which has this "setup" file ("MySetup.xls"), to avoid the problem of users mis-identifying where MySetup.xls resides. Is there? I hope this is clear. TIA |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drive Letter of current file
Thanks, guys.
st. "zSplash" wrote in message ... With the help of many in this usergroup, I have finished my Excel "setup" file (to "install" my Excel Addin in the proper folders, with shortcuts and such). In this setupfile, I have an input box to get the "Source Drive" (which may be unknown to novice users). Since the entire setup hinges on the proper identification of the drive which contains this setup file (as well as all the accompanying spreadsheets), I feel bad about getting the drive letter by user input. Surely there must be a way to programmatically discover the letter of the drive which has this "setup" file ("MySetup.xls"), to avoid the problem of users mis-identifying where MySetup.xls resides. Is there? I hope this is clear. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Force linked files to link as a drive letter, not UNC name | Excel Discussion (Misc queries) | |||
Obtain drive letter assignment of CD/DVD drive? | Excel Discussion (Misc queries) | |||
How to show the drive letter in the path on the title bar? | Excel Discussion (Misc queries) | |||
Can I show server name instead of drive letter? | Excel Discussion (Misc queries) | |||
How to find the drive letter? | Excel Programming |