Convert VB macro to applescript?

I have been on here a few time working on the same project. There is about 45-50 hours put into making my macros work. The person I was doing the work for ended up buying a MAC instead of a pc. The guy at the store said all the macros and stuff should copy over fine, but they do not.

Is there any easy way to translate my VB code into apple script?

The guy with a mac should take a look at codeweavers and a version of office 2000. Or make a dualboot with his mac (need a licence/copy of wndows) (bootcamp). Or take a look at parrallells desktop or some other virtualisation software.

If you don't use forms, no doubleclick event, no selectionchange event, take a look at zoho spreadsheet. Recently they added vba to this program (no need to relearn because language is the same).

Charlize

ps. If you can find a version of office 2004 for mac you are in luck. This version still has vba included.

So I am still having issues with this. The options that have been suggested so far will not work since I am making this for a friend of mine how is very computer illiterate. I am attaching the workbook with the macro that works and I am also posting the code from said macro.

Here is the code when the button on the first page is clicked:

Please Login or Register  to view this content.

Here is the code that the previous code runs:

Please Login or Register  to view this content.

Here is the final goal that I am looking for:

1. To have this workbook and macro work in Excel for mac, I believe it is the 2008 version.

2. The data gets entered into the empty white cells on the "job information" tab.

3. Click the button on the "job information" tab.

4. The macro does the following:

a. Select the "job list" tab
b. Copy row 2
c. Paste Special / values only into row 3
d. Copy row 3
e. Search from the bottom of the tab and paste the data into the next empty row. In other words, have the macro paste the data into the next blank row so that each item just appends to the list.
f. Place the active cell into A1
g. Select the "job information" tab.
h. Clear all of the information in the white cells (not the formulas)
i. place the active cell into C3.

I hope this helps and that someone can help me. This project is kicking my butt and I really need to get it done soon.

Thanks in advance to anyone who is willing to give this a shot. You are amazing!

Tidying up your code might help isolate the problem.

Please Login or Register  to view this content.