*Good Explanation...... Thanks Asa....* On Wed, Jun 20, 2012 at 10:41 PM, Kiran Kancharla <srkira...@gmail.com>wrote:
> Hi Asa, > > This one is the ultimate and Excellence. > > > Thanks and Regards, > > Kiran > > On Thu, Jun 21, 2012 at 10:59 AM, NOORAIN ANSARI <noorain.ans...@gmail.com > > wrote: > >> Excellent ASA, >> >> Nice and very useful Explanation. >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> On Thu, Jun 21, 2012 at 9:27 AM, Asa Rossoff <a...@lovetour.info> wrote: >> >>> 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+&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_services/#_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/ - 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...**** >>> >>> ** ** >>> >>> 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**** >>> >>> >>> >>> **** >>> >>> ** ** >>> >>> -- **** >>> >>> 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 >>> >> >> >> >> >> >> >> -- >> -- 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 >> > > > > -- > 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 > -- * * * MARIES* Excel Inspiration <http://xcel-inspiration.blogspot.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
