Creating a folder for the new year without having to input the folder name.

**LeapingLizard** · 05-01-2014, 06:38 PM

Hi there all VBA folks,

I have a VBA program that creates a new folder once a year. Instead of having to change the folder name in the macro every year I input it as such that is highlighted in red. It throws a syntex error. Any thoughts on how I could do it any different so it doesn't throw an error.

Please Login or Register  to view this content.

If you would need more code let me know.

Thanks VBA gurus!

LeapingLizard

**Leith Ross** · 05-01-2014, 06:45 PM

Hello LeapingLizard,

Your statement looks like you duplicated part of it when you pasted.

Try this...

Please Login or Register  to view this content.

**LeapingLizard** · 05-01-2014, 08:05 PM

Hi Leith,

Great catch! Thank You!

**Leith Ross** · 05-01-2014, 08:09 PM

Hello Hello LeapingLizard,,

You're welcome. Sometimes it only takes a fresh look to see the problem.

Creating a folder for the new year without having to input the folder name.

LinkBack

Thread Tools

Rate This Thread

Display

Creating a folder for the new year without having to input the folder name.

Re: Creating a folder for the new year without having to input the folder name.

Re: Creating a folder for the new year without having to input the folder name.

Re: Creating a folder for the new year without having to input the folder name.

Thread Information

Users Browsing this Thread

Similar Threads

Creating CULUM results - Folder / Sub Folder from excel macro

[SOLVED] creating a folder with an user input filepath and user input folder name

Select folder from an Input box and insert .PDF files from that folder

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

Creating Folder Folder in My Documents VBA - HELP

Bookmarks

Bookmarks

Posting Permissions