Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programing a drive as a variable
I'm trying to update a macro. the program prints a series of excel sheets from a directory in a network drive, the code has been shared with other offices that have a different arrangement in their directory tree, since the code refers to the specific drive we have, the macro does not work. I want to have the user find the folder on his/her computer with a browse button; that can explore the computer, any ideas?. -- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programing a drive as a variable
Have a look here
http://www.j-walk.com/ss/excel/tips/tip29.htm -- Robin Hammond www.enhanceddatasystems.com "gde" wrote in message news:opsmvyyufwpoco36@notebook... I'm trying to update a macro. the program prints a series of excel sheets from a directory in a network drive, the code has been shared with other offices that have a different arrangement in their directory tree, since the code refers to the specific drive we have, the macro does not work. I want to have the user find the folder on his/her computer with a browse button; that can explore the computer, any ideas?. -- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programing a drive as a variable
Thanks, I'll try it today, I'll get back to y'all with errors or any more
questions. On Mon, 28 Feb 2005 10:54:30 +0800, Robin Hammond wrote: Have a look here http://www.j-walk.com/ss/excel/tips/tip29.htm -- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links to mapped drive change to refer to local hard drive | Links and Linking in Excel | |||
Can I save to hard drive AND my flash drive at the same time? | Excel Discussion (Misc queries) | |||
Userform Local Drive & Network drive question | Excel Programming | |||
Pasting a range of information from a foler on F Drive to another folder on same drive | Excel Programming | |||
Find links with code; change from G drive to C drive | Excel Programming |