Re: Using API with VBA in Excel

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 02/28/04


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/
>


Relevant Pages

  • Re: Emailing web form information to me
    ... To deal with your comments on Vista, it is the mapping via 'my computer' ... or indeed the other bug that causes Publisher to ... have a default folder such as "public_html" that you are supposed to upload ... In the Map Network Drive dialog box, ...
    (microsoft.public.publisher.webdesign)
  • Re: Imagining/Cloning Desktops
    ... Via Network you'll have 2 requirements. ... has an account that has full permissions on it. ... local user account on the ghost storage pc and give it full access only ... source files set and the network drivers copied into the folder burn ...
    (microsoft.public.windowsxp.setup_deployment)
  • Re: Printer Security tab
    ... Try to Map the shared folder, if it won't then we need much more info on the setup, components and protocols? ... Right click "My Network Places" on the desktop or click "Tools" on the Menu bar in Explorer or MyComputer. ... > firewalls in both computers. ... turn on the XPSP2 Windows Firewall. ...
    (microsoft.public.windowsxp.general)
  • Re: Publishing Web Page For First Time
    ... by clicking on the folder, designate where the file is saved. ... Computer, My Network Places. ... New Pop Up Window appears - Add Network Location ... Specify the location of your network window pops up ...
    (microsoft.public.publisher.webdesign)
  • Re: filename is too long or contains illegal caracters
    ... When I ADD NETWORK LOCATION, I get "folder ... When I PUBLISH TO WEB (withing PUBLISHER) I get ... Per you suggestion, I tried to Add a Network Location in "Computer", ... The only difference is Vista. ...
    (microsoft.public.publisher.webdesign)