Question about XL/Office userform & Office 2004

[Tushar Mehta]

Hi:
Someone is trying to use one of my add-ins, Directory List
(http://www.tushar-mehta.com/excel/software/dirlist/index.html) with
Office 2004. He claims it worked just perfectly with his previous Mac
but doesn't with his new mac, which I understand is running OS X (is
that the same as Tiger?)

He states that as soon as he clicks on the 'TM' submenu (he hasn't even
selected the actual menu item) he gets an error message about "Compile
error in hidden module Userform1."

Since my add-in has no userform named Userform1 I am at a loss as to
what the problem is. Note that the add-in does have multiple
userforms, just not any named Userform1.

Maybe, a more fundamental question is in order. Should the add-in have
worked on his older machine? I was under the impression that Mac
Office did not support the (Wintel) Office userforms since they use
ActiveX controls. Am I mistaken?


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[JE McGimpsey]

Someone is trying to use one of my add-ins, Directory List
(http://www.tushar-mehta.com/excel/software/dirlist/index.html) with
Office 2004. He claims it worked just perfectly with his previous Mac
but doesn't with his new mac, which I understand is running OS X (is
that the same as Tiger?)

Hi Tushar!

OS X is the general name for the OS, much as Windows is. Apple branded
it, so major updates use the dot system - e.g., "Panther" was OS X 10.3
and "Tiger" is OS X 10.4, but the differences between them are generally
bigger than you'd expect to see in a .x revision.

He states that as soon as he clicks on the 'TM' submenu (he hasn't even
selected the actual menu item) he gets an error message about "Compile
error in hidden module Userform1."

Since my add-in has no userform named Userform1 I am at a loss as to
what the problem is. Note that the add-in does have multiple
userforms, just not any named Userform1.

When I load the add-in in XL04, I get a missing library warning, then a
"can't find macro x" when I select a menu option. I haven't tried XLv.X
yet, but I'll give that a look later today.

The compiler's balking at lines like

Private Sub HandleFiles(thisFolder As Folder, OutputCell As Range,
NbrLeadingSpaces As Integer)

and

setOneAttr f.Attributes And Alias, Rslt, "Alias"

with a "Can't find Project or Library" error.

Maybe, a more fundamental question is in order. Should the add-in have
worked on his older machine? I was under the impression that Mac
Office did not support the (Wintel) Office userforms since they use
ActiveX controls. Am I mistaken?

Office userforms are implemented in MacOffice with standard controls
(Textboxes, ListBoxes, Comboboxes, Buttons, Spinners, etc.). ActiveX
isn't implemented, so you can't add activeX controls to userforms.

Because it's a kluged system, it's got a fair number of bugs.

 

[Tushar Mehta]

Hi JE,

Thanks for the quick reply. Glad to get the version explanation.

Also, thanks for the tests. More than I'd expected. {grin}

The errors you flagged are references to the FileSystemObject COM
(ActiveX?) control on a Windows system: Folder is a class of the FSO
component and f is an object of type File.

I suspect the person using the software used a *much* older version of
the add-in on his old machine. I vaguely recall the old, old, old
version used the VBA DIR() function rather than the FSO. Though, even
that would have had a RefEdit control in the userform. Or, maybe, it
used a dialogsheet for a user interface. I should have him send the
add-in he has back to mama. I am really curious as to what he has that
works -- unintentionally -- on a Mac.

BTW, I almost bought a Mac Mini (the $700 souped up with addl. memory
to $800) late Dec. Would have been my first Mac since 1994. But, with
the 32MB video driver as a catalyst, I figured Apple hadn't announced
anything new in a while...so, something had to happen soon...

As I'm sure you know Apple announced a $1300 iMac based on an Intel
dual core chip I haven't heard of before called Core Duo. Wonder if it
is the same as what the Wintel vendors call Pentium D? If it is, it
might open up a whole new world if the new Mac OS installs on my Wintel
m/c, essentially creating a Mactel hybrid.

The one thing I seriously dislike about this "all in one" design is
that when I want to upgrade, I'm also forced to discard the monitor.
Oh, well. Cannot have everything, I suppose. ;-)

Once again, thanks for your help.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jim Gordon MVP]

Hi Tushar...

Hi JE,

