How can I save only one of my sheets as an Excel file 1

[JackOTH]

Hi Everybody,

I just starting to use vsiual basic for applications. I'm actually rather new at Visual Basic alltogether.

Can anyone help me with my little problem? (detail below)

I've made an excelsheet wih multiple pages/sheets I like to save 1 of those sheets under a certain name but I don't want the entire document to save under that name. And I don't want it to include visual basic routines or macro's from the main document. And I want the main document to stay opened under the original name.

There have be a few visual basic programmers outthere that know the solution to this problem. Thanx in advance!

Jack

 

[xlbo]

1: Look in the FAQs section
2: Find this FAQ:
faq707-2482

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[JackOTH]

Tahnx!