T O P I C R E V I E W |
Pista |
Posted - 03/07/2002 : 05:03:39 AM Hi, I import an ascii file and leave the "rename worksheet according to filename". => the name of worksheet changes accordingly. Which command allows me to store this name in a string. any help appreciated steff please mail the answer also to stefan.godo@iw.uni-halle.de |
2 L A T E S T R E P L I E S (Newest First) |
Pista |
Posted - 03/07/2002 : 09:30:12 AM thanks, that was the right answer: string system variables. steff |
Mike Buess |
Posted - 03/07/2002 : 07:55:50 AM I think you're asking how to store either the worksheet name or filename as a string. (In your case they should be the same.) The string variable %H always holds the name of the active worksheet. The string variable %A usually holds the name of the most recently imported file. So %F=%H or %F=%A should store the name as the string variable %F. If I misunderstood the question then please clarify.
Mike Buess Origin WebRing Member |