Posted by Grant Foraker on November 08, 2013 at 11:39:43:
In Reply to: CUTLCPY posted by Steven Hagen on November 08, 2013 at 09:41:31:
Steve:
Here's the two part CUTLCPY and LAUNCH logic you requested. And the paths in the #PATH control file.
!================== COPY CSV FILE TO AREA OUTSIDE OF COMET ===================
!
INQUIRE (10,2666) KEY = 'OMLL-1'
LET DESTWORK$ = 'MATL-XL.CSV,TMP,MATL-XL.CSV,'
LET DESTWORK$ = DESTWORK$ + STRIP(DATAPATH$)
LET DESTWORK$ = DESTWORK$ + ',N,N,N'
PRINT (#) DESTWORK$
ENTER 'CUTLCPY'
!-------------------------------------------------------------------------------
!
!===================== AUTO-LAUNCH MICROSOFT EXCEL W/FILE ====================
!
INQUIRE (10,2666) KEY = 'OMLL-2'
LET LAUNCHP$ = DATAPATH$
PRINT (LAUNCH=LAUNCHP$)
INPUT ""
!-------------------------------------------------------------------------------
OMLL-1 "\\Psr_nts2\Com_Data\COMET"
OMLL-2 "\\Psr_nts2\Com_Data\COMET\Master Material Report - MASTER.xls"
--------------------------------------------------------------------------------
The xls file has an "Auto" macro that imports the CSV file, does Excel stuff, and leaves the user at the point where they have to do a "Save As". There's an "Auto" example by Jon Sacks in the Code Library.
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.