Buddy, It works perfectly if I put the Sheet_index number in, and it also works when I use Karen’s suggestion of creating the command as a variable and then launching the variable. It just will not let me use the variable directly in the command.
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 Buddy Walker Sent: Tuesday, April 07, 2015 12:21 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Gateway Sheet Index One more thing, make sure the work sheet does not exist. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Albert Berry Sent: Tuesday, April 07, 2015 10:54 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Gateway Sheet Index 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]<mailto:[email protected]> From: [email protected]<mailto:[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
