OT: Report Builder Export to Excel

Yahoo Archive
1
I've taken report builder reports and scheduled them to export the data into
a CSV file, then I have a visual basic routine scheduled to run that takes
the CSV file and converts it into an Excel file (I think its Excel 3.0
format), but it can be done.

-----Original Message-----
From: James Piper [mailto:admin@...]
Sent: Wednesday, September 01, 2004 1:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OT: Report Builder Export to Excel


Does anyone know if you can write a routine within a report builder to
export the information to an excel file?
2
Does anyone know if you can write a routine within a report builder to
export the information to an excel file?







[Non-text portions of this message have been removed]
3
Just put a ; between data fields and export to text file. Then import
into excel as a delimited file.
We use this trick all the time.
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: James Piper [mailto:admin@...]
Sent: Wednesday, September 01, 2004 2:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OT: Report Builder Export to Excel


Does anyone know if you can write a routine within a report
builder to
export the information to an excel file?







[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note:
You must have already linked your email address to a yahoo id to enable
access. )
(1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

<http://us.ard.yahoo.com/SIG=129s3oj4u/M=296572.5305651.6444487.3001176/
D=groups/S=1705007183:HM/EXP=1094148802/A=2195326/R=2/SIG=12itov71u/*htt
p://clk.atdmt.com/VON/go/yhxxxvon00700677von/direct/01/&time=10940624023
22297>

<http://us.adserver.yahoo.com/l?M=296572.5305651.6444487.3001176/D=group
s/S=:HM/A=2195326/rand=134395120>


________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]