About Us

C Brandt

Thanks

Craig

"Ron Rosenfeld" wrote in message
...
On Fri, 17 Aug 2007 16:15:33 -0500, "C Brandt"
wrote:

Ron:

Thanks for the speedy reply. Unfortunately it chokes with TEXT
highlighted
and gives me a popup with "Compile Error, SUB or Function not defined.
(Code Follows)

Any clues?

Thanks,
Craig

The formula I gave you is for a worksheet cell.

In VBA, in place of the TEXT function, you can use the FORMAT function.

Sub foo()
Const DN As Date = #7/23/2006#
Debug.Print "Acct " & Format(DN, "yyyy-mm-dd") & ".txt"
End Sub

-- Acct 2006-07-23.txt
--ron

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Formating	Mel	Excel Worksheet Functions	5	February 22nd 07 04:13 PM
Date formating	Hawksby	Excel Discussion (Misc queries)	2	December 14th 06 06:33 PM
testing for character strings within a cell	MKB	Excel Worksheet Functions	2	August 29th 06 06:54 PM
Finding 13 character codes in text strings	Bhupinder Rayat	Excel Worksheet Functions	2	April 25th 06 05:14 PM
How to find number of pairs of strings from list of strings?	greg_overholt	Excel Worksheet Functions	5	January 27th 06 10:42 PM

Menu

About Us