Save a file to a folder, create folder if it doesn't exist

**mcinnes01** · 11-01-2010, 07:43 AM

Hi,

I have a macro that makes a file, names it and saves it to your desktop, however I want it to save the files in a folder on your desktop and if the folder doesn't exist it will create one.

This is my code that saves and name the file to your desktop.

Please Login or Register  to view this content.

**romperstomper** · 11-01-2010, 08:12 AM

Something like this:

Please Login or Register  to view this content.

**mcinnes01** · 11-01-2010, 08:22 AM

Hi,

Thanks it almost works, it created the folder, but saved the file on the desktop

**romperstomper** · 11-01-2010, 08:35 AM

Sorry - missed a path separator:

Please Login or Register  to view this content.

**mcinnes01** · 11-01-2010, 09:12 AM

mega! works a treat thanks!

Save a file to a folder, create folder if it doesn't exist

LinkBack

Thread Tools

Rate This Thread

Display

Save a file to a folder, create folder if it doesn't exist

Re: Save a file to a folder, create folder if it doesn't exist

Re: Save a file to a folder, create folder if it doesn't exist

Re: Save a file to a folder, create folder if it doesn't exist

Re: Save a file to a folder, create folder if it doesn't exist

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions