98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » 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-
Resolved · High Priority · Version 2007
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
Fri 3 Feb 2012: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shared Conditional FormattingIn a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones. |
