Excel VBA compatibilty???

D

David_be

macrumors newbie

Original poster

• Oct 6, 2003

• #1

I have some problem to use on my mac excel vba applications (.xls) made on windows.

IS it compatible and if not, Does a solution exist.

ps: if it is not compatible, why Microsoft make Office for Mac???

Yours,
David Descamps

 

macktheknife

macrumors 6502a

• Oct 6, 2003

• #2

It should be compatible--only very specific types of functions are not cross-platform. What is the problem?

 

Kwyjibo

macrumors 68040

• Oct 6, 2003

• #3

My computer science for non-techinical majors is starting macros and VBA's soon.... so I'm hopign i'll be able to use my mac like I did for the SQL stuff

 

encro

macrumors 6502

• Oct 6, 2003

• #4

Using v.X should be fine for templates/macros. I just completed my module; in fact some of the generated VBA code on the mac is cleaner than on Office XP.

 

P

Pexy

macrumors newbie

• Oct 7, 2003

• #5

Basically, it works. I often exchange Excel files with VBA between my Mac and the PC at work. I always have error messages when using specific commands from the analysis add-ins, because the network installation of Office at work is mixed German/English; but this problem I have as well with the VBA macros from Office97 which we used before.

So what specific error messages do you get, and where in the code?

Also it would be helpful to know with version you use on both sides.

Pexy

 

D

David_be

macrumors newbie

Original poster

• Oct 8, 2003

• #6

Excel 2000 on Windows:

example:

Cells.Find(What:=valeur_a_mod, After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
False).Activate

Excel v.X on Mac

example:

Cells.Find What:="", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
False, Activate:=True


Quite different isn't it? 😕 i've too problems with listbox: no rowsource anymore in properties. 🙁


And I've had a problem with a message when i was trying to open .xls files with macros in: "Object library not registered

but I get ride of it with a hint at:

http://www.macosxhints.com/article.php?story=20021115060129655

 

C

callan

macrumors newbie

• Aug 23, 2005

• #7

.dll files

I have problems with some VBA add ins that have been compiled such that they use .dll files, and therefore dont work on EXCEL vX. I dont know whether this is solved in anyway using EXCEL 2004 but at the mo Im having to use Virtual PC with EXCEL to run these macros.

Annoying? YES!! 😡