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

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

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