snp to RTF

[Guest]

I've looked at Stephen Lebans RTF2 utility and it looks great, but it is more
than I need. Right now I allow user to create an HTML file that they can
place on the web. The problem with html is that it looses the format and
doesn't line up properly. I've tested with the snp and that works fine
except the end users need to have the snp viewer installed in order to view
report on the web and I'm not sure how many user will have that installed. I
would like to be able to convert the snp to an rtf format without any
intervention on the users part. I use the following code to create the snp
DoCmd.OutputTo acReport, strReportName, "SnapshotFormat(*.snp)",
stdreportpath, False, "", 0
is there a simple way to take the snp file to rtf using code?

Thanks for any help

 

[Stephen Lebans]

Did you see this on my site?
http://www.lebans.com/ReportUtilities.htm

ReportUtilities a suite of utilities with 5 Features:

1) Export to MS Word. Output exact duplicate of a Report to RTF, including
formatting and all graphics. This file can be loaded into MS Word for
limited further editing or inclusion into a larger document.

2) Export to WordPad. Output duplicate of a Report to RTF, including
formatting and all graphics. This file can be loaded into MS WordPad for
viewing and/or Printing.

3) Save Report to Enhanced Metafile format. One EMF file for every Page of
the Report.

4) Save Report to the older Metafile format. One WMF file for every Page of
the Report. This format may be imported by FrontPage as a Clip and then
saved to the Web page as an WMF not a GIF or JPEG! This means about 10KB to
15KB average per Report Page.

5) Print To Fit functionality. Output multiple Report pages per single
output page. 2up, 3up or 4up etc. Printer selection is independent of the
original Report. For instance you could output a Report of Legal size pages
to standard Letter size. Does not require MS Word.

Copyright Lebans Holdings 1999 Ltd

Requires that a current version of Microsoft Word is installed on your
system to view the finished RTF files for MS Word. Developed and tested for
MS Word97.

Simply open the "ReportUtilities" Form test the functions. Please note that
all of the horizontal Lines in the sample Reports were drawn with either the
Report Rectangle Tool or by using the Report object Print method. This is
due to a shortcoming in the Access Export functions that produce a SnapShot
file.

The converted RTF file is not a fully editable document. Word97 does have
the ability to edit this file on a limited basis. Simply double click on any
page in Word to activate the Editor.

RTF for WordPad does not allow any editing of the document. WordPad does not
have the ability to respond to the RTF control words for setting Page
Margins, Cropping etc. To get around this the Metafile has its Window Origin
offset by the amount of the Left and Top Margins in the original Report. You
can set the Page Margins in WordPad to gain further flexability. Finally,
remember that you will have to use the Page Setup Menu to select a Paper
Size to match that of the original Report.

The Save Report To EMF feature produces a single EMF file for each page of
the Report. The resulting EMF's can be loaded into Drawing programs or
inserted into a MS Word document via the Menu's Picture->Insert->From File
route.

The Save Report To WMF feature produces a single WMF file for each page of
the Report. The resulting WMF's can be loaded into Drawing programs or
inserted into a MS Word document via the Menu's Picture->Insert->From File
route.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

Stephen,
Thanks for the response, yes I did see this on the web site. The thing is I
want this to be completely transperant to the user. When the user selects
the report now I give then a prompt to create a html file for web posting.
If the user response yes the html is created in a folder where the user can
then copy it to their web site. When I would like to do is create the snp
file that the user can post to the web for all to view. I guess my question
would be what happens if a person trying to view the snp file doesn't have
the snp viewer, is this viewer part of MS Windows or is it part of some other
program such as MS Office or MS Word. I would leave the report as an html
file except as I mentioned the line up isn't very good with html, but is sure
is great with snp. Do you have any suggestions.

Again thanks for your help.

 

[Guest]

Stephen you have created an excellent tool, but my user wants it all. the
graphics AND the ability to edit the converted report. This conversion will
need to take place via vba so that the converted file with graphics in tact
that can be edited can be auto sent to the user via an email account. Once
they get the email they would like to edit the converted report and then send
it to someone else. Thanks. I am anxiously awaiting your expertise.

 

[Stephen Lebans]

Cannnot be done with any existing formats supported by the existing Access
export functions...period.

You would have to create the Word document programmatically. Several times I
have attempted to create a solution but was never happy with the results.
The level of complexity introduced by supporting CanGrow/Shrink is
unmanageable to say the least.

I have also testing exporting to PDF and then using a third party PDF to
Word converter. The results were not accurate enough for a production
release.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.