| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlWorkbookDefault
I'm curious what the default file type for Excel 2007, and is it possible to
override it somehow? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
xlWorkbookDefault
Hi Bitpusher1010
You can change the default Save format in 2007 if you want For code see this example http://www.rondebruin.nl/saveas.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bitpusher1010" wrote in message ... I'm curious what the default file type for Excel 2007, and is it possible to override it somehow? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
xlWorkbookDefault
The HTM you gave below does not reference xlWorkbookDefault. How does one
change the default file type when SaveAs is used. xlWorkbookDefault = 51, does, is it always going to be an XLSX if we use 51/xlWorkbookDefault? THanks. "Ron de Bruin" wrote: Hi Bitpusher1010 You can change the default Save format in 2007 if you want For code see this example http://www.rondebruin.nl/saveas.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bitpusher1010" wrote in message ... I'm curious what the default file type for Excel 2007, and is it possible to override it somehow? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
xlWorkbookDefault
Look in the VBA help for
Application.DefaultSaveFormat Manual see Office ButtonExcel OptionsSave See the first line -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bitpusher1010" wrote in message ... The HTM you gave below does not reference xlWorkbookDefault. How does one change the default file type when SaveAs is used. xlWorkbookDefault = 51, does, is it always going to be an XLSX if we use 51/xlWorkbookDefault? THanks. "Ron de Bruin" wrote: Hi Bitpusher1010 You can change the default Save format in 2007 if you want For code see this example http://www.rondebruin.nl/saveas.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bitpusher1010" wrote in message ... I'm curious what the default file type for Excel 2007, and is it possible to override it somehow? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
xlWorkbookDefault
Got it. Thanks!
"Ron de Bruin" wrote: Look in the VBA help for Application.DefaultSaveFormat Manual see Office ButtonExcel OptionsSave See the first line -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bitpusher1010" wrote in message ... The HTM you gave below does not reference xlWorkbookDefault. How does one change the default file type when SaveAs is used. xlWorkbookDefault = 51, does, is it always going to be an XLSX if we use 51/xlWorkbookDefault? THanks. "Ron de Bruin" wrote: Hi Bitpusher1010 You can change the default Save format in 2007 if you want For code see this example http://www.rondebruin.nl/saveas.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bitpusher1010" wrote in message ... I'm curious what the default file type for Excel 2007, and is it possible to override it somehow? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
