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]>
