wend

  1. J

    While Wend Statement

    Hi, Can one use AND in a while wend statement: When I use this statement, it does not read the AND statement, so even though there is data in my last column it exits the loops. Not too sure what I am doing wrong, or if I should not be using While and AND in the same statement. Any advice...
  2. E

    HTML Macro to print documents

    Hello everyone! So I've come up with the idea of trying to create a macro that allows me to open a few PDF documents from a intranet website here in the company I'm currently working in. The code below is what I have so far, and it's working perfectly but, I need to sort the table by one of the...
  3. steveuk87

    IE browsing and user field manipulation

    Hi All, I have the following code: Sub NewTest() Dim IE As Object Set IE = CreateObject("InternetExplorer.application") With IE .Visible = True .navigate ("my website") While .Busy Or .readyState <> 4: DoEvents: Wend...
  4. steveuk87

    IE browsing and user field manipuilation

    Hi All, I have the following code: Sub NewTest() Dim IE As Object Set IE = CreateObject("InternetExplorer.application") With IE .Visible = True .navigate ("my website") While .Busy Or .readyState <> 4: DoEvents: Wend...
  5. P

    Web Scraping with VBA - problems clicking a button (button is only class)

    So i got everything working to go to the website, enter in the username and password but i don't know how to change this so that it clicks the "sign in" button. Private Sub Open_multiple_sub_pages_from_main_page() Dim i As Long Dim IE As Object Dim Doc As Object Dim objElement As Object...
  6. S

    Macro not printing

    I am trying to run the macro below, but it doesnt seem to be printing. What is wrong with it ? Option Explicit Sub test() Dim i As Integer i = 1 While Sheets(2).Cells(i, 1).Value <> "" Sheets(1).Cells(1, 1).Value = Sheets(2).Cells(i, 1).Value Sheets(1).PrintOut...
  7. P

    VBA Virtual Loop

    Hello, How do I write code to move on to another question if the information doesn't exist on my spreadsheet? My code is: 'Select Start of range Range("B1").Select While ActiveCell.Value <> "" 'This writes 'Cash' in column A against cash transactions. If ActiveCell.Value <> "" Then...
  8. Z

    macro runs when stepped through but deletes rows of original table when run with f5

    Hi all, New to excel and can't figure out why this macro deletes some of my rows when it is run. Any help appreciated . My original data is across two sheets with first sheet having 19 columns with columns I to S housing numbers that are manipulated to calculate cash which is inputted in the...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top