creation date

  1. R

    vba to save as created date or based on cell data

    hi, i have 3 xl files named current, previous and macro. current is a report that is run every other day and uses vlookups to the previous file (previous is the current file in a completed state). macro is an empty file except for a macro to run all vlookups on the current file. when all the...
  2. Z

    How do I create a function to display the 'General' File Creation Date?

    Apparently there are two types of Creation Dates for a File, and both of them can be viewed in the file properties. Statistical Creation Date: shows what date and time the 'original' file was created - stays the same even if the file in question is a copy of the original. General Creation Date...
  3. J

    getting a file name and file creation data of file looking into a folder and sub folders

    Hey guys , Here is what i would like to do . i have a folder that contains lots of sub folder with various different names and more subfolders within the subfolders What i would like to have is a script that looks in all these folders and firstly looks for the excel sheets , getting a name...
  4. S

    Obtaining original creation date from imported .txt file

    Hi, I have a very straight forward spreadsheet, which performs a currency conversion on the first sheet, with user defined currency codes and value. The Exchange rates are obtained through a macro button, which opens a text file, chosen by the user, named ***EXR.txt as a temporary workbook...
  5. M

    Filename Properties

    I have a question and it's probably a long shot, but maybe someone will have a suggestion I can use. What I am trying to do, is get the Modified & Creation Date of all files in a series of folders. For instance, the files can be .pdf, .xls, .doc, .rtf and would be located: in "This Folder" and...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top