kill with variable workbookname fails

[evilscientist]

Hi,

I try to do the following

open an automatically created file =>create new name based on cell values => save as new name in folder 2 => kill the original file=> continue macros on newly named file.

I usually grab most of my VBA from the web and adjust to my needs, but I didn't find any good examples.
At the moment it does the saving bit, but the killing won't work. I can't put the filename in the kill path

this is part of the code, I omitted the automatically opening which works fine

Please Login or Register  to view this content.

[Norie]

You have an extraneous " after stfile1.

[evilscientist]

thanks that fixed it, should have seen it,