VBA - dual platform help

John Nurick(jnurick[at]lrconsulting.co.uk)
Thu, 22 Apr 1999 06:53:23 -0500

WinMac Digest #291 - Thursday, April 22, 1999

  Re: DAVE
          by "Alex Dearden" <pata@tampabay.rr.com>
  Re: finding IP addresses
          by "Alex Dearden" <pata@tampabay.rr.com>
  Re: NT weird behaviour
          by "Alex Dearden" <pata@tampabay.rr.com>
  VBA - dual platform help
          by "John Nurick" <jnurick@lrconsulting.co.uk>

Subject: Re: DAVE
From: Alex Dearden <pata@tampabay.rr.com>
Date: Wed, 21 Apr 1999 20:10:38 -0500
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

> I ended up using a Hosts file like the following and Dave
>started to work perfectly for me:
>
>ED1 CNAME ed1.sched.pitt.edu
>ed1.sched.pitt.edu A 136.142.66.171
>ED3 CNAME ed3.sched.pitt.edu
>ed3.sched.pitt.edu A 136.142.68.102
>
> If you have a WINS Server it also works perfectly.

You know, I never thought of doing that!!! How stupid! I have had some
problems with Dave and our WINS server (even though it was configured to
use the WINS server it didn't seem to find the Netbios names out there).

The problem I have now is that I had to enter the names by hand in DAVE,
and when I try to connect to any PC it gives me an access denied or wrong
password error. I solved it by running DAVE Access, entering my password
there, quitting Dave access, then everything is cool. Very weird.
Although I haven't read the manual to see if I'm doing anything
wrong...???

Alex Dearden
MCSE
pata@doglover.com

Subject: Re: finding IP addresses
From: Alex Dearden <pata@tampabay.rr.com>
Date: Wed, 21 Apr 1999 20:10:42 -0500
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

> The never available outsourced person refuses
>to tell me the IP address since he thinks that I don't need the info.
>Since they aren't using the DHCP (dynamic ???? something or other) but
>TCP/IP, I need the IP address to enter into the TCP/IP control panel to
>connect via Dave. What is so secret about the IP address I'll never know

If you know the Netbios (PC) name of the computers (whatever they show up
as in network neighborhood) you can find their IP addresses from another
PC. Go to a DOS prompt and type "NBTSAT ?" (or NBTSTAT help, or something
similar, I forget exactly which, in fact, if you type "NBTSTAT" alone
you'll get the help file). There is a flag to get the IP address of a
client providing the netbios name (-N or something, I don't have a PC
handy just now). Yo do it the other way around (the netbios name
providing the IP address, use NBTSTAT -A <netbios name>).

Very handy. I know it works in NT, and I'm pretty sure it does in 95/98
as well.

good luck

Alex Dearden
MCSE
pata@doglover.com

Subject: Re: NT weird behaviour
From: Alex Dearden <pata@tampabay.rr.com>
Date: Wed, 21 Apr 1999 20:10:44 -0500
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

> This behavior has to do with the unloading of certain NT Services in
>preparing for shutdown, i.e. each Service shuts down *gracefully* and then
>the machine goes down. What is happening is that one of the Services that
>unloads BEFORE Services For Macintosh (SFM) is hanging.

Good advice. Our Chief Technologist told me there was a utility for NT
that emulates the Unix/Linux KILL function. I know NT has the task
manager, but it doesn't really show all the services and processes. I'll
try to find out what it is and give it a try, it might help you figure
out what's going on.

Alex Dearden
MCSE
pata@doglover.com

Subject: VBA - dual platform help
From: John Nurick <jnurick@lrconsulting.co.uk>
Date: Thu, 22 Apr 1999 06:53:23 -0500
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

I need to add a help system to some Word and Excel templates and macros.

I know how to write and compile a Windows .hlp file to get context
sensitive help for forms and controls in Office 97.

That takes care of the large majority of my users. But what about the
Mac minority? Any suggestions (for instance, if I write for HTML Help,
can Office 98 handle that)? I've tried unsuccessfully to find info about
this on the MS knowledgebase.

TIA

John

* Windows-MacOS Cooperation List *

This archive was generated by hypermail 2.0b2 on Thu Apr 22 1999 - 17:05:54 PDT