user-defined functions on Excel

[Marcio]

At work I use a Windows PC and i am planning on buying a
laptop in the next few days. I would love to buy a
Powerbook or iBook. However it would be absolutely
critical that the excel spreadsheets we use at work
funtion well on a Mac. My main sheet is quite complex,
there three workbooks with links to each other, and more
than 10 sheets per workbook. We also run functions written
in visual basic (no macros, just functions). I would like
to know if, in your experience, such a mammoth spreadsheet
would work well and seamlessly when copied onto a Mac?
Less critical but also important we have other
spreadsheets with links to non-excel applications (mainly
financial databases such as Bloomberg and reuters
terminals). Would that work on a Mac too?

Many thanks

 

[JE McGimpsey]

At work I use a Windows PC and i am planning on buying a
laptop in the next few days. I would love to buy a
Powerbook or iBook. However it would be absolutely
critical that the excel spreadsheets we use at work
funtion well on a Mac. My main sheet is quite complex,
there three workbooks with links to each other, and more
than 10 sheets per workbook. We also run functions written
in visual basic (no macros, just functions). I would like
to know if, in your experience, such a mammoth spreadsheet
would work well and seamlessly when copied onto a Mac?

Seamless is hard to tell without knowing exactly what the UDFs do. The
worksheet functions will work, as will links. MacXL uses VBA5, so if
your functions use VBA6 commands (e.g., Replace, Split, Join, etc), they
won't work correctly. If you're familiar with VBA, there are easy
workarounds that I could give you if you need them.

 

[Guest]

Thanks for the reply. We do use VB6 but the functions we
use are more "math", they return a number but dont perform
any "action" so I think commands such
as "replace", "joint", "split" (which I have never used)
wouldnt be part of them.