Posted to microsoft.public.excel.programming

Alan[_2_]

external usenet poster

Posts: 116

Remove .xls from a variable filename

I have a CommandButton on a worksheet to create a copy of the
ActiveWorkbook. I want the copy's filename to be the same as the
ActiveWorkbook.FullName but add "_Complete" before the file
extension. i.e......C:\FileName.xls to C:\FileName_Complete.xls.
Any help would be greatly appreciated.

--------------

Regards,

Alan

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
Filename variable	[email protected]	Excel Programming	17	September 4th 06 02:47 PM
Converting a Variable Filename to a Constant Filename	Magnivy	Excel Programming	2	August 15th 06 06:13 PM
Variable Filename calls	Grymjack	Excel Programming	0	June 7th 06 05:34 PM
How do I remove multiple windows of 1 workbook (filename.xls:2,:3	Stacey D.	Excel Discussion (Misc queries)	2	March 1st 06 09:57 PM
Filename Variable?	Penflex	Excel Programming	2	May 5th 05 05:11 PM

All times are GMT +1. The time now is 01:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us