Excel VBA compatibilty???

[David_be]

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]

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

 

[Kwyjibo]

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]

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.

 

[Pexy]

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

 

[David_be]

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

 

[callan]

.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!!