<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<TITLE>Message</TITLE>
<META content="MSHTML 5.00.3502.4856" name=GENERATOR>
<STYLE>@font-face {
font-family: Tahoma;
}
P.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt
}
LI.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt
}
DIV.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P.MsoAutoSig {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt
}
LI.MsoAutoSig {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt
}
DIV.MsoAutoSig {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt
}
P {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in
}
SPAN.emailstyle17 {
COLOR: windowtext; FONT-FAMILY: Tahoma; FONT-STYLE: normal; FONT-WEIGHT: normal; TEXT-DECORATION: none
}
SPAN.emailstyle20 {
COLOR: blue; FONT-FAMILY: Tahoma; FONT-STYLE: normal; FONT-WEIGHT: normal; TEXT-DECORATION: none
}
SPAN.EmailStyle21 {
COLOR: blue; FONT-FAMILY: Tahoma; FONT-STYLE: normal; FONT-WEIGHT: normal; TEXT-DECORATION: none
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US link=blue vLink=purple>
<DIV><FONT color=#0000ff size=2><SPAN class=078185015-10022003>How about
exporting the data to one spreadsheet and link the data from that spreadsheet in
the same workbook to the preformatted report in another spreadsheet in the
workbook. Then create a macro attached to a button that would send the
report spreadsheet as an attachment.</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Mark Boyd
[mailto:MarkBoyd@McBeeAssociates.com]<BR><B>Sent:</B> Monday, February 10,
2003 10:44 AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B>
RE: [AccessD] Export to Excel<BR><BR></DIV></FONT>
<DIV class=Section1>
<P class=MsoNormal><FONT color=blue face=Tahoma size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">Charles
–</SPAN></FONT></P>
<P class=MsoNormal><FONT color=blue face=Tahoma size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">I wish it were that
easy. When this whole thing began, I recommended that we send it as a
.pdf file.</SPAN></FONT></P>
<P class=MsoNormal><FONT color=blue face=Tahoma size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">I was told there are
some circumstances where the client needs to manipulate the data after they
receive it, and they prefer Excel when doing the
manipulating.</SPAN></FONT></P>
<P class=MsoNormal><FONT color=blue face=Tahoma size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt"> </SPAN></FONT></P>
<P class=MsoNormal><FONT color=blue face=Tahoma size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">Thanks,</SPAN></FONT></P>
<P class=MsoNormal><FONT color=blue face=Tahoma size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">Mark</SPAN></FONT></P>
<P class=MsoNormal><FONT color=blue face=Tahoma size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt"> </SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Tahoma size=2><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Wortz,
Charles [mailto:CWortz@tea.state.tx.us] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, February 10, 2003 10:39
AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
accessd@databaseadvisors.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [AccessD] Export to
Excel</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT color=blue
face="Times New Roman" size=2><SPAN
style="COLOR: blue; FONT-SIZE: 10pt">Mark,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT color=blue
face="Times New Roman" size=2><SPAN style="COLOR: blue; FONT-SIZE: 10pt">If
you want to send the report instead of the data, then don't use
Excel. Send the report as either .pdf or .snp.</SPAN></FONT></P></DIV>
<P style="MARGIN-LEFT: 0.5in"><B><FONT color=blue face=Arial size=3><SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 12pt; FONT-WEIGHT: bold"><!-- Converted from text/rtf format -->Charles
Wortz</SPAN></FONT></B> <BR><FONT color=blue face=Arial><SPAN
style="COLOR: blue; FONT-FAMILY: Arial">Software Development
Division</SPAN></FONT> <BR><FONT color=blue face=Arial><SPAN
style="COLOR: blue; FONT-FAMILY: Arial">Texas Education Agency</SPAN></FONT>
<BR><FONT color=blue face=Arial><SPAN
style="COLOR: blue; FONT-FAMILY: Arial">1701 N. Congress Ave</SPAN></FONT>
<BR><FONT color=blue face=Arial><SPAN
style="COLOR: blue; FONT-FAMILY: Arial">Austin, TX 78701-1494</SPAN></FONT>
<BR><FONT color=blue face=Arial><SPAN
style="COLOR: blue; FONT-FAMILY: Arial">512-463-9493</SPAN></FONT> <BR><FONT
color=blue face=Arial><SPAN
style="COLOR: blue; FONT-FAMILY: Arial">CWortz@tea.state.tx.us</SPAN></FONT>
<BR><FONT color=black face=Arial><SPAN
style="COLOR: black; FONT-FAMILY: Arial">(SELECT * FROM users WHERE clue >
0)</SPAN></FONT> </P>
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in"><FONT
face=Tahoma size=2><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Mark Boyd
[mailto:MarkBoyd@McBeeAssociates.com] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday 2003 Feb 10
09:34<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
accessd@databaseadvisors.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [AccessD] Export to
Excel</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT color=blue face=Tahoma
size=2><SPAN style="COLOR: blue; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">The
point of this process is to eliminate all user interaction with the formatting
of the report.</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT color=blue face=Tahoma
size=2><SPAN style="COLOR: blue; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">The
user clicks a button, which automatically exports the formatted report to
Excel. Then, the report is emailed to the appropriate
client.</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT color=blue face=Tahoma
size=2><SPAN style="COLOR: blue; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">How can
I only export the record source, without having the user interact with Excel
to format the data? Have a pre-designed report
template?</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT color=blue face=Tahoma
size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">Mark</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face=Tahoma size=2><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Wortz,
Charles [mailto:CWortz@tea.state.tx.us] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, February 10, 2003 10:24
AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
accessd@databaseadvisors.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [AccessD] Export to
Excel</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT color=blue
face="Times New Roman" size=2><SPAN
style="COLOR: blue; FONT-SIZE: 10pt">Mark,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT color=blue
face="Times New Roman" size=2><SPAN
style="COLOR: blue; FONT-SIZE: 10pt">Instead of trying to export the report,
export the report's record source.</SPAN></FONT></P></DIV>
<P style="MARGIN-LEFT: 1in"><B><FONT color=blue face="Times New Roman"
size=3><SPAN style="COLOR: blue; FONT-SIZE: 12pt; FONT-WEIGHT: bold"><!-- Converted from text/rtf format -->Charles
Wortz</SPAN></FONT></B> </P>
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 1in; MARGIN-RIGHT: 0in"><FONT
face=Tahoma size=2><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Mark Boyd
[mailto:MarkBoyd@McBeeAssociates.com] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday 2003 Feb 10
09:18<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
AccessD@databaseadvisors.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> [AccessD] Export to
Excel</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face=Tahoma size=2><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">We are having an issue with
exporting data from an Access report to an Excel
spreadsheet.</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face=Tahoma size=2><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">It seems that whenever there are
calculated fields such as report totals, the data doesn’t display properly
after exporting.</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face=Tahoma size=2><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">Also, some fields are moved way
to the right, while others are way left.</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face=Tahoma size=2><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">Does anyone know of
3<SUP>rd</SUP> party software that will export an Access report to Excel as
clean as possible?</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face=Tahoma size=2><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">Thanks,</SPAN></FONT></P>
<P class=MsoAutoSig style="MARGIN-LEFT: 1in"><FONT face=Tahoma size=2><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">Mark Boyd</SPAN></FONT></P>
<P class=MsoAutoSig style="MARGIN-LEFT: 1in"><FONT face=Tahoma size=2><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">Sr. Systems
Analyst</SPAN></FONT></P>
<P class=MsoAutoSig style="MARGIN-LEFT: 1in"><FONT face=Tahoma size=2><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">McBee Associates,
Inc.</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt"> </SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>