Hi,
There are lot of similar questions but somehow its not working out for me.
I want to save the sheet (Source) from the active workbook as a new workbook where sheet name remains same and work book name must be "Source dd/mm/yy".xlsx.
This workbook needs to be saved in the same path as...
Hi there,
I am currently trying to make this code work, basically I am getting two codes I found and putting them together but it isn't working exactly how I expected. Instead of saving where the user selects, it is saving else where. Can someone shine a light on this please? The main code...
I have a project I am working on where I would like to save one of the sheets in my workbook as a .csv document. Below is the code I am currently using:
Sub myExport_Click()
Dim ws As Worksheet
Set ws = Worksheets("Export")
ws.SaveAs Filename:="myExport", FileFormat:=6
End Sub
This...
I consider myself to be proficient with Excel, and I've taught myself a little about Macros but there one I am having no luck on.
My Scenario:
I have an excel file with a lot of sheets, lets say 30. The sheets are named "First Last" (as in first name space last name).
I open the file, use a...
All for the same file :)
a.) I have an invoice template in one excel file in which I fill in data, out of which some of it auto fills as it is linked to another excel file in which the master data is stored and updated. I wish to edit this invoice "template" (if u may call it that:)) and once I...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.