Downloading a File from the Web with VBA (XL 2000 SR1)

Topic

New Reply

Mark

I answered your post in the Excel lounge. BTW please be advised that its against rules, to double post.

Wassim

Reply | Quote

Replies

Thanks,

I did not know that I was not supposed to double post. I’ll know better next time.

Reply | Quote

Please post any responses to Duplicate post on Excel board

Hello,

I am currently assisting with the development of an Excel Workbook for my Firm that will be using worksheets that can be imported into the Workbook on Command. The Challenge is to keep the most current version of the worksheet available to the user.

My Idea is to post the worksheets to an Intranet Website for download. However, the users cannot be relied upon to check the website and download manualy, so I need to automate. I need to accomplish two objectives.

1) The worksheets will be downloaded and stored on the Users computer, So I need to compare the files on the hard drive to the ones on the website to make sure that they are in sync.

2) I need to automaticaly download the ones that are not in Sync to the directory where the sheets will be stored, overwriting the old version.

If anyone can offer assistance, it will be much appreciated.

Reply | Quote