Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

FTP from Word VBA

2 views
Skip to first unread message

Brian

unread,
Apr 1, 2005, 7:16:34 PM4/1/05
to
I want to use VBA to access an FTP site to see if the contents have changed.
If a new subdirectory exists, I want to download the contents of the new
folder. I have reviewed some of the MSDN site's documentation and found
some sample scripts via Google, but I can't even seem to get the initial
Inet object set. I have added a reference to Microsoft Internet Controls.
Could someone please post a simple script example that will open an FTP
connection to a site?

-Brian


Abhishek

unread,
Apr 4, 2005, 3:47:09 AM4/4/05
to
The reference should be put to "Microsoft Internet Transfer Control 6.0" and
not "Microsoft Internet Controls".

These are two different controls. "Microsoft Internet Transfer Control 6.0"
is an ActiveX control and wont be

visible while putting usual references. To set the reference, open a form in
design mode and go to Insert menu.

Select ActiveX control. Then browse through the list to find "Microsoft
Internet Transfer Control 6.0". This would

set the reference to the dll. You can then start using the Inet Object.

"Brian" <bpollak@_no_spam_hotmail.com> wrote in message
news:Ojz89kxN...@tk2msftngp13.phx.gbl...

0 new messages