From tab text to Excel
From tab text to Excel
- Subject: From tab text to Excel
- From: Eric Geoffroy <email@hidden>
- Date: Mon, 11 Apr 2005 16:51:37 -0700
I'm going to add a repeat to this once it's working.
I have a tab delim text file, but putting the items into a worksheet I'm stymied. Some of the text in the file is separated by a space, but I'm only concerned with the tab. I mucked around with text item delimter.
set emmlyst to read EMMlog using delimiter {ASCII character 10} --(So far so good. the first line works. yay!)
tell application "Microsoft Excel"
set Value of Range "B1:B3" of Sheet 1 of Workbook "Workbook1" to paragraph 1 of item 1 of emmlyst
end tell
Well that didn't work. I realize I made a huge assumption that the tabs would be read into Excel. I'm not really an optimist usually.
Do I need to be granular about this and fill each cell with each word.
_______________________________________________
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