Reflections X 12.0 FTP Automation & Extraction

[elmarko123]

Hi Guys,

Just wanted to find out if we have anybody familiar with using "Reflections X 12.0 FTP Client" via Excel.

I've checked my references and it seems i have "Reflection FTP 1.0 Type Library" currently active & the DLL location is refereing to the where i have that version installed.

The problem is im unsure as to find out what the exact name of the FTP client object is.

"Set MySession = CreateObject("reflectionsftp.Session")" does not work, the only thing i can find online is ("Reflection4.Session") but thats a different interface to what im currently trying to automate.

Basically i want a macro that can log into reflections FTP client, then download a specified file to a specific location.

I already know the code to do all of the parts after that, but im unfamiliar with linking reflections and XL

Thanks in advance.

Mark

[elmarko123]

no luck with finding a result or solution?

[pcd]

Set ftp = CreateObject("Reflection.FTP")
or
Set ftp = CreateObject("Reflection.FTP.3")