By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

How to download file from Internet through click of Access

P: 9
Hi,

I want to download one file in the folder of Hard disk. I want to do this through just one click of Access Button.

Can any of you help me out??

Thanks,
Bhavin
Aug 16 '07 #1
Share this Question
Share on Google+
4 Replies


FishVal
Expert 2.5K+
P: 2,653
Hi,

I want to download one file in the folder of Hard disk. I want to do this through just one click of Access Button.

Can any of you help me out??

Thanks,
Bhavin
Hi, Bhavin.

Take a look at this thread.
using VBA to copy xls file from online source

Or if you have download link you may try FollowHyperlink function
e.g.
Expand|Select|Wrap|Line Numbers
  1. FollowHyperlink "http://download.adobe.com/pub/adobe/cmm/win/1.x/AdobeCMMAll.zip"
  2.  
Aug 20 '07 #2

P: 9
Hi,

Thanks for your valuable reply. I just wanted to know that is it possible in Access to unzip the ZIP file(from HD) in a specific folder of HD with one click???? Will you plz send me Code??

Thanks,
Bhavin






Hi, Bhavin.

Take a look at this thread.
using VBA to copy xls file from online source

Or if you have download link you may try FollowHyperlink function
e.g.
Expand|Select|Wrap|Line Numbers
  1. FollowHyperlink "http://download.adobe.com/pub/adobe/cmm/win/1.x/AdobeCMMAll.zip"
  2.  
Aug 21 '07 #3

Jim Doherty
Expert 100+
P: 897
Hi,

Thanks for your valuable reply. I just wanted to know that is it possible in Access to unzip the ZIP file(from HD) in a specific folder of HD with one click???? Will you plz send me Code??

Thanks,
Bhavin
Yes it is possible at module level! look at the API function apiShellExecute which can take an executable file name such as there are free unzipping utility tools downloadable off the net which by simply tagging a filepath on the end to make an executable command line and using proprietary relevant switches. Can be all done in VBA using API calls which ultimately can be reduced to a button click.... but needs programming i.e. defining and ensuring drive and folder paths testing for same etc etc etc

Jim
Aug 23 '07 #4

P: 9
Thanks, JIM

I will try my level best to achieve the target.

Bhavin


Yes it is possible at module level! look at the API function apiShellExecute which can take an executable file name such as there are free unzipping utility tools downloadable off the net which by simply tagging a filepath on the end to make an executable command line and using proprietary relevant switches. Can be all done in VBA using API calls which ultimately can be reduced to a button click.... but needs programming i.e. defining and ensuring drive and folder paths testing for same etc etc etc

Jim
Aug 27 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.