auto run macro

  1. M

    Run VBA When Work Book Opens

    Hi all, I've got the below code which works very well, however, I'd like it to automatically run when the workbook is opened. What do I need to do? Sub SaveAsPDF() Dim fName As String With ActiveSheet fName = .Range("A1") .ExportAsFixedFormat Type:=xlTypePDF, Filename:= _...
  2. S

    Combining two tables into one master table

    Hi there I am currently in the process of trying to set up a master table based upon two tables I already have and to formulate a code that will allow any new data added to the two tables to copy into the master table. All tables are in the same workbook and are set out as follows: Sheet one =...
  3. F

    Macro Drag Down Help

    Hello people, I'm stuck with a spreadsheet I'm trying to do. I've put it in place for someone else who is even worse at computers than me, Columns C,E,G etc... (alternate columns) all update automatically to a certain extent. I'm up to row 38 at the minute I want/need If Column "A" includes a...
  4. J

    Help with Auto run macro , Multiple Columns in one code? I have been at this for 2 days please help

    Simply put I want a macro to auto run upon launching excel 2014, to create Auto Time stamps in cells , when data is WRITTEN or PASTED into adjacent Column cells. I want to do this in multiple "column pairs ". The columns are paired but rows function indepently. Ex: Column A and B is a Pair...
  5. C

    Automate VBA and save as new file plus update xml from range

    I appreciate this may be a big question but .... I have a macro, I would like it to auto run at 17:00 and 22:00, save with a new file name and update an xml file with a range of cell from a worksheet in the workbook. The XML layout matches the worksheet, at present I manually copy and paste.
  6. G

    How do I create a VBA macro in Excel that uses the goal seek function?

    How do I create a VBA macro in Excel that uses the goal seek function? Set Cell: C49 To Value: (whatever I have in cell L47) By changing cell: B19 As I change the value in cell L47. I want the macro to automatically run in the background.
  7. J

    Ontime vba schedule on server

    Hi All, I want to schedule a report on a server PC that is always on. The vba code has to pick up the file and save it, if available, from 05.00 till 08.00. Every day automatically. If the file is not available the macro should re-run every 30 minute till the vba get the file or 08.00. I wrote...
  8. H

    auto run all macros when workbook open

    Hi, May i know the code to auto run all macros of a workbook when the workbook is opened, rather than storing the file at trust location or manually enable macro? Thanks!
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

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
Top