You would have to save as "xml" then open the xml file and save back as xls.
This way you will get an xls file with no macros.

"Inbar" wrote:

You basically want to save the xls w/o any macros, right?

"bg18461" wrote:


Hey, I have a bit of a dilema. I have created a program that takes
claims manually when the system is down, and once the system is back
online, people re-open the excel file which contains my VBA program to
re-enter back into the system. The program is essentially a collection
of forms tied together that capture data and save them onto a excel
sheet. At the end of the data capture process the worker presses a
button and the whole excel file, data and vba program are sent via
email to a folder in Outlook. The problem is that the file is 2mb, and
when its time to re-enter the data into the program it takes about 20-30
secs to open the program because Outlook is so slow.

What i am looking to do is to have the VBA Dataforms still capture the
data, but sever the ties to the VBA Coding and just be data, say in
Word, so the file actually being emailed is only a few KB's big. Any
ideas, or if i am being too vague, please let me know.


--
bg18461
------------------------------------------------------------------------
bg18461's Profile: http://www.excelforum.com/member.php...fo&userid=8877
View this thread: http://www.excelforum.com/showthread...hreadid=276796