I guess over the years I have grown accustomed to just constructing a variable and running it with the ampersand; it usually takes me less time than trying to figure out how to make it run the other way, Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Frank Taylor Sent: Tuesday, April 07, 2015 12:07 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Gateway Sheet Index 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]] 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] 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 < <mailto:[email protected]> [email protected]> To: RBASE-L Mailing List < <mailto:[email protected]> [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: <mailto:[email protected]> [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
