SaveAs not working

[jamesryan]

Hi,

Bit of elongated code here but after hours of trying i have nearly given up!, This code takes a file, copies some stuff to a new file and the saves it in a directory (or so i'd hope).

It keeps falling over on the:

bk.SaveAs Filename:=Range("E3").Select

line at the end.

Any help would be superb.

thanks

James

Please Login or Register  to view this content.

[royUK]

It should be something like this

Please Login or Register  to view this content.

I'm not sure why you have this line

Please Login or Register  to view this content.

but it should be

Please Login or Register  to view this content.

Maybe

Please Login or Register  to view this content.

[jamesryan]

cheers Roy,

will test it in the morning to see if it works with that,

still working my way through VB so i know my code could do with a lot of cleaning up!

James