Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros not working when file run on a Mac
I sent a file with a couple of simple macros to Mac user and she can't run
them. She said she went to a procare session at apple. They said I just needed to save the file in a MAC format. I'm a little confused by this. In the save as file type box, my choices seem to be a Mac text format or a Mac csv format. Won't those both just convert the whole file to text like fields? Thanks for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros not working when file run on a Mac
Also, I just tried saving as the Mac csv file type and this does not support
multiple tabs (which the file has). "Darby" wrote: I sent a file with a couple of simple macros to Mac user and she can't run them. She said she went to a procare session at apple. They said I just needed to save the file in a MAC format. I'm a little confused by this. In the save as file type box, my choices seem to be a Mac text format or a Mac csv format. Won't those both just convert the whole file to text like fields? Thanks for any help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros not working when file run on a Mac
The file format for MacXL98/01/v.X/04 is exactly the same as the file
format for WinXL97/00/02/03. Not sure what "can't run" means, but here are a couple of differences: 1) MacVBA is VBA5, so VBA6 functions (e.g, Join, Split) will cause a syntax error. 2) ActiveX controls are Win-only. Replace them with Forms toolbar controls to run cross-platform. 3) There are a very few differences in syntax (e.g., the GetOpenFileName filetype parameter; the VBA MacScript command only works on Macs, etc.) 4) API calls obviously only work on the platform they're designed for. In article , Darby wrote: I sent a file with a couple of simple macros to Mac user and she can't run them. She said she went to a procare session at apple. They said I just needed to save the file in a MAC format. I'm a little confused by this. In the save as file type box, my choices seem to be a Mac text format or a Mac csv format. Won't those both just convert the whole file to text like fields? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros not working when file run on a Mac
No csv file will support multiple tabs - csv is a flat-file format.
The difference between Mac and Win csv files is only in the end-of-line characters (ASCII 10 for Win, ASCII 13 for Mac). In article , Darby wrote: Also, I just tried saving as the Mac csv file type and this does not support multiple tabs (which the file has). |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros not working when file run on a Mac
Thanks, I think the issue is the ActiveX control, as what I meant when I
said "can't run the macro" was that she could not push the button (Created with the control tool box) that starts the macro. I will try to replace them with controls from the forms tool bar. "JE McGimpsey" wrote: The file format for MacXL98/01/v.X/04 is exactly the same as the file format for WinXL97/00/02/03. Not sure what "can't run" means, but here are a couple of differences: 1) MacVBA is VBA5, so VBA6 functions (e.g, Join, Split) will cause a syntax error. 2) ActiveX controls are Win-only. Replace them with Forms toolbar controls to run cross-platform. 3) There are a very few differences in syntax (e.g., the GetOpenFileName filetype parameter; the VBA MacScript command only works on Macs, etc.) 4) API calls obviously only work on the platform they're designed for. In article , Darby wrote: I sent a file with a couple of simple macros to Mac user and she can't run them. She said she went to a procare session at apple. They said I just needed to save the file in a MAC format. I'm a little confused by this. In the save as file type box, my choices seem to be a Mac text format or a Mac csv format. Won't those both just convert the whole file to text like fields? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trusted location for macros not working | Excel Discussion (Misc queries) | |||
Macros written in UK not working in US | Excel Discussion (Misc queries) | |||
Working with Macros - Help needed!!! | Excel Discussion (Misc queries) | |||
Working with Macros-Activesheet.Paste | Excel Discussion (Misc queries) | |||
Shift key to disable macros not working | Excel Discussion (Misc queries) |