Results 1 to 11 of 11

Is there any formula can read the data from the file name and mark it onto an excel file ?

Threaded View

davidtips0214 Is there any formula can read... 02-10-2023, 08:02 AM
protonLeah Re: Is there any formula can... 02-10-2023, 09:42 PM
davidtips0214 Re: Is there any formula can... 02-11-2023, 12:23 AM
protonLeah Re: Is there any formula can... 02-11-2023, 12:47 AM
davidtips0214 Re: Is there any formula can... 02-11-2023, 01:14 AM
protonLeah Re: Is there any formula can... 02-11-2023, 07:03 PM
davidtips0214 Re: Is there any formula can... 02-12-2023, 05:28 AM
davidtips0214 Re: Is there any formula can... 02-11-2023, 10:24 PM
protonLeah Re: Is there any formula can... 02-12-2023, 07:37 PM
protonLeah Re: Is there any formula can... 02-13-2023, 10:36 PM
davidtips0214 Re: Is there any formula can... 02-13-2023, 11:34 PM
  1. 02-11-2023, 01:14 AM #5
    davidtips0214 is offline
    Registered User
    Join Date
    07-31-2022
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    25

    Re: Is there any formula can read the data from the file name and mark it onto an excel fi

    @protonLeah

    your VBA helped me a lot, very appreicated

    Just a bit more request, is it possible to generate a date and put it onto sheet "PM date" ?
    Please refer to a new attachment

    As this is requested by our client.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Read from a html file and paste part of content into a excel file
    By srgunukula in forum Excel General
    Replies: 7
    Last Post: 07-19-2019, 06:30 AM
  2. Read binary data from non excel file and post in excel file
    By D S Rama Rao in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-05-2015, 05:33 PM
  3. read value of strings from a text file and make an excel file.
    By gashforing in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2009, 07:12 AM
  4. How to Create a file in Excel that can't be copied or printed:read only file
    By enroh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2006, 10:40 AM
  5. Pasword protected Excel file encrypted, how do I read this file?
    By jonesteam in forum Excel General
    Replies: 2
    Last Post: 12-12-2005, 02:35 PM
  6. [SOLVED] How to save a PC Excel file into MAC (it says file is read only)?
    By claudiosissa in forum Excel General
    Replies: 0
    Last Post: 11-29-2005, 10:00 PM
  7. Excel file won't open because it' a read only file when it is not
    By IanB in forum Excel General
    Replies: 1
    Last Post: 09-12-2005, 09:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1