THANK YOU JEFF !!!!!
Fritz
-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto:[email protected]] Im Auftrag von Richardson,
Jeff
Gesendet: Sonntag, 6. Juli 2014 14:48
An: RBASE-L Mailing List
Betreff: [RBASE-L] - RE: LAUNCH Excel file with Variable and CHOOSE
Instead of the single command:
LAUNCH e:\rbti\rbg95_64\dbdrfl\iv_exceldata\(&vchoosei3)
Can you instead use something like:
SET VAR vtest = (' e:\rbti\rbg95_64\dbdrfl\iv_exceldata\' + . vchoosei3)
LAUNCH &vtest
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dr. Fritz
Luettgens
Sent: Sunday, July 6, 2014 7:42 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - LAUNCH Excel file with Variable and CHOOSE
Rbase 95_64, Win7
Hi,
I want to start with the CHOOSE command and a variable an Exel file, but the
result is it only opens me the specified folder.
The vars are shown correctly at the R:Prompt with "show vars".
CHOOSE: ok
path: ok
var content: ok
shown files in CHOOSE: ok
LAUNCH Command: instead of (&vchoosei3) manually "filename.xls" ok
Point is: the content of the variable is not recognized in the command
(wether "&" or".") There must be mistake in my LAUCH command only, but
cannot find it.
If anybody sees my mistake ... :)
Thank´s
Fritz
CLS
CHOOSE vchoosei3txt FOR #LFILES IN
e:\rbti\rbg95_64\dbdrfl\iv_exceldata\*.XLS TITLE "EXCEL-TABELLEN" CAPTION
"(c)drfl -- INVENTUR" LINES 25 OPTION THEMENAME Razzmatazz IF vchoosei3txt
IS NULL OR vchoosei3txt = "[Esc]" THEN
GOTO done
ELSE
SET VAR vchoosei3 = .vchoosei3txt
ENDIF
LAUNCH e:\rbti\rbg95_64\dbdrfl\iv_exceldata\(&vchoosei3) |w LABEL done CLEAR
VAR vchoosei3txt, vchoosei3 RETURN
