View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stanley Lam Stanley Lam is offline
external usenet poster
 
Posts: 3
Default Remove extension

Hello,

First of all - sorry for my bad english!

I have written a macro in Excel that does the following things:
* the data on the sheet is copied to another workbook and this workbook
is saved as a *.prn file
* then the new workbook will be closed

Is it possible to remove the prn-extention after I have saved and closed
it?



Stanley

*** Sent via Developersdex http://www.developersdex.com ***