save workbook

  1. U

    Creating Workbooks with Page Breaks

    I have a spreadsheet with data that are separated by page breaks. I'm trying to figure out a VBA script that: create workbooks after each page breaks save in the same folder as the current spreadsheet with the naming convention (ex. Workbook 1, Workbook 2, etc.) each workbook needs the same...
  2. B

    Excel VBA Save Workbook as current workbook name

    Hello, I have this file 08.22.2017_13.07.34.csv whose name changes daily with respective date and time. Using the macro below i am only able to use it with this file name. What I want it to do is be able to use it with any excel file that i open. I also want it to save using the current...
  3. R

    Copy worksheet into new workbook and save using .xlsm format

    Hello there, I was fortunate enough to find this code written by Joe4 which I customized just sligtly. But I am unable to save using .xlsm format. Any ideas? Saving .xlsx works fine. Thanks Sub Copy2_NewWB() Dim mySourceWB As Workbook Dim mySourceSheet As Worksheet Dim...
  4. S

    Create folders and save Workbook

    How can i make this code save new folder to "\\fileserver\Users\Public\Documents\Main Customer\New Folder Name" and create 3 subfolders "Images","Work Orders","Lead Info" Public Sub SaveOnDesktop()Dim strPath As String, strFile As String 'Build Path strPath = Environ$("HOMEPATH") &...

We've detected that you are using an adblocker.

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.
Go back
Back
Top