Re: Importing to Excel
Re: Importing to Excel
- Subject: Re: Importing to Excel
- From: David Wignall <email@hidden>
- Date: Thu, 14 Aug 2003 18:34:37 +1200
on 14/8/2003 9:08 AM, Courtney Moore at email@hidden wrote:
>
Hello all you fellow apple scripters.
Hello
>
I am attempting to learn how to script excel.
>
Does anyone have any guidance or references? Or simply a starting point?
1) Recording is your friend
2) Have a look at the VBA Help and compare it with Excel's dictionary
>
What I would like to do is create a script that will
>
Get external data and import text file, set the delimiters as commas
>
Then format one of the cells as numbers and set it to 6 decimal places
>
And then save the finished worksheet.
>
Simple right?!!
Simple. Right :)
tell application "Microsoft Excel"
set TextFileToImport to (choose file) as string
OpenText TextFileToImport with CommaDelimiter
set NumberFormat of Range ("B:B") to "#.000000"
Save ActiveWorkbook In (((path to desktop) as string) & "Text
Import.xls") As xlNormal -- save... is one line
end tell
--
Dave
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.