Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove extension
Hi Stanley,
Why do you want to do this? Are you referring to the file on the disk, and do you want to change the file type? -- HTH Bob Phillips "Stanley Lam" wrote in message ... 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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove extension
Bob,
Thanks for your reaction! The file that has been made, I have to upload it to another application. But in order to make this work, there are 2 things that has to been done before uploading it: 1. the file has to be saved as a *.prn 2. the extension has to be removed So the type of file is created by my macro (*.prn), but the final step removing the extension still has to be made. Stanley *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove extension
Hi Stanley,
This should get you started Dim sFile As String sFile = "C:\myTest\Test.prn" Name sFile As Replace(sFile, ".prn", "") -- HTH Bob Phillips "Stanley Lam" wrote in message ... Bob, Thanks for your reaction! The file that has been made, I have to upload it to another application. But in order to make this work, there are 2 things that has to been done before uploading it: 1. the file has to be saved as a *.prn 2. the extension has to be removed So the type of file is created by my macro (*.prn), but the final step removing the extension still has to be made. Stanley *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove extension
If it is created by your macro, why not assign it a name with the extension
you want and just avoid the need to rename it. -- Regards, Tom Ogilvy "Stanley Lam" wrote in message ... Bob, Thanks for your reaction! The file that has been made, I have to upload it to another application. But in order to make this work, there are 2 things that has to been done before uploading it: 1. the file has to be saved as a *.prn 2. the extension has to be removed So the type of file is created by my macro (*.prn), but the final step removing the extension still has to be made. Stanley *** Sent via Developersdex http://www.developersdex.com *** |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove extension
Bob,
you're my hero! With that code I can remove the extension. Many thanks, Stanley *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file with udf extension | Excel Discussion (Misc queries) | |||
.xls Extension | Excel Discussion (Misc queries) | |||
Transformation d'images avec une extension .jpg ou .jpeg en images avec extension .bmp ou .ico | Excel Discussion (Misc queries) | |||
.xlb extension | Excel Discussion (Misc queries) | |||
xls extension | Excel Discussion (Misc queries) |