Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

How To Save Xls As Dbf. Dbf Is Not In save As Box.

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Need to save a worksheet as a .dbf instead of .xls. Have tried to locate dbf
in the 'save as' and 'files of type' boxes. also tried to find a converter
on this website.

View Answers     

Similar Excel Tutorials

Make Users Enable Macros in Order to View a Workbook in Excel
Tutorial showing you how to make a user enable macros in a workbook in order to view the workbook. This is very im ...
Quickly Switch the Columns and Rows of a Data Set in Excel
How to switch a data set in Excel so that the columns become rows and the rows become columns. This will save you ...
Understanding Formulas and Functions in Excel
In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A formula is an expression whi ...
Change the Default Number of Worksheets Created in a New Excel Workbook
Learn how to change the number of worksheets that are in new Excel workbooks. Excel workbooks always have 3 worksh ...

Helpful Excel Macros

Disables the "Save As" Feature in Excel
- This macro will disable the Save As feature in excel. This means that a user will not be able to resave the workbook un
Save the Current Worksheet as a New Excel Workbook File
- This Excel Macro will save the currently visible/active worksheet (the one that you see when you run the macro) to a
Excel Macro to Save a Specific Worksheet as a New File
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a
Save the Current Worksheet as a New File in the Current Folder
- This Excel Macro saves the currently visible worksheet into the SAME folder as the current file. It is different from
Change Formulas to Absolute or Relative References
- This macro will change the formulas in cells to absolute or relative. It allows you to change the rows or the columns o

Similar Topics

I have drop down boxes which have actions which run when the box changes.

However i do not want these to run when i do a save or a save as. For some reason when i save it refreshed all the boxes and runs the assocaited code.

How do i code to prevent this running when i do a save or save as?




I am using the FollowHyperlink command in VB to access a large series of csv files from a website. Every time I download a file, Excel asks me to either Save, Open or Cancel the download. How can I automate the Save process so that my macro can uniquely save each downloaded csv and move on to the next?

Is their perhaps some code that will allow the download to save as default without the pop up window appearing at all?

Thanks in advance,


Hi All,

Can anyone help:- I want to be able to save an file created on my computer for use with a device using Windows mobile Ver 6. The files in Windows have the ext .xlsx but I can't find this in the drop down in the save as file type list.

I have files on my mobile device saved as xls, but whenever I change and save them I have to save a copy i.e. Save As.. Filename(1) whereas the xlsx files will just accept the changes and save as they are.

Very grateful for some help with this. Thanks


Hi all

I recently had ro re-image my laptop and reinstall the OS and Office

After this procedure, whenever I try to save a spreadsheet I get the following error when trying to save via File>Save, CTRL+S or clicking on the small disk icon in the toolbar

the only way I can save is to close excel and when it asks me if I want to save changes, take it from there

suggestions for a dunce most welcome

File/Save in the VBE doesn't save my .xla file. The Save button on the VBE toolbar doesn't save my .xla file. Ctrl-S doesn't save the file. Oddly, Workbooks("filename.xla").Save in the Immediate window DOES save the add-in. I've re-started Excel and it didn't fix the problem. Any other ideas what might have happened?

Is it possible to save a spreadsheet in .xlr format?
My technician has MS Works (version that comes on new PCs.)
I have Excel 2002.
I do not see in the "Save As" field an option for .xlr.
Is there a plug-in somewhere?
Is there a converter somewhere?


In my excel worksheet I have created two buttons. On for "Save As" and one for "Save/Exit". They work fine.
I want to force the user to use these buttons and not the Excel build in "Save" and "Save As" from the top bar.

Anyone who knows how to do this?


Hi there,
i tried all vba's here and on google to disable save / save as, but none of them work so i would like to know the other way , how to go with clearing the contents of cell, the moment someone clicks save / save as, with /without range by using beforesave event


Everytime I make alterations to a sheet I cannot just click the 'save' button as it does not save the changes. Then when I go to 'save as' it actually says 'save as web page'.

How can I disable this function?

hi All

Can you help, i am trying to disable Save As with the code below.
I seem to have disabled Save but not save as.
If a user enters data i want them to save and not save as.

Any help will be great.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI = False Then

Cancel = True

MsgBox "Sorry, you are not allowed to use Save As.", vbCritical, "No Save As"

End If

End Sub


Thank you in advance.

Scenario : There is a website that allows me to save reports to excel. The problem is it always save it as a webpage, the file name does contain the .xls extension, but the type says webpage. Is there a way to force save the document as Microsoft Office Excel Workbook(*.xls). I know that we can Manually change it using the save-as dialog, but i want all the reports to be saved as .xls as my staff is not tech savvy.


Dear all,

I have put a command button which do the save function as follows:

Private Sub CommandButton1_Click()

ThisWorkbook.SaveAs Filename:="abc.xls"
End Sub

And I have disabled the save and save as menu with following code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean,
Cancel As Boolean)
Cancel = True
End Sub

Now, the problem is although I can disable the save and save as
menu, the save button is disabled too. How can I disable save and save
as menu but still allow my save button(CommandButton1) to save?


