save and close

  1. A

    Macro to save worksheet as separate file?

    Hey all, What I'm hoping to create is an easier way of our wine bar to check its current inventory against what they should have and ultimately provide a very basic printout which can be e-mailed to our central office and then be printed off over here. The file, due to several macros already...
  2. K

    Save and close

    Could someone please help with the following: I have a master excel worksheet (Spare Parts requisition.xls)that consists of only one sheet. I would like to save a copy of this sheet, retaining this worksheet as the master copy but creating a new file from it after the user has added the data...
  3. M

    After Saveas need to show Original name

    Hi not shaw what I am doing wrong here, but please can someone help. I am working in a file with lots of sheets, one of the sheets I need to save as a txt file and then carry on working in the original file. Its working to save the file but after it closes the copy file, it returns to a open...
  4. N

    Send Email Using MACRO

    A B C D 1 Staff Team Manager Coaching Urgency 2 Jon Mark Sales Urgent 3 Sam Steve Billing Non Urgent 4 Jacob Mark Collecting urgent 5 Susan...
  5. D

    Disable the Ctrl-S

    I have disabled the Save and SaveAs features but I need to know how to disable the control-S key to prevent from entirely saving the workbook. I used the ---> Application.Onkey "^S", "" but it doesn't work. Does anyone have other suggestions? Thanks.
  6. L

    VBA - How to Save and Close without prompt

    Hello, I have the following line of VBA code within one of my macros. ActiveWorkbook.SaveAs Filename:="C:\LH1\" & flname, _ FileFormat:=xlCSV, CreateBackup:=False ActiveWorkbook.Close The macro opens up a new file, copies data into it, saves it as a .CSV, and then closes...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top