Solved

Access VBA - email spreadsheet without VBA code

Posted on 2011-03-06
3
484 Views
Last Modified: 2012-06-27
Hi

I have a spreadsheet that contains a lot of VBA code.
How do I email this spreadsheet without the VBA?
Thanks
0
Comment
Question by:murbro
  • 2
3 Comments
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 500 total points
ID: 35045881
If using 2007 or later then save as xlsx i.e. no code will exist in the saved worked.

Chris
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 35045883
Hmmm!

... will exist in the saved workbook which you can then send.

Chris
0
 

Author Closing Comment

by:murbro
ID: 35046063
thanks very much
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now