| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
path syntax
Have a folder (Parade) within it is (Parade.xls) I am after (MailE)in
Parade.xls Is there a way to get to this worksheet in VBA I wish to use this worksheet for mail merge. Can copie it to C:\ and delete after. Was hopeing to not have to go this route Parade\Parade.xls\MailE didn't work or other combos. Anyone? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
path syntax
Check out Ron's site. Maybe it will answer your question.
http://www.rondebruin.nl/sendmail.htm "Curt" wrote: Have a folder (Parade) within it is (Parade.xls) I am after (MailE)in Parade.xls Is there a way to get to this worksheet in VBA I wish to use this worksheet for mail merge. Can copie it to C:\ and delete after. Was hopeing to not have to go this route Parade\Parade.xls\MailE didn't work or other combos. Anyone? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
path syntax
Thanks will see what its got
"JLGWhiz" wrote: Check out Ron's site. Maybe it will answer your question. http://www.rondebruin.nl/sendmail.htm "Curt" wrote: Have a folder (Parade) within it is (Parade.xls) I am after (MailE)in Parade.xls Is there a way to get to this worksheet in VBA I wish to use this worksheet for mail merge. Can copie it to C:\ and delete after. Was hopeing to not have to go this route Parade\Parade.xls\MailE didn't work or other combos. Anyone? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
| how to change absolute path to relative path | Excel Worksheet Functions | |||
| Kill Syntax and path | Excel Programming | |||
| Syntax for using the full path to get a value | Excel Programming | |||
Linear Mode
