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-
|
|
|
The UK's most regular 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. |
How do I create a Folder and a File with the same name in a pre-
Resolved · High Priority · Version 2007
Reply 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
For upcoming training course dates see: Pricing & availability
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
Reply Thu 9 Feb 2012, 11:57Delegate Palvinder said...
RE: How do I create a Folder and a File with the same name in a
Hi Antony,
That was very useful just what I was looking for
I've only tried a couple of things so far and they work ok
Many thanks
kindest regards
Pal
Fri 3 Feb 2012: Automatically marked as resolved.
|