Search:

Type: Posts; User: Sharid; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: A little help need on adding values in column

    My answer is this - Thanks you for your code it worked super, and thanks to everyone else for helping out
  2. Re: A little help need on adding values in column

    Anglais428 you code worked, The only problem is I have to select the CELL as active cell, which is not what I wanted to do, If no one else can help then I will have to go with your code,
  3. Re: A little help need on adding values in column

    It only contains the value,

    Column A has the item name e.g. Tshirt Column B has the Amount
  4. Re: A little help need on adding values in column

    Instead of giving the total value it give me £00.00
  5. Re: A little help need on adding values in column

    I get £80.50
  6. Re: A little help need on adding values in column

    Forgot to mention that bit. Lol

    it just returns £00.00

    So if column B Row 4 and below had

    Tshirt = £10.50
    Shoes = £30.00
    Jacket = 40.00
  7. A little help need on adding values in column

    Why is this not working

    I want to add all the values in column B from row 4 down to last cell with data and the past the TOTAL in Cell B2



    Private Sub CommandButton1_Click()
    Dim myRange ...
  8. Replies
    1
    Views
    118

    Help update this Google search code

    Hi

    For the first part my code works fine, it does what it is meant to do.

    1) I place a search item in Sheet2 Cell A1 e.g. "Laptops" and it opens Google and extracts all the url for laptops...
  9. Replies
    6
    Views
    538

    Re: Ebay vba url issue

    Its only product details and NOT customer details like emails, just looking at what is selling and for how much, so I can work out my prices. Its also not a large search 5 pages.
    The data can be...
  10. Replies
    2
    Views
    424

    Re: GET All urls that have a specified keyword

    yky

    Thanks for this code, it a step in the right direction. I'm not sure if it me doing something wrong or that is just the way the code works.

    What I was after was that when the code is run it...
  11. Replies
    6
    Views
    538

    Re: Ebay vba url issue

    I got the code sorted to accept the key search word from the sheet, the problem was this bit of code

    cssSelectors = Array(".gvtitle a", ".amt", ".gvtitle a")
    It work fine with 1 url in the code,...
  12. Replies
    6
    Views
    538

    Re: Ebay vba url issue

    Joe4

    Thanks for the reply.

    Your code came up with page not found on ebay, I had to add the bit in blue to get it to pull up the page. However it is the same problem and is not extracting ANY...
  13. Replies
    6
    Views
    538

    Ebay vba url issue

    I have a vba code that extracts ebay product details the code works fine if i am using a direct url in the code

    Original Code for search, but only searches 1 item

    .Navigate2...
  14. Replies
    2
    Views
    424

    GET All urls that have a specified keyword

    Hi

    Is there a way of getting certain pages urls from a website using vba.

    My following code gets all the urls from a web site page. I enter the domain in L1 and whatever that domain is, it...
  15. Re: Ebay Product Scraping code issue, works on .com not .co.uk

    Sorry ignore most of the above thread, I kind of worked it out, still has a bug. by the time i had finished changing the above post I ran out of time and it would not let me change it.

    if the url...
  16. Re: Ebay Product Scraping code issue, works on .com not .co.uk

    Could someone please help.

    This code is now working on both .com and .co.uk NOW, if I don't include the code in orange. I added the orange code so it would allow the search criteria to come from...
  17. Re: Issue with a line of code - "Object doesn't support this property or method"

    Domenic

    This is absolutely awesome, there was no way I was going to get this far without your kind help.

    A very big Thank you,

    You are a god amongst us mortals
    <!--[if gte...
  18. Re: Issue with a line of code - "Object doesn't support this property or method"

    I looking for something like this, but I can't get this to work

    https://www.automateexcel.com/vba/search-google-in-excel-cell/
  19. Re: Issue with a line of code - "Object doesn't support this property or method"

    Hi Domenic

    Your code is super, way better than what I was doing. The full code is below incase anybody else needs it,

    Just one more thing, as you know this bit of the code tells google where to...
  20. Re: Ebay Product Scraping code issue, works on .com not .co.uk

    I still can not work this one out, if anyone could please take a look, I would be very happy. I works fine with .com but not with .co.uk

    I'm not sure why
  21. Ebay Product Scraping code issue, works on .com not .co.uk

    Hi

    I am hoping someone can explain why my code is not running when I change it to ebay.co.uk

    The code runs in two parts,

    1) It opens IE - Ebay
    2) It places the products Title, Price and...
  22. Re: Issue with a line of code - "Object doesn't support this property or method"

    Thanks this is a lot better, it has pulled up a few duplicate urls AS SHOWN BELOW. I will need to look into this


    https://www.ablebits.com/office-addins-blog/2013/12/06/add-run-vba-macro-excel/...
  23. Replies
    0
    Views
    206

    Cleaning up data from web in a cell

    Please could someone help. I have been doing this by hand, I'm hoping a vba code can do this

    I am pulling data from the web into a spreedsheet, I need a VBA code that will clean the data so it is...
  24. Re: Issue with a line of code - "Object doesn't support this property or method"

    It does and does not help

    It pulls up the class "LC20lb" but NOT the urls, this is the code now



    Sub webpage()

    Dim internet As Object
    Dim internetdata As Object
  25. Re: Issue with a line of code - "Object doesn't support this property or method"

    Hi Domenic

    I change the line but I I'm now getting a Run time error "1004" Application defined or object defined error
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4