Move sheet and save as cell value

[Safecracker]

Hello all, great forums!

I would like to move a sheet from a two sheet workbook, to a new workbook and save the new workbook with a file name from three cell values.

Stuie had helped me yesterday, and this is what I have so far

Please Login or Register  to view this content.

I am getting a syntax error on the last line however, any help would be greatly appreciated.

[Stuie]

Hey Safecracker...

The last line of code (C:\Folderr\"& fn) needs a speech mark... eg,

Please Login or Register  to view this content.

So the complete code would look like this,

Please Login or Register  to view this content.

[Safecracker]

Hey Stuie, this works great, thank you very much for your help.

I have another question on this code, how could I add to the code so when i execute the macro, the original file saves (with the original name) in a specific directory, then the original file closes. Then prior to saving the new workbook, it would lock the new workbook?

Thanks Again...

btw the code so far:

Please Login or Register  to view this content.

[Safecracker]

Here was the final code and it achieved its desired result.

Please Login or Register  to view this content.

Thanks for your help!

[Stuie]

No Problem M8... Cheers for feedback

[Sean McC]

Hi there,
I used the code spoken about above but i keep getting run time error, type mismatch on the line "Sheets(Sheet2).Copy" and it highlights it in yellow.
As you can probably tell i am pretty new to this vba thing and if you could help me out id be so grateful.
Thanks
Sean

heres the code:

Please Login or Register  to view this content.

[arlu1201]

Try changing it to

Please Login or Register  to view this content.

[Sean McC]

Its now saying run time error, subscript out of range.

[arlu1201]

Check if you have a Sheet2 in your file.

[Sean McC]

I had renamed sheet2 so i changed it to that and it now works.

Thank you for the help i really appreciate it :D

[Sean McC]

Perhaps you can help me with this too? you seem pretty clued up on vba XD

http://www.excelforum.com/excel-prog...58#post3193258