Can import from excel file?

[blakeb]

:P [color:blue]I'm trying to create a stand-alone app that can create a file that contains a report so it can be emailed. I made a button that created a pdf of the report, but stand-alones cant save as pdf. (******* you adobe). Anyways, the only thing I can save the filled out report as after the app is created is an excel file with a long row of columns and values. This is highly unreadable and unprofessional looking and just wont work. Please let me know if you know if a way to save a filled out report in a standalone.

Is is possible to have a button in my app that opens the saved excel file and populates the fields in my form with them? I just want something that is readable.

[mr_vodka]

Why dont you just use a third party PDF writer? See the links on this post for some ideas

[MorFologist]

If you really need to stick with excel, try creating the form on a first page, looking pretty, referencing the cells from the exported date, which is pasted onto the second page of the "form" file.

In my set up, the user copies the row of date from the exported file, and uses a macro to paste to the spreadsheet (so that it lands on the correct row in the excel file). The recipient prints from the "form" view, edits in another "entry" view, then when my user gets it back, he hits a macro to prep that returned data for FM import.

And now, to post my own question about this very set up! (I so need to make a runtime of this)

I'll send you the excel file if you are curious.