Tue 17 Jan 2012, 12:02Delegate Palvinder said...
Palvinder has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
How do I create a Folder and a File with the same name in a pre-
How do I create a Folder and a File with the same name in a pre-specified directory where;
• The Name value is derived from two specific cells from the current sheet. E.g J6 and C10.
• Also then email the current sheet to a specific email
Fri 27 Jan 2012, 13:40Trainer Anthony said...
RE: How do I create a Folder and a File with the same name in a
Hi Palvnder, thanks for your query. You'll need to concatenate the values in the cells together, then pass that composite value to a variable. Then use the file system object to create the folder and file:
http://www.tek-tips.com/faqs.cfm?fid=4116
...and then email using one of the techniques here:
http://www.rondebruin.nl/sendmail.htm
Hope this helps,
Anthony
