Jump to content

Excel scripting


This topic is 7639 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Need help with an applescript for excel. Using a mac 9.02 and office 2001. I have an excel file with only one Column called User_ID. I Need to take all the strings in that column and add them to a listbox in a Realbasic5 app (Populate a listbox). But when my Excel activates I need a file open dialog box so I can choose which Excel file I want to use at that time. myFile = Application.GetOpenFilename ("All Files, *.*")

on run

tell application "Excel"

activate

open file dialog box

set A to Select Range "A1"

return A

end tell

end run

Link to comment
Share on other sites

And this has what to do with FileMaker?

Check the web, you will find (at the apple site) AppleScript lists. You might even chek M$ and see if they have an Excel List, I know that they have IE and OE, so maybe you can find help there. OR, maybe RealBasic has a list that could help you.

Lee

Link to comment
Share on other sites

This topic is 7639 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.