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"...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top