Hi Excelperts,
I want to open the 'save as' box, and have it fill in the filename based on the value in 'g1' but I DON'T want it to save (it can't save to the location where its opened from so it has to be saved elsewhere.)

Can this be done? I have been able to get it to save as the value of g1 ( but no save as box), and I've been able to get it to open the save as box (but not fill in the value of g1) but not this ideal combo between the two.


Till very recently, I was able to save Excel 2007 files as PDF. (When I clicked on the "Save As" button under "Office" button, I found a pdf option in the "Save As Type" drop-down box. Very recently, it has disappeared. Incidentally, Word still has the option. I did find a "Microsoft Save as PDF or XPS" download in the "Popular Downloads" section at but I doubt if that is necessary (This download is for the entire Office suite and Word as I mentioned still gives me the option to save as PDF. Adobe 8 works fine. Any suggestions?

Hi and Happy new year,
I would like to be able to save a worksheet without altering the original, using a couple of ranges as the save name.
So if a user exits the workbook or tries to save the workbook, it will automatically save to a backup folder and not save the original workbook

Hi All,

I am running some VBA that saves a selected worksheet in a workbook to a text (*.txt) file. Some of the worksheets contain '+' which are unable to be used in the save name.

Is there any codes that can be used that look at the sheetname, ignore any characters that cannot be used in the save function then modify the save name to exclude these characters then save the file. The worksheet names must remain unchanged.

Sheet Name = Test+Testing
Resulting Save File Name = 'Test+Testing.txt' - Cannot be Saved due to '+'
Required Save File Name = 'TestTesting.txt'

Maybe if the code would allow a replacement character to be used i.e. change the Character unable to be used in the save file type to "" to indicate no space or " " to indicate space.

Thanks in Advance


I have several linked excel spreadsheets, basically in the format of a database (1) which is fed from several feeds (a, b, c, d) and which in turn creates output files (2, 3, 4, 5).

I have all these files open at the same time to allow links to update. However, when i then try and save & close them, sometimes it is fine and saves straight away, sometimes it can take up to 30 mins. Does anyone know the best order to save these in order to make it save quickly? I've tried trial and error but can't find a pattern!

For example, if they are all open and i try and save (2), will excel try and update all the links in (2) and take a long time to save? Likewise if I try and save (a) would excel try to update everything that is fed from (a) (i.e. (1) and in turn (2, 3, 4, 5)

Hope this makes sense!


Whenever I save a file with Excel 2007, the file type in the file open dialog is displayed as Microsoft Office Excel Worksheet even though Excel Options > Save > Save workbooks > Save files in this format is set to Excel Workbook.

Would greatly appreciate a solution to this problem.

I realize it is a long-shot, but is it possible to write a macro that will do the following?

1.) Look through the entire Outlook inbox and save any Excel attachments to a specified folder.

2.) Only save Excel files that have a specific word in their name, or, only save Excel files that have a sheet with a specific name. For example, only save files that have "Payroll" in the title, or only save files that have a tab named "Payroll."

* I am aware that anything which automatically opens emails or attachments is a security risk.

/I thought I was decent with excel until I saw this board. Now I know that I am truly an amateur.

I want to put a button marked "SAVE AS" on my spreadsheet, and when it's clicked have the macro read the contents of Cell A1, add .xls to it and incorporate it in the Save As function. In other words, I need to speed up the Save As process such that all I have to do is type the name in Cell A1 and click the SAVE AS Button. Any ideas?

Thank you

I have the following code in a macro:

fileSaveName = Application.GetSaveAsFilename( _
     fileFilter:="Text Files (*.csv),*.csv,")
If fileSaveName <> False Then
     MsgBox "Save as " & fileSaveName
End If

When it runs, it appears to do everything I want it to do. It opens a "Save As" window, the "Save as type:" is prefilled with "Text Files (*.csv)", however, when I change the file name and click "Save," it doesn't actually save anything in the folder.

Any help would be greatly appreciated.

I want to add a command Button to a worksheet that will, when pressed, save the worksheet into a predetermined location in a format like Mike06March2007. I can get the Save button to save itself with but I am stuck for the rest. Any code I have already used from the internet generates an error. Any ideas would be welcome.

I have created a macro that will take my excel information and paste into a CSV (comma separated values) file and save. The problem is the save pop up window that appears upon exiting the CSV file. As the macro is running, the macro will not complete until I click on "Yes" to save pop up window. I would like to run the macro without the save pop up window. Moreover, if I were to save the file as an excel file, the save pop up window does not appear.

Is there a way to turn off the save pop up window upon exiting a CSV file?
Is there VBA language that I may add that will disable the save pop up window upon exiting a CSV file?

Thank you, Mark Cicoff

I have writen a program that would create a report and print it to pdf and then save the pdf.

I was able to create a dir for the pdf to be saved in however the save as dialog box still opens up with the correct file path.

How do I get it to automatically save as though I was to click on the save button?


What code do I need to have a Save As macro button that when clicked will
bring up a Save As Windows box so that you can choose where to save the file.
At the moment it just asks if I want to overwrite the existing file but does'nt
give me the choice as to where to save it?