Posted to microsoft.public.excel.misc

Haldane

external usenet poster

Posts: 3

save excel as data only to a new workbook using VB

I wonder if anyone can help.

I have a workbook with VB proect, date picker objects etc. I need to be able
to create a copy of the work book when it is finally closed as complete. The
copy that it creates needs to be protected and only contain the data ie no
formulas VB etc.

Be grateful if anyone can help

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
Data Matching Button for MS Excel 2007 or later	Mr. Low	Excel Worksheet Functions	0	October 21st 06 10:07 AM
From several workbooks onto one excel worksheet	steve	Excel Discussion (Misc queries)	6	December 1st 05 08:03 AM
Excel 2002; copy formulas to one workbook to another diff data	SinnetBS	Excel Worksheet Functions	1	November 25th 05 08:31 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER	MEGTOM	New Users to Excel	5	October 27th 05 03:06 AM

All times are GMT +1. The time now is 09:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us