Copy a sheet and save as new file, without opening the file

is it possible to copy one sheet in a workbook onto a new workbook then save it but not open the file?
I know i can open, save then close all in vba, but is there a way to do it in the background?

my current code looks like this

Please Login or Register  to view this content.

So i am copying my "Bid Sheet" to a new file and giving it a name. I have code below this saving the file then closing it but i am wondering if there is a way to change my above code to do it all in the background?

Thanks in advance

How would i go about opening the hidden excel, sorry i am all self taught in this stuff and haven't come across this before.