I'm guessing you might have to build a vCommand variable if it doesn't work
that way? You know: SET VAR vCommand = ('GATEWAY IMPORT... SHEET_INDEX' &
.vTabPage & '| COLUMN_COUNT.....), and then &vCommand
Karen
-----Original Message-----
From: Frank Taylor <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Tue, Apr 7, 2015 8:06 am
Subject: [RBASE-L] - Gateway Sheet Index
I am attempting to Import an Excel file with multiple sheets for each location.
I ask the user to select the location they want to import and using a lookup I
load the variable VTabPage as an integer value with the Sheet Number
When I issue the command
GATEWAY IMPORT XLS .vfilename CREATE &vtablename OPTION SHEET_INDEX
.vtabpage|COLUMN_COUNT 5|FIRST_ROW 12 It spins for 5 seconds but nothing
happens. If I issue the same command but put a number in the Sheet Index, it
works (GATEWAY IMPORT XLS .vfilename CREATE &vtablename OPTION SHEET_INDEX
5|COLUMN_COUNT 5|FIRST_ROW 12)
I am sure I am missing something here.. Blues Clues anyone ?
Thanks
Frank Taylor – Director of Information Technology
F.J. O'Hara & Sons, Inc - Araho Transfer Inc.
Boston, MA - Rockland, ME - Miami, FL
Direct Dial - 617-790-3093
Email: [email protected]
