Re: [mepbmlist] Automagic Error 429 & Macs

[Gavin Wynford-Jones]

> I believe that this problem MAY be due to a lack of
> system resources,

If it was, we'd get a common Mac error code. Error 429 is
internal to VBA. It's most likely to be a path problem.
Either you're trying to create a folder instead of a file, or
you've got a filename that includes a colon, which is a Mac no-no
as the colon is the path delimiter. It's the "can't create
object" that makes me think in this direction.

I tried to find the exact meaning of the error message/number
in various places, but MS seems to be quite reluctant to give
out information... I tried the help, the Mactopia site, the
VBA site, you name it!

Gavin

[Giuliano Menegazzi]

Wel, I'm a mac user, currently runnning OSX and to the best of my knowledge,
the problem here is very simple. ActiveX is Microsoft proprietary technology
and is wholly dependant on the Windows subsystems. NO ActiveX I know runs on
Mac or other system whatsoever and very possibly the trouble with the guy
runnning Win95 is that his ActiveX support is too old. Perhaps a visit ot
the windowsUpdate site would help.

My proposed solution for this would be Mike Mulka creating a new sheet on
the Automagic file where the final formatted orders would appear as text.
This way, Mac users would be able to cut'n'paste that and mail it manually
to auto@....

The last thing, you're absolutely right about the colon as the path
delimiter and that turn file path thingie definitely won't work on macs
because of that.

Giu.

On 12.05.2002 16:43, "Gavin Wynford-Jones" <gavinwj@...> wrote:

