Thread: Changing workbook name in macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dutch76 Dutch76 is offline
external usenet poster
  
Posts: 1
Default Changing workbook name in macro

I want to change (in a macro) a workbook name before saving. Fo
instance: the original file is opened as "test.xls", an InputBox ask
for the extension (he _abc) and on saving the name should b
"test_abc.xls". I don't want the original file to be overwritten. Ho
can I achieve this

--
Dutch7
-----------------------------------------------------------------------
Dutch76's Profile: http://www.hightechtalks.com/m82
View this thread: http://www.hightechtalks.com/t234349

Reply With QuoteReply With Quote