dttestdate

  1. T

    Open file based on its filename date and copy its content

    Hi everyone, I've been trying to create an Active X button to open a file based on the latest date on the filename and copy (the content) from its worksheet to my current workbook. Inspiration drew from...
  2. M

    How to call a file that is currently open for Vlookup?

    Hi all - I recorded a macro to open a file and find the latest file. I want to know since the date here changes daily, how do I call it from my vlookup? Sub Open_Argus() ' ' Open Latest Argus File '---Opens a sheet based on date, searches backward from today til it finds a matching date...
  3. M

    Vlookup with Date Changes daily

    I currently have this macro: Dim Lr As Long Lr = Range("E" & Rows.Count).End(xlUp).Row Range("P2").Select Range("P2:P" & Lr).FormulaR1C1 = _ "=IF(VLOOKUP(RC[-9],'[IPNS Security 07092018.xlsx]Sheet1'!C8,1,FALSE),""ARGUS"")" but the file name here the date "07092018"...

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