Closing a workfile

[javiersan]

Hi,

I have an excel file with data I want to import, I know how to open it and create a workfil(Wfopen) but I don't know how to close the workfile using a variable that contains the workfile name.

Code: Select all

%fname= "data23feb09"
%evname=%fname+".wf1"
%fname=%fname+".xls"

wfopen %fname colhead=2 namepos=first range="Daily"

'This works
close data23feb09.wf1

'This does not work
close %evname

Could you please help me with this?

Thanks,

Javier

[Jay]

Hi,

just use a replacement variable with those brackets: { }

In your example this would look like this:

close {%evname}

[javiersan]

Thanks!