Thanks for the quick reply. Glad to get the version explanation.

John is fast!

Also, thanks for the tests. More than I'd expected. {grin}

The errors you flagged are references to the FileSystemObject COM
(ActiveX?) control on a Windows system: Folder is a class of the FSO
component and f is an object of type File.

I suspect the person using the software used a *much* older version of
the add-in on his old machine. I vaguely recall the old, old, old
version used the VBA DIR() function rather than the FSO. Though, even
that would have had a RefEdit control in the userform. Or, maybe, it
used a dialogsheet for a user interface. I should have him send the
add-in he has back to mama. I am really curious as to what he has that
works -- unintentionally -- on a Mac.

Everything you say fits. DIR() kinda works on Macs. Dialogsheets are
still supported. There's no Active-X. That open source project still
has not been ported to the Mac.

BTW, I almost bought a Mac Mini (the $700 souped up with addl. memory
to $800) late Dec. Would have been my first Mac since 1994. But, with
the 32MB video driver as a catalyst, I figured Apple hadn't announced
anything new in a while...so, something had to happen soon...

As I'm sure you know Apple announced a $1300 iMac based on an Intel
dual core chip I haven't heard of before called Core Duo. Wonder if it
is the same as what the Wintel vendors call Pentium D? If it is, it
might open up a whole new world if the new Mac OS installs on my Wintel
m/c, essentially creating a Mactel hybrid.

A program of some sort would need to moderate which OS could talk to the
hardware at any given moment. Virtual PC folks have a lot of experience
in that sort of thing. Since Virtual PC is part of Mac Office
Professional and all of Virtual PC is controlled by Microsoft's Mac
business unit chances are pretty good that sooner or later you'll be
able to run both Mac and Windows on the same intel based box.

The one thing I seriously dislike about this "all in one" design is
that when I want to upgrade, I'm also forced to discard the monitor.
Oh, well. Cannot have everything, I suppose. ;-)

The mini (like all Macs) will be changed to Intel processors before the
end of 2006.

-Jim Gordon
Mac MVP
from MacWorld

 

[Tushar Mehta]

Hi Jim,

Thanks for your comments.

I asked the guy to check if he can install the old copy of the add-in
on his new Mac and also to send it to me. We'll see what happens.

Personally, I think Jobs will fight tooth and nail to block running a
Mac OS on a Wintel compatible platform. That would run the risk of
people buying cheap hardware and sticking the Mac OS on it.
Personally, I would love a dual-boot Wintel/Mactel computer. But, we
will see.

Yeah, I've resisted buying a Mac Mini for a bit now. The urge to plonk
down $800+ gets stronger each time I see the copy of Mac Office Pro on
the shelf in my office. {grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Paul Berkowitz]

As I'm sure you know Apple announced a $1300 iMac based on an Intel
dual core chip I haven't heard of before called Core Duo. Wonder if it
is the same as what the Wintel vendors call Pentium D?

No, it's not a Pentium in any shape or form. It's a brand new, better,
faster chip family. It's also due out in new Dells, HPs, etc., but those
have been kept waiting - Apple got it first. (To be fair, I think it's
expected mostly in laptops, and the new MacBooks with these chips also have
to wait until sometime in February.)

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[Tushar Mehta]

No, it's not a Pentium in any shape or form. It's a brand new, better,
faster chip family. It's also due out in new Dells, HPs, etc., but those
have been kept waiting - Apple got it first. (To be fair, I think it's
expected mostly in laptops, and the new MacBooks with these chips also have
to wait until sometime in February.)

Ummm...a dual core laptop. Now, that would be cool. And, hot! Yep,
that's from experience. {grin} I often use a laptop while it rests on
my thighs.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Paul Berkowitz]

Ummm...a dual core laptop. Now, that would be cool. And, hot! Yep,
that's from experience. {grin} I often use a laptop while it rests on
my thighs.

No, not hot - cool. At least that's what we're told - they're not out until
next month. The whole reason (or almost the whole reason) why Apple has
switched to Intel is because Freescale (Motorola) and IBM could not develop
a feasible version of the PowerPC G5 chip that would work in a laptop -
always too hot and too weak. These new 65 nm Intel Core Duo chips are
supposed to be both fast and cool. We'll see next month when the MacBooks
are released.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.