Just for kicks try using an ampersand on the vtabpage instead of a dot.
Probably won't work any better, but you never know.
Albert
On 4/7/2015 7:48 AM, Frank Taylor wrote:
Well that is taking the scenic route, but we reached our destination…
Proving literally thinking outside the box ( or Command) and coming in
a different way worked again, thanks Karen..
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]
*From:*[email protected] [mailto:[email protected]] *On Behalf Of
*Karen Tellef
*Sent:* Tuesday, April 07, 2015 9:28 AM
*To:* RBASE-L Mailing List
*Subject:* [RBASE-L] - Re: Gateway Sheet Index
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] <mailto:[email protected]>>
To: RBASE-L Mailing List <[email protected] <mailto:[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]_ <mailto:[email protected]>
--
A democracy ..." can only exist until the majority discovers it can vote itself
largess out of the public treasury."
Attributed to Alexander Fraser Tytler 1747-1813
