Thank You, but Yes I have tried this but I want to automate it wiith some VBA code, eliminating the need to remember where the file transfer definitions reside.
I have a file on the AS400 that I would like to automatically download into my open workbook. Can this be done via a VBA macro? I have client access (v5.5) and Excel 2000 running on an XP client.
I can use the tool bar, but this is too time consuming, I would like to be able to hand this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.