RE: Purchase Requisitions and EXCEL

We've used a variety of file transfer and query tools to build functionality
such as this. My personal favorite is Crystal reports. It allows you to
build a report that matches pretty much all of text and data portions of the
spreadsheet and provides export directly into Excel and several other
formats. It also allows you to preview the data before the export, if
desired.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Baldwin, Wayne (ALIE)
Sent: Friday, January 16, 2004 9:13 AM
To: mapics-l@xxxxxxxxxxxx
Subject: Purchase Requisitions and EXCEL




> We would like to pass some requisition fields as parameters to an  Excel
spreadsheet. Does anyone have a sample VB program which takes the parameters
and places in Excel?  We are not a VB shop but I do have VB software and
with a simple skeleton program I could probably figure it out.   and
although I can get the User definition to collect the fields I need  -still
can't actually place data in Excel.
> 
> 
> I don't want to use the copy to clipboard as it takes all the column
headings/lines/spacing with it each time!
> Any suggestions would be greatly appreciated.
> 
> 
> 
> Wayne R. Baldwin
> Senior Programmer Analyst
> Smiths Aerospace Electronic Systems - Long Island
> 1000 MacArthur Memorial Highway
> Bohemia,  NY  11716
> T: (631) 467 - 5500  Ext 258
> F: (631) 467 - 5943  
> 



******************************************
The information contained in, or attached to, this e-mail, may contain
confidential information and is intended solely for the use of the
individual or entity to whom they are addressed and may be subject to legal
privilege.  If you have received this e-mail in error you should notify the
sender immediately by reply e-mail, delete the message from your system and
notify your system manager.  Please do not copy it for any purpose, or
disclose its contents to any other person.  The views or opinions presented
in this e-mail are solely those of the author and do not necessarily
represent those of the company.  The recipient should check this e-mail and
any attachments for the presence of viruses.  The company accepts no
liability for any damage caused, directly or indirectly, by any virus
transmitted in this email.
******************************************

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.