Re: CUTLCPY


[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]

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.


Follow Ups:



Post a Followup

Name:
E-Mail:

Subject:

What is the name of the main Signature System's Product?  

Comments:

Optional Link URL:
Link Title:
Optional Image URL:

You may attach up to 5 files to your followup (see below):





Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.


[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]