Using ftp address in a macro

Tutorials Win: Microsoft Windows Forum

Hi All,

We are currently trying to do a document comparison by comparing the
active document with a file on an FTP site. When doing manually,
everything works great, but when when I record the action, and attempt
to use the macro, we get Run-time error '5273'. The macro takes the
following form:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 12/2/2003 by NormanJD
'
ActiveDocument.Compare Name:="ftp://1.2.3.4/Compare/test.doc"
End Sub

(IP address changed to protect the guilty)

I have tried variations such as
"ftp://username:password@1.2.3.4/Compare/text.doc" and have added the
FTP site along with username and password to the "Save as" list and in
"My Network Places" I am testing this in an environment with no
firewalls or proxies, (will add those later) but anonymous logins are
disallowed. My workstations will either be running Windows 2000 or
Windows XP with Office 2000 and all latest patches for both the O/S
and Office. I've played like crazy with IE settings, but don't think
this will help as it does wotk when I do everything manually, only the
macro fails...

Has anyone tried this or have a solution? Is this a VB/macro bug?

John Norman
Top

Using ftp address in a macro by losmac

losmac
Tue Dec 02 17:51:26 CST 2003


I thing, the only way is to get file from ftp to local
drive (template folder) and then compare the files.

>-----Original Message-----
>Hi All,
>
>We are currently trying to do a document comparison by
comparing the
>active document with a file on an FTP site. When doing
manually,
>everything works great, but when when I record the
action, and attempt
>to use the macro, we get Run-time error '5273'. The
macro takes the
>following form:
>
>Sub Macro1()
>'
>' Macro1 Macro
>' Macro recorded 12/2/2003 by NormanJD
>'
> ActiveDocument.Compare
Name:="ftp://1.2.3.4/Compare/test.doc"
>End Sub
>
>(IP address changed to protect the guilty)
>
>I have tried variations such as
>"ftp://username:password@1.2.3.4/Compare/text.doc" and
have added the
>FTP site along with username and password to the "Save
as" list and in
>"My Network Places" I am testing this in an environment
with no
>firewalls or proxies, (will add those later) but
anonymous logins are
>disallowed. My workstations will either be running
Windows 2000 or
>Windows XP with Office 2000 and all latest patches for
both the O/S
>and Office. I've played like crazy with IE settings, but
don't think
>this will help as it does wotk when I do everything
manually, only the
>macro fails...
>
>Has anyone tried this or have a solution? Is this a
VB/macro bug?
>
>John Norman
>.
>
Top

Re: Using ftp address in a macro by Philip

Philip
Tue Dec 02 19:10:25 CST 2003

You can take the FTP connection out of the equation by using webdrive
(www.webdrive.com) which maps an FTP server as a mounted drive. Then you
can use any software on your PC as if the file was local. Perfectly
marvellous. I use it for uploading websites using the industrial-strength
utility Robocopy (resource kits).

--
######################
## PH, London ##
######################


John Norman wrote:
> Hi All,
>
> We are currently trying to do a document comparison by comparing the
> active document with a file on an FTP site. When doing manually,
> everything works great, but when when I record the action, and attempt
> to use the macro, we get Run-time error '5273'. The macro takes the
> following form:
>
> Sub Macro1()
> '
> ' Macro1 Macro
> ' Macro recorded 12/2/2003 by NormanJD
> '
> ActiveDocument.Compare Name:="ftp://1.2.3.4/Compare/test.doc"
> End Sub
>
> (IP address changed to protect the guilty)
>
> I have tried variations such as
> "ftp://username:password@1.2.3.4/Compare/text.doc" and have added the
> FTP site along with username and password to the "Save as" list and in
> "My Network Places" I am testing this in an environment with no
> firewalls or proxies, (will add those later) but anonymous logins are
> disallowed. My workstations will either be running Windows 2000 or
> Windows XP with Office 2000 and all latest patches for both the O/S
> and Office. I've played like crazy with IE settings, but don't think
> this will help as it does wotk when I do everything manually, only the
> macro fails...
>
> Has anyone tried this or have a solution? Is this a VB/macro bug?
>
> John Norman


Top

Using ftp address in a macro by anonymous

anonymous
Wed Dec 03 11:09:38 CST 2003

Trying to get the file from FTP using VBA could be tough,
an easy workaround I heard from a guy on this forum was to
write a quick batch file using ftp commands and the VBA
can Shell "yourBatchFile" to get the file to your local
drive, then do what you will with it.

>-----Original Message-----
>Hi All,
>
>We are currently trying to do a document comparison by
comparing the
>active document with a file on an FTP site. When doing
manually,
>everything works great, but when when I record the
action, and attempt
>to use the macro, we get Run-time error '5273'. The
macro takes the
>following form:
>
>Sub Macro1()
>'
>' Macro1 Macro
>' Macro recorded 12/2/2003 by NormanJD
>'
> ActiveDocument.Compare
Name:="ftp://1.2.3.4/Compare/test.doc"
>End Sub
>
>(IP address changed to protect the guilty)
>
>I have tried variations such as
>"ftp://username:password@1.2.3.4/Compare/text.doc" and
have added the
>FTP site along with username and password to the "Save
as" list and in
>"My Network Places" I am testing this in an environment
with no
>firewalls or proxies, (will add those later) but
anonymous logins are
>disallowed. My workstations will either be running
Windows 2000 or
>Windows XP with Office 2000 and all latest patches for
both the O/S
>and Office. I've played like crazy with IE settings, but
don't think
>this will help as it does wotk when I do everything
manually, only the
>macro fails...
>
>Has anyone tried this or have a solution? Is this a
VB/macro bug?
>
>John Norman
>.
>
Top