Creating a Spreadsheet

[Nancy Palmquist]

Harold,

If your version of filepro is recent (5.x) you can do this:

declare filename                 'you can  add edit and length if you want
filename="c:/maclbs/name"{doedit(@td,"ymd",6"){".csv"
filename=xlate(filename,"/",chr("92") )                         'flips 
the slashes
export word merge=(filename{"")

Works great.

I put today's date in the name of the file.

Nancy

On 6/11/2010 3:27 PM, Harold wrote:
> Hi,
>
> Hey John, I am still going.  Hope you are doing well.
>
> Using Filepro, I can I create a spreadsheet and have it placed into a directory, but
> how can the name of the file be automatically changed each time the file is created.
>    I would even like to have the date as part of the name.  For example
> "LBS07/20/10.CVS."  Everything is working except the name change.  I am using:
>
> Then: export Word merge=C:\MACLBS\NAME.csv
>
> Harold
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>    

-- 
Nancy Palmquist         MOS&  filePro Training Available
Virtual Software Systems    Web Based Training and Consulting
PHONE: (412) 835-9417           Web site:  http://www.vss3.com