Exporting VBA DataForm Info to Word document
 

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

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

--
bg1846
-----------------------------------------------------------------------
bg18461's Profile: http://www.excelforum.com/member.php...nfo&userid=887
View this thread: http://www.excelforum.com/showthread.php?threadid=27679

Exporting VBA DataForm Info to Word document
 

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

Exporting VBA DataForm Info to Word document
 

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