xlWorkbookDefault

  • Thread starter Thread starter Bitpusher1010
  • Start date Start date
B

Bitpusher1010

I'm curious what the default file type for Excel 2007, and is it possible to
override it somehow?
 
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.
 
Look in the VBA help for

Application.DefaultSaveFormat

Manual see
Office Button>Excel Options>Save
See the first line
 
Got it. Thanks!

Ron de Bruin said:
Look in the VBA help for

Application.DefaultSaveFormat

Manual see
Office Button>Excel Options>Save
See the first line
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use automation to save xls into pdf from office 2007? 3
Special effect on User form 1
Hooking the FileOpen Event from the OfficeMenu in Excel 2007 1
Text boxes which can float outside the Excel application! 3
Adobe flash Player 2
Excel 2007 Custom ShortCut Keys 1
Just curious...re: email links 5
Addin - Invalidate Error 3

Back
Top