Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Extension
Hi All,
I have a workbook that has a save function that saves out a certain sheet and puts a custom extension on it other than "*.xls". However when I put it on this one computer it puts my extension on and then the ".xls" extension on. How can I stop this? Jason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Extension
Jason,
How are you doing you .Save ? I suspect all computers have the double extension, but because they are set to hide known extensions, you just don't see it. NickHK "Jason Zischke" wrote in message ... Hi All, I have a workbook that has a save function that saves out a certain sheet and puts a custom extension on it other than "*.xls". However when I put it on this one computer it puts my extension on and then the ".xls" extension on. How can I stop this? Jason |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Extension
Hi NickHK
Thanks for the reply, but I think I need o explain this better. What happens is when excel saves it adds on the *.xls extension which when my custom open dialog is used it doesn't show them it only looks for my custom extensions which are *.Quote, *.Contract & *.Eti, my code is shown below. FileSaveName = QuoteNumber & CustomerName & AccountName & ".Quote" ActiveWorkbook.SaveAs FileName:=FileSaveName, FileFormat:=xlNormal, WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False Jason "NickHK" wrote: Jason, How are you doing you .Save ? I suspect all computers have the double extension, but because they are set to hide known extensions, you just don't see it. NickHK "Jason Zischke" wrote in message ... Hi All, I have a workbook that has a save function that saves out a certain sheet and puts a custom extension on it other than "*.xls". However when I put it on this one computer it puts my extension on and then the ".xls" extension on. How can I stop this? Jason |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Extension
Jason,
AFAIK, you cannot achieve this in a single step. You actually want the file to be in XL format, but with your custom extension ? So .SaveAs normally, close the WB (or use .SaveCopyAs) the rename the file. Name MyFile.xls As MyFile.Quote using the full path as applicable, on a closed WB. NickHK "Jason Zischke" wrote in message ... Hi NickHK Thanks for the reply, but I think I need o explain this better. What happens is when excel saves it adds on the *.xls extension which when my custom open dialog is used it doesn't show them it only looks for my custom extensions which are *.Quote, *.Contract & *.Eti, my code is shown below. FileSaveName = QuoteNumber & CustomerName & AccountName & ".Quote" ActiveWorkbook.SaveAs FileName:=FileSaveName, FileFormat:=xlNormal, WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False Jason "NickHK" wrote: Jason, How are you doing you .Save ? I suspect all computers have the double extension, but because they are set to hide known extensions, you just don't see it. NickHK "Jason Zischke" wrote in message ... Hi All, I have a workbook that has a save function that saves out a certain sheet and puts a custom extension on it other than "*.xls". However when I put it on this one computer it puts my extension on and then the ".xls" extension on. How can I stop this? Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel changes file extension on embedded object upon save | Excel Discussion (Misc queries) | |||
Default Save Extension | Excel Discussion (Misc queries) | |||
How can I save a file in Excel 2007 beta 2 as a .dbf extension? | Excel Discussion (Misc queries) | |||
Additional file with no extension created during File Save As proc | Excel Discussion (Misc queries) | |||
auto save with variable name with html extension | Excel Programming |