Posted to microsoft.public.excel.programming

ADK

external usenet poster

Posts: 89

writing to text file

This one will work for what I need....thanks

"Keith74" wrote in message
oups.com...
Hi

This seems to do the job (assuming the last 4 chars are the file
extension)

left(thisworkbook.Name,len(thisworkbook.Name)-4)

hth

Keith

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Writing to a text file	scantor145[_9_]	Excel Programming	6	June 30th 05 08:23 PM
Writing to a text file	Rachel Curran	Excel Programming	0	October 8th 04 09:44 AM
Writing strings to a text file ?	Dan Thompson	Excel Programming	3	September 23rd 04 07:17 PM
Writing to a text file some data	Tom Ogilvy	Excel Programming	0	September 9th 04 04:25 PM
WRITING TO A TEXT FILE WITH SPECIFIC FORMAT	[email protected]	Excel Programming	2	December 27th 03 05:04 AM

All times are GMT +1. The time now is 04:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us