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

Hello,

As I am hearing thunder outside, I let everyone in my office know that they should "save often".

That got me to thinking... is there a command to save all open Excel files at once?

In Word, you can add the "Save All" button to the Quick Access Toolbar but there is not one for Excel 2007.

I know if you exit Excel it will ask to save all the files, but that's not what I am looking for. I would like to be able to keep all of my files open. Will it have to be done in VB?

Thanks,
Pete

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?

Hi,

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?

Thanks,
Regards,
Kereltje

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

Thanks.

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

Hi,

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.

Thanks
-Akash

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?

Thanks

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 http://office.microsoft.com/downloads 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 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.

Thanks

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,

I created an excel document with about 25 tabs. Each tab has a "Save As" button. When you click on it, it opens up a dialog box for "Save As". Here is the code that I found online and used:


Sub mcrSave()

'Retrieve file name to use for Save
fileSaveName = Application.GetSaveAsFilename( _
fileFilter:="Excel Files (*.xls), *.xls")

'If user specified file name, perform Save and display msgbox
If fileSaveName <> False Then
ActiveWorkbook.SaveAs Filename:=fileSaveName, FileFormat:=xlNormal

MsgBox "Save as " & fileSaveName
End If

End Sub


Here is my problem:

I want to save only the current worksheet and not the entire document with all those tabs. I don't know any VBA, and I searched online and couldn't find anything to achieve what I am looking for.

Could somebody please help me?

Thanks

Hi

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!

Thanks

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.

Example.
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
Mark

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

Hello Community,

I have the options to save as .xls. I save as.. even the window to choose file location has .xls selected. I save the file. I locate the file, and its not saved as .XLS

I double click to open it.. its says open with.... I choose excel, but the check box that indicates if i'd like to open this file type in the future is disabled.

I am heavily confused.

Upon further discovery..

All of my previous xls files that were saved on my harddrive have no extension and the file type: FILE.

WHAT is going on here? please help

Afternoon All

Been searching throught the previous posts and cannot find anything, Wonder if any of you know how you can force an excel workbook to save compressed (zipped) , Have several files which have got quite large in size and need to be accessed remotely, if they were automatically zipped on save, this would make it quicker for my remote staff to open , amend and save