save and close

Hi All, Can anyone help me to complete my code (Excel VBA) to automatically process a File Download dialog from Internet Explorer. I want to click "Save" which will produce the "Save As" dialog. Then file name should access from A1 cell and should get save in C:\Temp\ and click "Save" again...

Hello All, I am reposting this question as it has been two days without a response. My macro runs start to finish with no problem, but after it is done running it always crashes Excel (2007) when I try to save the file containing the macro. I get the below error details. Problem...

Hi, This is a follow up to a thread I've read here about values being entered into cells before being able to save the excel file. http://www.mrexcel.com/forum/excel-questions/433912-must-fill-cell-before-being-able-save.html The solution here is fine for one cell, but what I am trying to...

Good morning, I have created a form with serveral userforms. Essentially it performs a costing calculation then gives the user the option to log the results in a table on the same page, looking for the next available empty row. Nothing in the code asks to save or close the workbook at any...

:( Hello. I am trying to copy data from a 'sales receipt' worksheet onto the next available column of my 'sales summary' worksheet, then close both while saving the 'sales receipt' worksheet changes into a specified folder ("C:\My Documents\Sales Receipts") as a new file named by the value in I6...

Hi all I have a macro which imports text files to new sheets, but to stop the file from becoming too large, I want it to stop the import macro when the sheet count reaches 8, then open a new file and restart it. Heres my current code Sub Selection() Set Rng = Tabelle2.Range("A3:A65536") Dim b...

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

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

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

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

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.

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