Go Back   Access World Forums > Apps and Windows > Visual Basic

Thread Tools Rate Thread Display Modes
Old 01-18-2008, 09:04 AM   #1
I'm with the Witch.......
scott-atkinson's Avatar
Join Date: Aug 2006
Location: West Midlands, (Formally Essex Barrow Boy....)
Posts: 1,611
Thanks: 26
Thanked 31 Times in 28 Posts
scott-atkinson will become famous soon enough
Deleting a Macro when document is saved as


I have another problem..

I have written a comprehensive Macro to format a spreadsheet and save it as another name in another folder.

My problem is that when the code actions the save as it also copies the Macro to the new document as well, and I do not want this to happen.

So my question is how can I code in VB to delete the Macro from the newly named workbook?

Any ideas?

As you slide down the banister of life, may the splinters never point the wrong way.
scott-atkinson is offline   Reply With Quote
Old 02-22-2008, 07:37 AM   #2
DCrake's Avatar
Join Date: Jun 2005
Location: Burnley, Lancashire
Posts: 8,634
Thanks: 8
Thanked 327 Times in 208 Posts
DCrake is a glorious beacon of light DCrake is a glorious beacon of light DCrake is a glorious beacon of light DCrake is a glorious beacon of light DCrake is a glorious beacon of light DCrake is a glorious beacon of light
Send a message via Skype™ to DCrake
Simple Software Solutions

Without testing it and of the top of my head when you have finished formatting and saving your spreadsheet. Why not create have another spreadsheet that opens up the previous spreadsheet and deletes the macro and then save the spreadsheet.

Just a thought
David Crake

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
The Home of Simple Software Solutions.

O/S Windows XP (SP3) & Windows 7 64bit
Access 2003 (version 11.0)
Access 2007 (version 12.0)

Remember when posting sample databases you will get a better response if it is pre Access 2007 - not all people have it installed.
DCrake is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
access 2007 import wizard - saved steps in macro? j0se Macros 0 09-03-2007 07:20 AM
Closing and deleting a form from within a macro Bickbadger Macros 15 07-24-2007 10:04 AM
Problem after deleting redundant macro andybal Macros 1 02-01-2005 08:57 AM
Else If.....claen programming datacontrol Reports 6 09-15-2003 05:54 AM
Deleting more than 50,000 in macro Wonderer General 6 10-30-2002 09:22 AM

All times are GMT -8. The time now is 05:02 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World