B
bg18461
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
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