Re: Using API with VBA in Excel
From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 02/28/04
- Next message: Jack Clifford: "VBA Pivot Table Question"
- Previous message: Bob Phillips: "Re: Right & Split question"
- In reply to: rahela: "Re: Using API with VBA in Excel"
- Next in thread: Martyn: "Re: Using API with VBA in Excel"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 28 Feb 2004 18:16:12 -0000
Rahela,
You don't need a library as the code uses late binding (specifically to
avoid such problems).
It should work on a network as I included a Folder browser, and as long as
you have mapped drives to the network server(s), so you pick your folder to
list.
Use Frank's last amendment.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"rahela >" <<rahela.12clnt@excelforum-nospam.com> wrote in message
news:rahela.12clnt@excelforum-nospam.com...
> Frank Kabel wrote:
> > *
> > > Absolutely not Frank, it is not only helpful, you might do
> > something
> > > I would not have thought of, so all benefit. It's a co-operative
> > > here, part of it's richness, and I am not averse to adding my bit
> > to
> > > other's postings. I was unavailable for the past 2 hours anyway,
> > had
> > > to make some flapjacks
> >
> > Sound delicious. So you semm to enjoy your weekend :-)
> > Frank *
>
> Hi Dear fellows,
> Do I need to choose some library in the vbe, before I could use that
> programe? what I have forgot to mention is that I use
> a local net. Would the programe above will be good for a net too?
> From the discussion above, and the corrections, which
> is the last best version (I am not an expert, and quite frankly
> I got lost along the lines........) to use?
> Thanks a zilion
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
- Next message: Jack Clifford: "VBA Pivot Table Question"
- Previous message: Bob Phillips: "Re: Right & Split question"
- In reply to: rahela: "Re: Using API with VBA in Excel"
- Next in thread: Martyn: "Re: Using API with VBA in Excel"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|