Re: Saveas with name of another file
From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 06/11/04
- Next message: Frank Kabel: "Re: Conflicting VB Code"
- Previous message: Ron de Bruin: "Re: Automated userform inputs to the spread***"
- In reply to: sowetoddid: "Re: Saveas with name of another file"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 11 Jun 2004 17:53:23 +0200
Hi
another option: use replace for this
-- Regards Frank Kabel Frankfurt, Germany > Trying to modify the saved name just slightly... > > How do I remove the .xls?? > > > ThisWB.SaveAs fname & " - F" > > > --- > Message posted from http://www.ExcelForum.com/
- Next message: Frank Kabel: "Re: Conflicting VB Code"
- Previous message: Ron de Bruin: "Re: Automated userform inputs to the spread***"
- In reply to: sowetoddid: "Re: Saveas with name of another file"
- Messages sorted by: [ date ] [ thread ]
