Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

As a programmer I eventually located the file type of a .d extension file loaded successfully by Excel 2007 by interrogating Workbook.FileFormat via VBA, but can a normal user determine it is a DBF4 file when it is not saveable (without addins)?

(Specifically when you choose Save As, normally the existing file format is selected.)

FYI I've already checked Prepare > Document Properties, but I see nothing there. IIRC previous versions of Excel (or I might be thinking of Word) had the option to always display the file conversion dialogue box when opening a file, but I can't see a way to do so with Excel 2007 (and, in any case, the file isn't being converted -- it is being opened as a DBF4 file format).

share|improve this question
    
Have you seen this workaround? It's not .fileformat so it's not an "answer" –  Raystafarian Feb 8 '12 at 20:34
    
@Raystafarian: Your comment above may be worthwhile as an answer to the linked question. –  Mark Hurd Feb 9 '12 at 5:19
    
The Excel 2007-2010 32-bit add-in called SaveDBF might be of help. You can try out the demo at thexlwiz.blogspot.com –  user118076 Feb 13 '12 at 1:01
add comment

1 Answer 1

Per this documentation

dBase III and IV. You can open these files formats in Excel, but you cannot save an Excel file to dBase format.

Unfortunately, there is not a .fileformat for .dbf

share|improve this answer
    
As the question implies, I now know Excel 2007 is able to open these files, but I cannot determine a way for a normal user to determine what has happened. –  Mark Hurd Feb 9 '12 at 5:23
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.