+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 22 of 22

VBA coding for file creation

  1. #16
    Registered User
    Join Date
    08-21-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003
    Posts
    67

    Re: VBA coding for file creation

    Thanks a lot and Sorry for the inconvenience caused.

    In the input box what should I provide date or month in number

  2. #17
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    XLS 2016
    Posts
    2,724

    Re: VBA coding for file creation

    In the imput box put:
    day/mont/year
    The day can be whatever you want, the month is the month to create, the same for the year
    note : It can be improve or simplify
    - Battle without fear gives no glory - Just try

  3. #18
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    XLS 2016
    Posts
    2,724

    Re: VBA coding for file creation

    Do you know that, instead of a using a string to record date in the header ( eg Jul'18 ) you could enter a real date and prepare the format to display it as you need:
    1/7/2018 for July 2018
    and use a custum format like : mmm ' yy

    Of course the macro needs to be updated because the date is searched in the header row to see which column to treat .

  4. #19
    Registered User
    Join Date
    08-21-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003
    Posts
    67

    Re: VBA coding for file creation

    Thanks PCI I will check the macro and come back to you see if there is any doubt
    Last edited by aravindkm; Yesterday at 06:30 AM.

  5. #20
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    XLS 2016
    Posts
    2,724

    Re: VBA coding for file creation

    OK
    Here another one with a more friendly input message

    Please Login or Register  to view this content.

  6. #21
    Registered User
    Join Date
    08-21-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003
    Posts
    67

    Re: VBA coding for file creation

    What should we give in input box. Just any date is enough

  7. #22
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    XLS 2016
    Posts
    2,724

    Re: VBA coding for file creation

    Yes, but a date which fits in the month you want to prepare, for example for July from 1/7/2018 to 31/7/2018
    In the last macro sent a default value is given

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1