Evening all -
I'm trying to export an XLS file to the current user's desktop using Win
system variables.
Based on some google responses, I tried:
SET VAR vExportFileName = ('%UserProfile%\Desktop\' + .vExportFileName)
GATEWAY EXPORT XLS .vExportFileName +
SELECT * FROM TxnHistExceptTmp +
OPTION COL_NAMES ON|SHOW_PROGRESS
RETURN
vExportFileName =
%UserProfile%\Desktop\Exceptions_011211_2111.XLS
But that winds up in places unknown.
I don't believe it's a file name problem, because the file has an XLS
extension and works if I hardcode a path.
This is in Win 2K, but also needs to run XP & 7.
Any ideas?
TIA
D
