Hi Kiran, I can help you off-list to meet your need exactly, for a reasonable fee. But first I will offer you some free advice and hints:
1. The product search results in a URL like "http://www.jabong.com/catalog/?q=WR138MA56HVN+ <http://www.jabong.com/catalog/?q=WR138MA56HVN+&submit=&baseUrl=> &submit=&baseUrl=" and seems to work fine with even "http://www.jabong.com/catalog/?q=WR138MA56HVN";. 2. In the description of your requirement, you say "navigating the website". I assume you mean prompting the user for their search term. If you mean something else, a more detailed description is needed. 3. Then you say "Select photos.". I assume you mean download all the photos from the search. In some cases., there might be multiple pages of search results (I have not investigate that yet) so that would need to be considered in your macro. But perhaps you mean the photos should all be shown to the user and they choose specific pictures they want to retain. Can you clarify? 4. Then you say ". and download the photos in the specified location". I assume you mean to prompt the user for a file folder where the pictures should be saved, and then save all of the relevant pictures there. Can you clarify? 5. If my assumptions are correct, you can probably use a command-line utility to perform the downloads after prompting the user for their search term and download location. a. Perhaps the "classic" such utility is WGET. It's an open source program, and you can get the latest full-featured Windows version from http://users.ugent.be/~bpuype/cgi-bin/fetch.pl?dl=wget/wget.exe. i. Type wget --help at the command line for basic instructions. Quick overview of simple usage at http://users.ugent.be/~bpuype/wget/. ii. Frequently Asked Questions (and answers) at http://wget.addictivecode.org/FrequentlyAskedQuestions. iii. Full online manual at https://www.gnu.org/software/wget/manual/wget.html iv. A ZIP archive with the offline manual in various formats can be downloaded from http://downloads.sourceforge.net/gnuwin32/wget-1.11.4-1-doc.zip. Look for the CHM help file for easy perusal. b. More advanced (and perhaps more complicated) is the utility called cURL. Also open source. http://curl.haxx.se/ 6. For your own downloader implementation written fully in VBA that does not call out to a command-line utility, there are a few Windows APIs or automation objects that can be used, including as discussed below: a. A detailed article on both downloading and parsing web pages and files in VBA, by Tushar Mehta, can be found at http://www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_service s/#_Toc173749359. Tushar uses XMLHTTP and InternetExplorer automation classes in the article, gives sample code, and discusses a number of issues. b. ADO's (ActiveX Data Objects') Stream class can download internet URLs. See http://msdn.microsoft.com/en-us/library/ms675032%28v=vs.85%29, http://msdn.microsoft.com/en-us/library/ms675955%28v=vs.85%29.aspx, http://msdn.microsoft.com/en-us/library/ms680846%28v=vs.85%29, http://msdn.microsoft.com/en-us/library/ms676745%28v=vs.85%29 and associated MSDN documentation. c. Samples using the WinInet API are detailed at http://www.lazerwire.com/2011/11/excel-vba-download-files-from-internet.html . d. An automation example using the XMLHTTP class is provided at http://blog.invisibledenizen.org/2008/11/vba-function-to-download-files.html . e. An automation example using WinHttpRequest is available from Microsoft at http://msdn.microsoft.com/en-us/library/aa384072%28VS.85%29.aspx (Some of the instructions relate to the Visual Basic IDE, but are not critical. The essence of the article applies to VBA.) f. Automation examples using XMLHTTP as well as WinHttpRequest are available from http://www.motobit.com/tips/detpg_read-write-binary-files/ (see section 3). g. There are InternetExplorer and WebBrowser automation controls. h. There is URLMon, part of the Internet Explorer API. It has functions such as URLDownloadToFile (download a URL to disk) and URLOpenPullstream or URLOpenBlockingStream which are approriate for downloading files and returning the data direcly to your VBA code to parse or handle as it desires without having to save it to disk first. All these methods would probably require: i. Download the HTML page with the search results. ii. Parse the HTML file and find the URLs for all the images. iii. Download the images and save to disk. If you want to hire me, send me an email off list. If you want to try it on your own, see if these tips help you. Come back with any questions that come up, and the group will try to help. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancharla Sent: Wednesday, June 20, 2012 11:06 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Saving Photos from webpage Hi All, Is any one interested, if I am ready to pay for this task. Please help to create a Macro to save images folder. Below are the requirement: Step 1: Navigating the website : <http://www.jabong.com/> http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified location. - Macro Require I have created macro to navigate the web page and I need help to save the all photos in folder. Please help me as i have a huge data to download. I have tried in google, unfortunately I am getting all the macro's to download only 1 photo, in my current need I have to download all the photos. I can use any type of explorer ie, chrome, firefox or any. Note : The website ( <http://www.jabong.com/> http://www.jabong.com/)is only for example purpose. Thanks in advance... If any one interested, please revert back to me.. Thanks & Regards, Kiran On Sun, Jun 17, 2012 at 2:55 PM, Kiran Kancharla <srkira...@gmail.com> wrote: Hi All, Request you to please help to create a Macro to save images folder. Below are the requirement: Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified location. - Macro Require I have created macro to navigate the web page and I need help to save the all photos in folder. Please help me as i have a huge data to download. I have tried in google, unfortunately I am getting all the macro's to download only 1 photo, in my current need I have to download all the photos. I can use any type of explorer ie, chrome, firefox or any. Note : The website (http://www.jabong.com/)is only for example purpose. Thanks in advance... -- Thanks & Regards, Kiran -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> -- Thanks & Regards, Kiran 9920456606 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
