I have a solution that I made several years ago to manage (mangle) gobs of data from hundreds of sources for a Print On Demand Solution.. I've got a LOT of work in this..

I have a new client that I can taylor this application to his needs and not have to do literally months of work on. There's one minor snafu....

The one I developed is on the Mac platform. A very important part of it is a script that uses an Applescript to import a WAD of files in one session and do various nasty things to the data during import. Of course this client wants to run it on a Window 7 box.. I plan on providing a runtime solution..

The (borrowed) script I have used (with some minor folder name changes is:

set theFolder to choose folder



tell application "Finder"

        set theFiles to (files of theFolder whose name extension is "xls") as alias list

        set old_delims to AppleScript's text item delimiters

        set AppleScript's text item delimiters to ASCII character 13

        set theFiles to theFiles as Unicode text

        set AppleScript's text item delimiters to old_delims

        return theFiles

end tell

The $64K question is how do I use the portion of the script that uses Applescript on a Windows box? Is there a magical Applescript to VB application?

Thanks, again for any help....

The only native FileMaker function that comes close is Get(DocumentsPathListing). But that won't allow the user to select a particular folder as in your script.

I'd probably spend a few bucks and use Troi File.

http://filemaker-plugins.com/features/file-manipulation/

The only native FileMaker function that comes close is Get(DocumentsPathListing). But that won't allow the user to select a particular folder as in your script.

I'd probably spend a few bucks and use Troi File.

http://filemaker-plugins.com/features/file-manipulation/

If I do use the Troi plugin, what happens when I create the runtime?

Plugins can be bundled with runtimes. If this is just for one client, typically they would register the plugin for their machine via the Prefs dialog. If it's for multiple clients, you'd buy a developer license and run a script at startup that registers the plugin.

http://www.troi.com/support/faq1.html#24

Plugins can be bundled with runtimes. If this is just for one client, typically they would register the plugin for their machine via the Prefs dialog. If it's for multiple clients, you'd buy a developer license and run a script at startup that registers the plugin.

http://www.troi.com/support/faq1.html#24

Thanks for the info.. Just wish it was as easy in Windows to do what is so easy via Applescript...

Portland, eh? Spent a couple of weeks in Medford.. I love your part of the country.. Took the jetboat river ride to Hell Canyon (I think!)..