+ Reply to Thread
Results 1 to 2 of 2

Converting text to date

  1. 11-25-2006, 11:25 AM #1
    zodiac
    zodiac is offline
    Registered User
    Join Date
    11-25-2006
    Posts
    3

    Converting text to date

    Hi,

    I have a sheet name , "14Oct2005". I wan to add another sheet with "15Oct2005". I want to carry on adding sheet with an increment in the date for another 10 loops. Anyone know how to do it in VBA?

    Thanks in advance!
    Last edited by zodiac; 11-25-2006 at 11:30 AM.
    Reply With QuoteRegister To Reply
  2. 11-25-2006, 12:29 PM #2
    Carim
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Among many different possible solutions, say you select cell A1 of your worksheet to determine the name of the sheet ...
    Following event macro will do the job ...

    Please Login or Register  to view this content.
    HTH
    Carim
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1