Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Applescript Problem
Hi All
Well this is not directly relevant but I thought someone might have an idea I am trying to create an applescript to control excel and run excel macros on my OSX mac. I have my macro in excel and it works, but I want to open text files that are not from a mac or excel formatted, so in the applescript I have tried OpenText theFile SpaceDelimiter space And OpenText theFile Origin xlMSDOS StartAtRow 1 DataType xlDelimited SpaceDelimiter tab with TreatConsecutiveDelimitersAsOne And variations on the theme, I am defining the file to open as theFile Any ideas why this does not work thanks Alex tell application "Microsoft Excel" OpenText theFile SpaceDelimiter space Evaluate "'Personal Macro Workbook'!Script1()" end tell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Applescript: get range of selection | Excel Discussion (Misc queries) | |||
How to record Excel with AppleScript? Recordable or not? | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |