Compile error: Constant expression required error when merging two Codes

[Kezwick]

Hi Guys,

Should be a strait forward fix (last words) have 2 macros here one that creates a folder and one that saves selected emails into a folder so I combined the 2 (I thought) and came up with this so that it would save the created folders in the folder location I just created, I thought it was simple just add a “& strNewFolderName” to the file location but no came up with a error. Below is the code any help would be met with love and cookies!!

Regards

Kezwick

Please Login or Register  to view this content.

[AndyLitch]

Save_To_Folder can't be a constant because your assigning a value to it with the inputbox.
redefine it as a string variable

[Kezwick]

ahhh makes a bit of sense now so

Please Login or Register  to view this content.

[AndyLitch]

That looks good

[Kezwick]

i will give it a go and get back to you hopfully the frankenstine macro will work ! haha

[Kezwick]

famous last words!!!

it came up with this time a run time error (never seen before!!) -2147287037 (80030003)
then points to this line

Please Login or Register  to view this content.

[AndyLitch]

Try Putting a very simple BTFM number in ... Pure text is best

[Kezwick]

Ignore me i have been a 24 carat plonker!!! i had one string saying 1 directory adn 1 saying another!

thanks for the help though have +1'ed you

[AndyLitch]

LOL.... Cheers mucker