Search:

Type: Posts; User: Leith Ross; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.10 seconds.

  1. Re: Excel VBA to extract 2 or 3 keywords left and right from cell content

    Hello Satish,

    What would the output on Sheet3 look like? You did not include examples in your workbook.
  2. Replies
    10
    Views
    257

    Re: Barking up the wrong tree

    Hello HappyChappy,

    My guess is the workbook was not found. Check the file path is correct by stepping through the macro code or setting break points to inspect the variables.

    How To Step...
  3. Replies
    10
    Views
    257

    Re: Barking up the wrong tree

    Hello HappyChappy,

    Sorry about that. Change WksRng to RngDst.
  4. Re: Help copying data and transpose from one sheet to new sheet

    Hello TxRob81,

    Here is VBA macro do what you asked. Change the worksheet names in the macro code to match the names you are using. The variable name WksSrc refers to the Source Worksheet and...
  5. Replies
    10
    Views
    257

    Re: Barking up the wrong tree

    Hello Happy Chappy,

    This macro should be copied into a new workbook. This will open the Harlow Hours Tracker workbook, ask for the week number and copy the files from the folder...
  6. Thread: subroutine

    by Leith Ross
    Replies
    6
    Views
    115

    Re: subroutine

    Subroutine in VBA is often used incorrectly. Code that starts with the word "Sub" is not a subroutine but a Sub Procedure. A true subroutine is code within the Sub or Function procedure that executes...
  7. Re: Consolidating data from many sheets into one sheet

    Hello Andy,

    This should work for you. Add a new VBA Module to your workbook's VBA Project. Copy and paste the code into it.



    Sub ConsolidateData()


    Dim NewWks As Range
  8. Re: Consolidating data from many sheets into one sheet

    Hello Andy0311,

    I am not sure how you want the outputs to be arranged on the worksheet. Can you provide an example?
  9. Re: Find last used cell within For Each Loop

    Hello Peteor,

    This is a User Defined Function (UDF) that will return the last cell in a column from a starting row. If the range is empty the function returns the special object Nothing.

    Add a...
  10. Replies
    10
    Views
    257

    Re: Barking up the wrong tree

    Hello HappyChappy,

    This will ask you to choose the folder and enter the week number. This probably could be done in a single step. But, I would need to see a example of the actual path.

    The...
  11. Re: Userform ListBox - Display a Tick if Condition is Met

    Hello Boffa,

    The RowSource property makes using a ListBox easy but also prevents you making changes to ListBox's data directly through VBA. The other problem is the ANSI character set does not...
  12. Re: Export excel sheet as PDF to an existing folder

    Hello SSF1590,

    You're welcome. Thanks for the feedback. Good to know it is working correctly.
  13. Re: Export excel sheet as PDF to an existing folder

    Hello SSF1590,

    This macro should do what you want.



    Sub Test()


    Dim File As Variant
  14. Re: Export excel sheet as PDF to an existing folder

    Hello SSF1590,

    So, there is a single folder for each file created?
  15. Re: Export excel sheet as PDF to an existing folder

    Hello SSF1590,

    Which path is correct: "C:\Users\SSF1590\Desktop\TARA Project\TARA", "C:\Users\SSF1590\Desktop\TARA Project\TARA-19", or "C:\Users\SSF1590\Desktop\TARA Project\TARA-19-001" ?

    If...
  16. Replies
    12
    Views
    413

    Re: VBA - Auto login to website

    Hello ashk0812,

    This Login Form uses JavaScript. Internet Explorer will return only the Client side information. That is, the basic structure of the web page returned by the site. The Login Form...
  17. Replies
    12
    Views
    413

    Re: VBA - Auto login to website

    Hello ashk0812,

    Okay, I stand corrected. Well, it could be the "form" is being generated using Java after the page the displayed. Can you post a screen shot of the page?
  18. Replies
    12
    Views
    413

    Re: VBA - Auto login to website

    Hello ashk0812,

    The URI (the end part of the URL) "/index.html#/" is commonly used to indicate a selection of pages. A login page looks like "/login?/".
  19. Replies
    1
    Views
    69

    Re: VBA: Open PDF with GGS in filename

    Hello bamaisgreat,

    If you only have one PDF file with GGS in the file name then this will work...


    Public Sub openJOBLIST()


    Dim path As String
    Dim PDFfile As String
  20. Re: most efficient way of copying and paste a range as values VBA

    Hello daveyc18,

    In VBA it is rare that you need to select an object before performing an action on it.



    'acct - You may need to replace ActiveSheet with the Sheets("Sheet Name") ...
  21. Replies
    12
    Views
    413

    Re: VBA - Auto login to website

    Hello ashk0812,

    At first glance your URL "https://dhl-sequencecheck.newlinecomputing.net/api/index.html#/" is not a login page.

    On which line is the error being generated?

    HTML does not...
  22. Re: Struck a snag converting 32bit to 64 bit

    Hello AlexanderBB,

    The Windows API code is written in the "C" language. If you're not familiar with "C" then translating from "C" to VBA can be difficult or impossible.

    The API can sometimes...
  23. Replies
    5
    Views
    116

    Re: Extracting Date from string in VBA

    Hello Nygie,

    May be this what you need.



    Dim lr As Long
    Dim Rng As Range
    Dim sht As Worksheet
  24. Re: create files with contact information list

    Hello secoo140,

    A big obstacle to creating and testing code for your workbook is the worksheets are password protected. Can you post the password or passwords for the worksheets?
  25. Replies
    2
    Views
    192

    Re: Pricing from homedepot.com

    Hello bgolpmp,

    Home Depot has a web based API that is free to use. However, you do need to setup an account to login to the web site.

    Have a look at this link...
    Home Depot Product API
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4