#1   Report Post  
Posted to microsoft.public.excel.misc
JimMay
 
Posts: n/a
Default Excel: PC versus Mac

I've just been asked if I could write some code and
provide worksheet functions or UDFs to a client of a
CPA friend of mine. My years of experience (in Excel)
are solely with the PC - & Windows --.

I know nothing about the MAC. Is there a difference
In ?:
1) Spreadsheet and/or functions
2) VBE - Modules, etc

TIA,

Jim

  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default Excel: PC versus Mac

In article <Ptr4g.16357$fG3.4901@dukeread09, "JimMay"
wrote:

I've just been asked if I could write some code and
provide worksheet functions or UDFs to a client of a
CPA friend of mine. My years of experience (in Excel)
are solely with the PC - & Windows --.

I know nothing about the MAC. Is there a difference
In ?:
1) Spreadsheet and/or functions
2) VBE - Modules, etc


Spreadsheet functions are identical. Certain protection modes aren't
available in MacXL. In general, if it works in XL97, it works in MacXL.

WinXL doesn't have Page Layout View.

VBA is version 5 (equivalent to WinXL97), so no VBA6.x functions (e.g.,
Join, Split, Replace). ActiveX objects aren't supported in MacXL. There
are a (very) few differences in some methods (e.g., the FileType
argument in the GetOpenFileName method). WinXL doesn't support
MacScript.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
Open Excel 2003 from Windows Explorer pmpjr Excel Discussion (Misc queries) 9 September 11th 06 03:58 PM
convert pocket excel back to standard excel kevroyal Excel Discussion (Misc queries) 1 February 16th 06 11:35 AM
Opening two separate instances of Excel Ron Bishop Excel Discussion (Misc queries) 2 August 4th 05 05:30 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM


All times are GMT +1. The time now is 04:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"