Re: Need to process all files in folder with Applescript and Excel
Re: Need to process all files in folder with Applescript and Excel
- Subject: Re: Need to process all files in folder with Applescript and Excel
- From: R M <email@hidden>
- Date: Thu, 21 Sep 2006 21:32:51 -0400
- Thread-topic: Need to process all files in folder with Applescript and Excel
Dave,
Thanks so much for this assistance. I am trying to get this puppy up and
running but am having some difficulties. I will be working on it later
tonight and tomorrow, so will update you with further info when I have
something to tell you. The "without invisibles" piece is important -- I've
only recently realized that that may be why the files weren't being
appropriately recognized. No matter what happens I will be sure to let you
know and share what I hope will be a working script solution.
Thanks again.
Rob M at DecisionInformatics (at) gmail.com
> From: Dave Balderstone <email@hidden>
> Date: Thu, 21 Sep 2006 12:19:04 -0600
> To: R M <email@hidden>, Applescript Users
> <email@hidden>
> Subject: Re: Need to process all files in folder with Applescript and Excel
>
>
> On 21-Sep-06, at 10:41 AM, R M wrote:
>
>> However, the AppleScript as written will only convert one file at a
>> time. I
>> need a way to have this script loop through the specified
>> directory, choose
>> each successive file, convert it, save it, and then go back to the
>> next file
>> in line in the same folder. I'm sure it is a simple fix, but I
>> can't find
>> any reference or example to help me chunk through this directory
>> one file at
>> a time. I've been scouring for reference for this but just can't
>> fnd example
>> syntax.
>
> Untested:
> ---------------
> set the_folder to "Users:mynameesktop:TESTfolder:"
> set the_folder_list to list folder the_folder without invisibles
> repeat with x from 1 to count of the_folder_list
> set the_file to the_folder & item x of the_folder_list
> set the_new_file to the_folder & the_file & "_new.html"
> tell application "Microsoft Excel"
> activate
> open the_file
> save active workbook in the_new_file as HTML
> close active workbook without saving
> end tell
> end repeat
> ----------------
>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden