Welcome to MacForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Opening Excel XP using Forms Controls in Mac OS 9

 
   Macintosh computer (Home) -> Excel RSS
Next:  Problem converting Excel application from PC to M..  
Author Message
pcw1

External


Since: Oct 07, 2003
Posts: 8



(Msg. 1) Posted: Thu Oct 09, 2003 5:07 pm
Post subject: Opening Excel XP using Forms Controls in Mac OS 9
Archived from groups: microsoft>public>mac>office>excel (more info?)

I developed a workbook with macros in Excel XP - Windows,
however, used checkboxes, radio buttons, etc., from the
Forms Control so that I can open it in Excel 98 - Mac.

1) Able to open the file in Excel 98 - Mac OS X with the
9.2 kernel.

2) Able to open the file in Excel X using the Mac OS X.

However,
3) NOT able to open the file in Excel 98 using the Mac OS
9. The following messages appear: "File error data may
have been lost", and "Out of memory", and then the file
closes.

What can I do so that I can port and open this file in
Excel 98/OS 9?

HELP!!!!!!

 >> Stay informed about: Opening Excel XP using Forms Controls in Mac OS 9 
Back to top
Login to vote
J.E. McGimpsey

External


Since: Dec 25, 2003
Posts: 551



(Msg. 2) Posted: Thu Oct 09, 2003 9:20 pm
Post subject: Re: Opening Excel XP using Forms Controls in Mac OS 9 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article <06ed01c38ea9$66ebc310$a301280a@phx.gbl>,
"pcw" <peter.cho-wing.RemoveThis@a.statcan.ca> wrote:

 > I developed a workbook with macros in Excel XP - Windows,
 > however, used checkboxes, radio buttons, etc., from the
 > Forms Control so that I can open it in Excel 98 - Mac.
 >
 > 1) Able to open the file in Excel 98 - Mac OS X with the
 > 9.2 kernel.
 >
 > 2) Able to open the file in Excel X using the Mac OS X.
 >
 > However,
 > 3) NOT able to open the file in Excel 98 using the Mac OS
 > 9. The following messages appear: "File error data may
 > have been lost", and "Out of memory", and then the file
 > closes.
 >
 > What can I do so that I can port and open this file in
 > Excel 98/OS 9?

Not sure what's happening, but I'll start with

a) make sure the relevant updaters have been applied:

Mactopia downloads:
<a style='text-decoration: underline;' href="http://www.microsoft.com/mac/download/default.asp" target="_blank">http://www.microsoft.com/mac/download/default.asp</a>

b) make sure that machine 3 has adequate memory allocated:

With XL closed, select the XL icon and choose File/Get Info/Memory
and allocate at least 3 times the default value for "preferred"
(25MB should be plenty). Leave the "minimum" setting alone.

c) Rebuild your desktop<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Opening Excel XP using Forms Controls in Mac OS 9 
Back to top
Login to vote
pcw1

External


Since: Oct 07, 2003
Posts: 8



(Msg. 3) Posted: Fri Oct 10, 2003 11:53 am
Post subject: Re: Opening Excel XP using Forms Controls in Mac OS 9 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I tried your #2 solution of re-allocating memory, and I
was able to successfully open the Excel file in 98/OS 9.

The memory is now set to:
Preferred Size: 90000 K
and I left the
Minimum Size at: 3072 K

However ...

When I tried saving I get the following:
"This file was created using a later version of MS Excel.
If you save this file using MS Excel 98, information
created with features in the later version may be lost.
_To retain the information in the original file, click No,
and use the Save As command (File menu) to save this file
with a different name.
_To continue with the Save, click Yes.
Continue with Save.

When I click Yes or No, and the file saves, I get the
message "The disk is full".

Should I allocate more memory to the Preferred Size? My
file over 1 megs.

Thanx for all your help in advance.




 >-----Original Message-----
 >In article <06ed01c38ea9$66ebc310$a301280a@phx.gbl>,
 > "pcw" <peter.cho-wing RemoveThis @a.statcan.ca> wrote:
 >
  >> I developed a workbook with macros in Excel XP -
Windows,
  >> however, used checkboxes, radio buttons, etc., from the
  >> Forms Control so that I can open it in Excel 98 - Mac.
  >>
  >> 1) Able to open the file in Excel 98 - Mac OS X with
the
  >> 9.2 kernel.
  >>
  >> 2) Able to open the file in Excel X using the Mac OS X.
  >>
  >> However,
  >> 3) NOT able to open the file in Excel 98 using the Mac
OS
  >> 9. The following messages appear: "File error data may
  >> have been lost", and "Out of memory", and then the file
  >> closes.
  >>
  >> What can I do so that I can port and open this file in
  >> Excel 98/OS 9?
 >
 >Not sure what's happening, but I'll start with
 >
 >a) make sure the relevant updaters have been applied:
 >
 > Mactopia downloads:
<font color=purple> > <a style='text-decoration: underline;' href="http://www.microsoft.com/mac/download/default.asp</font" target="_blank">http://www.microsoft.com/mac/download/default.asp</font</a>>
 >
 >b) make sure that machine 3 has adequate memory allocated:
 >
 >With XL closed, select the XL icon and choose File/Get
Info/Memory
 >and allocate at least 3 times the default value
for "preferred"
 >(25MB should be plenty). Leave the "minimum" setting
alone.
 >
 >c) Rebuild your desktop
 >.
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Opening Excel XP using Forms Controls in Mac OS 9 
Back to top
Login to vote
Display posts from previous:   
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]