>> > I believe that this problem MAY be due to a lack of
>> > system resources,
>
> If it was, we'd get a common Mac error code. Error 429 is
> internal to VBA. It's most likely to be a path problem.
> Either you're trying to create a folder instead of a file, or
> you've got a filename that includes a colon, which is a Mac no-no
> as the colon is the path delimiter. It's the "can't create
> object" that makes me think in this direction.
>
> I tried to find the exact meaning of the error message/number
> in various places, but MS seems to be quite reluctant to give
> out information... I tried the help, the Mactopia site, the
> VBA site, you name it!
>
> Gavin
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
> <http://rd.yahoo.com/M=194081.2053425.3521449.1829184/D=egroupweb/S=1705334760
> :HM/A=1046314/R=1/*http://www.ediets.com/start.cfm?code=3225>
>
> <http://rd.yahoo.com/M=194081.2053425.3521449.1829184/D=egroupweb/S=1705334760
> :HM/A=1046314/R=2/*http://www.ediets.com/start.cfm?code=3225>
> Height: 4 5 6 7 ft 0 1 2 3 4 5 6 7 8 9 10 11 in
> Weight:
> Sex: F M
>
> Middle Earth PBM - hit reply to send to everyone
> To Unsubscribe: http://www.yahoogroups.com
> Website: http://www.MiddleEarthGames.com
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .



[Non-text portions of this message have been removed]

[Giuliano Menegazzi]

To all,

sorry about a bit too much of technical blabla on this mail but I'm also
posting this to the group in the hope some other mac user out there can add
anything to my ideas.

Mike,

Anwering your questions as best as I can:

1. What is the latest Mac O/S version?
>> That would be Mac OSX 10.1.x ? FreeBSD based system running
Apple's Aqua graphic interface

> 2. What is the latest version of the Mac O/S that you would consider
> obsolete, (with regards to Automagic in its current form)?
>>> >> Steve Jobs has formally announced the death of OS9, but you will still
>>> find a lot of people running OS8.5 ? OS9.2 . The MEPBM software itself was
>>> written to run under MacOS 7.6
>
> 3. What is the latest Mac processor (and/or speed) that you would
> consider obsolete?
>>> >> Current top of the line is the PowerPC G4 processor running from 500mhz
>>> to 1ghz. Imacs and most apple portables run on G3 processor running from 223
>>> ? 600 mhz. You can still find quite a few older PowerPC chipsets running
>>> around in Europe and America, but are definitely obsolete now.
>
> 4. What is considered minimal & optimal system memory for the Mac
> these days?
>>> >> If you run MacOSX you definitely need 128mb (graphics too heavy).
>>> Otherwise you get around pretty well with 64mb. (I run osx with 1gb ram -
>>> she's my beauty :)))
>
> 5. Do Mac and Windows versions of Excel share the same version number?
> (ie; Excel 97)
>>> >> They share more or less the same time-frame with a year's delay
>>> approximately. You will find Office 98, 2001 and X running around.
>>> Feature-wise they are pretty much the same ? Except for the activeX support
>>> which cannot be migrated to other platforms. Also Office for Mac uses Mac VB
>>> equivalent RealBasic (they are pretty much compatible.)
>
> 6. If you have had the error 429 problem in the past, were you ever
> able to get around it, and if so how?
>>> >> As I mentioned on an e-mail about a month ago, in my opinion there is no
>>> chance to get around this error as long as activex components are used.
>>> Activex depends on windows to work and unfortunately I do not know the mac
>>> command that would do something similar. I love macs but working with
>>> windows is what pays my rent :( I'm still getting familiar with OSX and the
>>> UNIX subsystem to be able to propose anything. Anyway, when I first got the
>>> error, I summoned the debugger and the VB gets lost when calling the activex
>>> component, because it just isn't there. I think the path for this solution
>>> lies on AppleScript, which is the MacOS scripting language. I'm no good at
>>> it though. Rounding it up, the status of automagic on macs is: all macros
>>> work fine, there is the path problem and the send mail problem, the last
>>> possibly solvable by calling AppleScript routines from the Excel sheet. As
>>> for the path one.. Paths have always been a very obscure thing in MacOS, now
>>> with the UNIX bit they have become more present, but it goes as Gavin
>>> mentioned, instead of the back-slash it uses colons and instead of a drive
>>> letter it uses the actual drive label (in my case a very creative "Hard
>>> Drive")
>
> 7. (and lastly...) Does any Mac user out there have any suggestions
or ideas about this problem?
>> My only idea would be to create another sheet on automagic
allowing for the final formatted orders to be viewed as text, which could
then be cut'n'pasted and manually e-mailed to MEGames. The other option is
finding a good AppleScripter :)

That's it.
Giu, from Brazil.

On 12.05.2002 15:26, "Urzahil" <Urzahil@...> wrote:

> Well, I'm still not sure what is causing some people to get the "Run-time
> error '429'
> activeX component can't create object" error when trying to send in orders.
> However,
> I've noticed that all but one of the people reporting this problem have been
> Mac
> users. (The one non-Mac user has a Win95 machine with 32MB of memory.)
> Unfortunately,
> I know NOTHING about Macs, so I can't even begin to diagnose possible causes.
>
> I believe that this problem MAY be due to a lack of system resources, but I
> really
> don't know. What I would like is for Mac users out there to give me a hand
> understanding the situation.
>
> 1. What is the latest Mac O/S version?
> 2. What is the latest version of the Mac O/S that you would consider
> obsolete, (with regards to Automagic in its current form)?
> 3. What is the latest Mac processor (and/or speed) that you would
> consider obsolete?
> 4. What is considered minimal & optimal system memory for the Mac
> these days?
> 5. Do Mac and Windows versions of Excel share the same version number?
> (ie; Excel 97)
> 6. If you have had the error 429 problem in the past, were you ever
> able to get around it, and if so how?
> 7. (and lastly...) Does any Mac user out there have any suggestions
> or ideas about this problem?
>
> Thanks,
> Mike Mulka
> http://orions.net/Middle-earth/index.htm
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
> <http://rd.yahoo.com/M=178320.2057063.3524709.1829184/D=egroupweb/S=1705334760
> :HM/A=979990/R=0/*http://www.fastweb.com/ib/yahoo-79f>
>
> Middle Earth PBM - hit reply to send to everyone
> To Unsubscribe: http://www.yahoogroups.com
> Website: http://www.MiddleEarthGames.com
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]