Using field for file name for export in FM6

[djlane]

Hi,

This question has been asked for FM8 but I don't see any post regarding FM6.

I want to export to a file, using data from one of my fields as the filename. eg, create a PDF document of an invoice, using the invoice number as the filename.

Is there a script step that an do this in FM6??

thanks

[IdealData]

Not possible in FM6. Also PDF generation only came out with FM8.

[djlane]

OK Thanks.

Agreed that PDF output came only in FM8, but if you have Adobe Acrobat installed (not just the reader) you can create a PDF from ANY application. You just select output to PDF as a printer.

[Wim Decorte]

The naming functionality is in the PDF printer. I've used Win2PDF extensively for this. Win2PDF requires you to write the name of the PDF to the registry before printing so it took a bit of VBscripting to do that, but it worked fine.

Alternatively you could print to a fixed name and then use the OS to rename and/or move the file automatically.

[djlane]

Thanks Wim,

Unfortunately VBscripting is out of my league. I just have to go with renaming the file manually each time.

[Wim Decorte]

For just the renaming after the file is printed to a fixed name you don't need VBscript.

You use the "Send Message" (FM6) or "Send Event" (FM7/8) script step to execute an OS command line:

%comspec% /c ren c:fixed.pdf c:somethingElse.pdf

You can use a calc to make this string so it can use your data.