Posted by Grant Foraker on July 15, 2016 at 12:38:41:
In Reply to: Re: csv printing posted by jim guerber on July 15, 2016 at 10:02:17:
The original idea came from Jon when he posted to the Code Library in 2009.
http://codelibrary.signature.net/messages/27.shtml
I've asked my customer to send me the MASTER.XLS. I didn't/don't have the skill to do the Excel side so this was done by their IT guy.
It's slick. The user runs the Comet program, at the end ...
!
!================== COPY CSV FILE TO AREA OUTSIDE OF COMET ===================
!
INQUIRE (10,2666) KEY = 'OMLL-1'
LET DESTWORK$ = 'MATL-XL.CSV,TMP,MATL-XL.CSV,' ! 11/17/2009
LET DESTWORK$ = DESTWORK$ + STRIP(DATAPATH$)
LET DESTWORK$ = DESTWORK$ + ',N,N,N' ! 11/17/2009
PRINT (#) DESTWORK$ ! 11/17/2009
ENTER 'CUTLCPY' ! 11/17/2009
!-------------------------------------------------------------------------------
!
!===================== AUTO-LAUNCH MICROSOFT EXCEL W/FILE ====================
!
INQUIRE (10,2666) KEY = 'OMLL-2'
LET LAUNCHP$ = DATAPATH$
PRINT (LAUNCH=LAUNCHP$) ! 12/01/2009
INPUT "" ! 12/01/2009
!-------------------------------------------------------------------------------
The 2666 reads are to a file (#PATH) where I keep paths and file names.
The user sees the Comet program finish and up pops the XLS with the data populated.
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.