Excel format Blank Title 62002

Yahoo Archive
1
When you print preview a report in Vantage, a text file is created.
Once you have found the directory where it is stored, you can import the
text file in Excel. It is not very pretty, but it gets the job done.



Christy J. Morris

Controller
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140


513-716-6370

513-576-8986 (fax)
www.coldjet.com


align=baseline border=0>
Setting industry standards in dry ice technology and solutions for over
20 years.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ken Taylor
Sent: Monday, January 21, 2008 6:40 PM
To: vantage@yahoogroups.com
Subject: [Vantage] excel format



Is there an easy way to get the indented version of the BOM listing
report into an excel spreadsheet? Any ideas will be appreciated. Thanks.

__________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
<http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ>

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





[Non-text portions of this message have been removed]
2
Is there an easy way to get the indented version of the BOM listing report into an excel spreadsheet? Any ideas will be appreciated. Thanks.








____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ


[Non-text portions of this message have been removed]
3
We're on ver. 6.10.541:

1) Use a BAQ, which may be ugly, trying to get all of JObAssy's and JobMtl's to correctly come in under the correct 'parent'

2) Use ODBC, from Excel to 'go and get' your BOM, using VBA in excel.
ie: Make a small front-end form in Excel that allows you to pick your part number than gets your B.O.M.

3) Write a Progress routine , using 'COM' to establish an 'Excel Object' then get the data and place it into the proper cells.

There is probably an easier way that I am not thinking of at the moment.

Ken Taylor <ktaylorv@...> wrote:
Is there an easy way to get the indented version of the BOM listing report into an excel spreadsheet? Any ideas will be appreciated. Thanks.

__________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

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






---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.

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