Creating a file in a newly created folder.

**AnthonyWB** · 04-09-2010, 05:14 PM

Hello everyone. Thanks to everyone who has helped me before. I would like to be able to create a file in a folder; which is created via input from the user. Below is the code that I am trying to use and it does not work. I am recieving a syntax error in Sub Macro1 for Filename. Any help would be greatly appreciated.

Please Login or Register  to view this content.

Essentially I am trying to add a workbook to the directory:

Please Login or Register  to view this content.

**shg** · 04-09-2010, 05:38 PM

You're missing the line continuation character (the underscore) in the first line.

**AnthonyWB** · 04-09-2010, 05:42 PM

Embarrassingly, I cannot see it?

**shg** · 04-09-2010, 06:10 PM

Please Login or Register  to view this content.

**JBeaucaire** · 04-09-2010, 08:23 PM

Anthony

In the CreateFolders macro I gave you yesterday, the DIM declarations should be INSIDE the macro, not above it.

Check the original thread, I gave you a much more robust CreateFolders macro, too, one that would recover from existing files a little more elegantly.

http://www.excelforum.com/excel-prog...g-folders.html

**AnthonyWB** · 04-12-2010, 10:16 AM

shg and JBeaucaire, your help is apprecaited. I am still recieving an error "Save As Method Failed." , in the Macro 1. I put the DIM declarations Outside of the CreateFolders MACRO, so that they may be used in subsequent sub macros. Please see the code below. Your help is appreciated.

Please Login or Register  to view this content.

**shg** · 04-12-2010, 10:31 AM

Anthony, before the SaveAs, print the would-be path to the Immediate window and see if it's correct.

More generally, spend some time reading http://www.cpearson.com/excel/Debug.htm

**AnthonyWB** · 04-12-2010, 11:13 AM

Thanks - I visited the website, and began using the Immediate window to see if the path is correct. I typed in

Please Login or Register  to view this content.

and recieved an invalid character error. The underscore preceeding the 157 is not the source as its removal does not eliminate the error. Any suggestions?

**JBeaucaire** · 04-12-2010, 11:32 AM

You're not entering dates with "/" in them are you? At the moment of the error, but your mouse over the fPath and the fDate variables...what are the exact values?

**AnthonyWB** · 04-12-2010, 11:48 AM

At the moment of error we have:

fPath = "L:\"

fDate = "12_31_2009" ; which is the date that was entered in the InputBox during the "run", so it is correct.

No, I am not using "/" in the dates.

**JBeaucaire** · 04-12-2010, 12:23 PM

Well, I know this line of code in the immediate window won't work (give the invalid character message):

Please Login or Register  to view this content.

...but this will:

Please Login or Register  to view this content.

**AnthonyWB** · 04-12-2010, 12:37 PM

I am sorry I an not getting it. I am now being told a "constant expression is required"

Please Login or Register  to view this content.

**AnthonyWB** · 04-12-2010, 02:23 PM

I am still wokring on this error. I using the immediate window to debug:

Please Login or Register  to view this content.

It appears to be the correct path. However in running the code I recieve a "Constant Expression Required" error. Are there problems with how I am declaring variables? fDate is not a function. So the value should be the same throughout each macro, likewise with fPath.

**shg** · 04-12-2010, 02:31 PM

You can't do this:

Please Login or Register  to view this content.

The value of a constant is assigned at compile time, so there can't be any variables in its definition. It can include only literal values, or other constants previously defined in the same scope.

sPath1 needs to be a variable.

**AnthonyWB** · 04-12-2010, 03:01 PM

I got it. Thank you. FYI - I am learning a tremendous amount on this forum.

Please Login or Register  to view this content.

Creating a file in a newly created folder.

LinkBack

Thread Tools

Rate This Thread

Display

Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Re: Creating a file in a newly created folder.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions