applescript

Good morning all, I hope you are having a great day. I hope you can help as I am now stuck on the code as I have tried numerous iterations and I can seem to resolve the "Compile Error" message on file dialog object. I am sure I am missing something, but I can't see the forrest through the...

Hello! I wanted to see if there was a way to Use VBA to create a .scpt file in the application scripts folder ("/Users/ComputerName/Library/Application Scripts/com.microsoft.Excel") on MacOS? I am able to read files from that folder using myfile = "/Users/" & Environ("USER") &...

Thank you for helping me out. I'm trying to change cell N that contains the subcategory of a music track if it finds the track title I'm looking for in column R. (the same track titles appear multiple timex across the sheet and I can't modify the Excel to do a pivot table, and I can't add a...

Greetings! I created a code using VBA that allows you to send a range of cells as an attachment in Excel 2011. It also allows you to send the mail via Applemail and Outlook (help on one would be enough!). This code was modified from Ron De Bruin's code. Is there a way to utilize this...

Greetings all! I created an Excel program/workbook that uses vba macros throughout for others to benefit from. The only problem is, some people do not have Excel 2011, instead they only have 2008 which does not utilize macros. 1. I was told I can still automate Excel using applescript. If...

Hi, I need to convert some windows Excel VBA into Applescript. Does anybody have experience with this? 1) Is it possible to create code in Windows Excel which is Applescript friendly? 2) Is there a conversation table available to convert standard VBA to Applescript? Thanks in advance.

Dear all, I have an issue that I cannot use Macros for, because we have office 2008 for mac and won't be switching to 2011 anytime soon. In our timesheets, we have a row for each differnt project/category and a sum for the row at the end. Problem is this: I want everyone to be able to insert...

Hi all, this is the file I'm talking about: http://rapidshare.com/files/436674965/TStest.xlsx I'm trying to make a new timesheet for my company; I had made one with a nice macro in excel 2011 but since evrybody at the office uses 2008 so I wasted my time :) What I want to do is have a...