Excel 2008 : Excel 2008 and formulas/VB, etc.

[tkokkinos]

Please excuse my ignorance of your forum but I am new to Excel 2008.
I am, however, pretty competent with Excel for Windows and therein lies the problem.

I worked for a company using Windows Excel (different versions) where I did complex VB and macros, formulas etc. It all works fine on Windows. I lost that job when they folded but the company regrouped and they are now using Macs with Excel 2008. They want me to adapt the old estimating spreadsheet to the Mac Excel but all of the programming goes out the window, yes? At least that is the message I see when it loads on the Mac. I noticed, however, that the old formulas in cells still seem to work.

This is all driving me crazy; I did some research on the Internet and found that Excel 2008 supposedly supports its older xml (?) Excel macro language?. I then found a reference to a .sit archive, which I downloaded, "unstuffed" using a free version of Stuffit and discovered that the 5 archive files could be read and formatted with Word 2007 and I saved them as .doc files. The files look great in Word and all of the macro commands are neatly listed at the top and individually described on the pages.

Anyway, my confusion deepens and I am not sure what my next move needs to be. I am basically trying to copy rows of data on one page which meet a criteria and paste them sequentially to another page. This needs to be done repetitively with new criteria. I've done this in VB and cannot see how I can do it with this version of excel without some PAIN!

I'm not asking for code to do it but how to find out what my alternatives are within the Mac Excel 2008 platform.

Please advise and thanks for helping me with this. I hate Microsoft ..... GRRR!

[romperstomper]

Your alternatives as far as I can see are:
1. Learn the XLM required to do what your VBA did.
2. Learn Applescript
3. Upgrade to 2011, which does support VBA.