Jonathan,
My mistake was confusing, to me anyway, for not having tried to use a
variable before with anything other than copying an fp7 file. When the
dialog box comes up to 'add' a file and you select Excel, filemaker adds
the xls extension, hence I didn't think it needed to be deleted.
Which made me think it was not needed in the variable calc.
Thank you for the support and help.
Lee Mills
Jonathan Fletcher wrote:
After the responses, did you see where you goofed, Lee?
In the Set Variable you defined the name as "$data" and in the
Export Records you called for "$data.xls." They are not the same,
so FMP used the new name you told it to use, not the variable
you previously defined.
j.
On Aug 21, 2008, at 1:29 AM, Lee wrote:
I have set a variable script that refuses to work if anyone has an
idea where the scripting is wrong then I'd appreciate any input.
Set Variable ($data; (Value:Get(FileName)&"_"&main::name)
Exports Records (No dialog;"$data.xls", Unicode(UTF-16)
'main::name' field is just a text field with a name in it.
The exported file just reads $data.xls rather than for example
"Main_John" which is what the 'name' (text) field reads on the screen .
any help appreciated. I have done other variable scripts when saving
files but this one just seems to be wrong somewhere.
Lee Mills
--
--
Jonathan Fletcher
[EMAIL PROTECTED]
Project Foreman
NewMedia Construction Co.
--
