Create folder and copy in to that folder - VBA

**Sinep D** · 07-09-2015, 06:14 AM

Hi,

I have created the following code to first create a folder based on todays date. Now I want to copy in to that folder which I created.
Tried the following code but struggle how I should define folder location in the last part of my code so it will copy in to that folder.

Please Login or Register  to view this content.

Best regards,

**JBeaucaire** · 07-11-2015, 01:09 AM

Wouldn't it just be:

Please Login or Register  to view this content.

**Sinep D** · 07-12-2015, 01:11 PM

Thanks for your reply! I will try your suggestion tomorrow.

**Sinep D** · 07-13-2015, 11:26 AM

I tried your suggestion and it worked up until the point that it creates the acutal folder, which is of course good. But how to make it export into that created folder?

**JBeaucaire** · 07-13-2015, 04:32 PM

Maybe you're just missing a path separator:

Please Login or Register  to view this content.

**Sinep D** · 07-14-2015, 01:54 PM

That was it. Always the small things

Thanks!

Create folder and copy in to that folder - VBA

LinkBack

Thread Tools

Rate This Thread

Display

Create folder and copy in to that folder - VBA

Re: Create folder and copy in to that folder - VBA

Re: Create folder and copy in to that folder - VBA

Re: Create folder and copy in to that folder - VBA

Re: Create folder and copy in to that folder - VBA

Re: Create folder and copy in to that folder - VBA

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Loop Through Folder, Create Emails with Sub Folder Names in Subject, Attach files in sub

create new folder at one location and copy photos in that folder from other location

[SOLVED] Create a new folder based on a cell name or value and save copy onto that folder

create a compressed folder or zipped folder then copy workbooks to it.

Save file in a new folder, but create folder only if folder doesn't already exist?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions