Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 22nd, 2004, 12:39 AM
Authorized User
Join Date: Jul 2004
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Regarding saving the document

How to save the document or workbook
without saving the code in the vbe Editor code?

Old October 29th, 2004, 10:49 AM
Authorized User
Join Date: Oct 2004
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to shattered Send a message via Yahoo to shattered

generally you can't, when you save the code is automatically saved. If you simply want to have the contents of the workbook availbel for someone esle without the vba code in its just as easy to write a macro to copy the sheets to a new workbook.

The new workbook would then exist with no code attached.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem saving a word document using DSOFramer Act Chirantan Pro VB.NET 2002/2003 0 August 28th, 2007 08:02 AM
Saving a document on local computer h2c357 Javascript 0 May 3rd, 2007 09:14 AM
EXCEL question saving a file saving the the first macupryk VS.NET 2002/2003 0 January 6th, 2005 05:33 PM
saving word document in server asp sdeep_us Classic ASP Basics 1 August 7th, 2004 10:30 PM
SAVING AUTOMERGED DOCUMENT ACCESS mandeep4me Access VBA 1 June 28th, 2003 04:45 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.