Copying and moving files - or just renaming?

[AnthonyWB]

Hellow everyone. i have several files:

CDS
Formulas
Illiquid
Q
Rules
Special_Trades,

and they are found here: "L:\12_31_2009_105_Support_Summaries\".

I would like to copy those files and place them into the folder "MM_DD_YYYY_157_Support_Summaries" which is created in the following code below, via a userform.

Please Login or Register  to view this content.

Thanks for any help.

[davegugg]

I beleive this would do it, though I've not personally ever used this command. Assuming these are excel files, you may have to add the extension to the end.

Please Login or Register  to view this content.

Please let me know if that does not work.

[AnthonyWB]

"Public Sub AnthonyWB()"

Variable not defined?

[davegugg]

Hmm, Does excel 07 have FileCopy? Go to it in the code and press F1.
There are no variables in the code, so I'm not sure why the error message would display.

[AnthonyWB]

Yep, it has it. I wonder why it does not work?

[davegugg]

I don't know, I started stepping through it on my machine and it worked fine. Are you sure you copied it right - didn't leave out any " or &.

You did just add it into your previous procedure, right? You can see I used your variables, so it would all have to be one macro.

[AnthonyWB]

I modified the code with the appropriate extension it still does not work:

Please Login or Register  to view this content.

[AnthonyWB]

Here is what I am doing now, and I get an error "ambiguous name detected":

Please Login or Register  to view this content.

[davegugg]

Like this, all in one Sub:

Please Login or Register  to view this content.

[AnthonyWB]

Nope, nothing is copied. Interesting?

[davegugg]

add the .xlsm extensions to the last one I posted.

[AnthonyWB]

I did, please see below:

Please Login or Register  to view this content.

[davegugg]

Sorry AnthonyWB, I've been trying to do three things at once and none of them worked out well. It turns out you need to include the filename where you want it copied:

Please Login or Register  to view this content.

The help in VBA for this is almost useless, the example has no file extension and no path. They seem to use variables without defining them...

[AnthonyWB]

I have to do this, someone should be able to help?

[AnthonyWB]

Dave, I tried the code below per your suggestion, still no go. Perhaps I am missing something - such as the files may be read only or something?

Please Login or Register  to view this content.

[AnthonyWB]

I got it, I simply created a sub module and ran the code. Thank you very much.