macros

  1. S

    How to fire an Excel macro from MSAccess?

    I have an Excel spreadsheet that is always open. I want to use Visual Basic in MSAccess to execute an Excel macro based upon certain conditions in the MSAccess database. I can use Auto Open to run the macro from a closed Excel Spreadsheet from MSAccess by closing it and then opening the...
  2. F

    Excel Xlstart folder

    Hi All, looking for help on an issue I'm having with the personal.XLSB workbook, I'll be as clear as I can. Long time users of Macros stored in an excel workbook saved in C ://users/username/appdata/roaming/microsoft/excel/xlstart Stating the obvious this workbook should open hidden but make...
  3. N

    Synapse 3 - How to do Macros

    I cant, i just cant... I want to make a toggle macro for shift. I watched some videos on youtube and they all tell me to click record then hold the key and then press again to end the macro but i cant it doesnt let me click it until i release the key!! Seriously what is this !!?? So pls if...
  4. J

    Automated email in excel, driven by due date

    Hi everybody, First time poster. I currently have 9 tabs open and hours of researching trying to figure this out. I can say I'm more educated now with excel than I was this morning. Very powerful software. I seen current thread that were very close to what I need but was unsuccessful with...
  5. C

    Solved Excel 2016 and VBA to create automated business checklist

    Hello, I've been online all day trying to find more info on creating an excel spreadsheet with VBA scripts to send an email when there is an upcoming due date. I'm trying to learn about macros and VBA scripts, but I've never learned how to code and this stuff looks very dense. In this...
  6. Adman8

    VBA Script for sending automatic reminder mails

    Hi everyone, This is my first query on this forum. I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts. The details of the input sheet are as shown...
  7. Adman8

    VBA Script for sending automatic reminder mails

    Hi everyone, This is my first query on this forum. I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts. The details of the input sheet are as shown...
  8. D

    Auto unlock tabs after data is entered

    I am trying to figure out how to set Excel up to automatically unlock tabs after data is entered. Ex: I enter data in cells on sheet 1 and sheet 2 is locked until all data fields are entered in sheet 1. Sheet 3 stays unlocked until all data fields in sheet 2 are entered, etc. I know...
  9. H

    Solved Excel and Emailing AGAIN!

    Good day, First I'd like to say...This site is a great learning resource! Learned so much about VBA and Macros in just two days. Now the issue. I found two great codes that I will 'splice' together to get what I want...
  10. A

    Creating a Macro in Excel: Date by addition when printing

    Good Morning, I am attempting to create a print preview, and then a printing button for one of my documents. I figured out how to do a basic print preview and then print when approved. If possible, I would like to create 5 copies (currently just pressing the button 5 times) and on each...
  11. C

    Populating Excel sheet from Outlook Mail

    Hi everyone, I read a post on Tech Support Guy that was similar to my question however seeing as the thread was quite old, I thought I would ask again to see if there were any new ways of doing this. I have a spreadsheet with Name, Surname, ID number, Verification Code, Employee Number...
  12. dakotamcc

    Solved Automate Calendar to Update Excel Sheet

    Background: We have a weekly meeting that we all sit around and dish out our schedules and manually input them into a master excel sheet. This is inconvenient, time consuming, and inefficient. We would like to automate the process. What we need: Outlook Calendars (7 in total) -> Master Excel...
  13. T

    Excel 2016 Error "1004"

    I'm receiving the following error when trying to run a recorded macro: "Run-time error '1004': Cannot use that command on overlapping selections." It was successful when I recorded it, but when I tried to run it on a new sheet, I received the error. My code: Sub Sub_and_delete_blanks()...
  14. S

    Solved Auto Email Reminder from Excel when project is almost due

    Hi everyone, I have no prior experience with Macro/VBA and would need help in creating an excel spreadsheet where an email reminder would be sent 60 days, 30 days and 7 days respectively if the project is not completed to the email stated in the 6th column with information from its row. If its...
  15. G

    Printing every other page of an entire workbook

    I am trying to write a macro that will allow me to print either only the first or second page of the 30 or so Sheets I have in an open workbook. I found how to print the second page of an open sheet and how to print all pages of the workbook but I need help combining the two! I am using this for...
  16. K

    Help - Macro to insert/copy another file into a word doc?

    Hi So basically I'm very new to macro and have no idea! My boss has asked me to find a way to make a word document do the following: Have a check box to click - when clicked this will copy in a bunch of text from another document saved on our server/(insert text from file). Then when unchecked...
  17. K

    MACRO - To run on all worksheets

    (This is my first posting) I'm very far from being macro knowledgeable, however, I did create two small macros that I would like to run on all worksheets, rather than just the active worksheet. And if possible, I'd like them to be the same macro, however, they seem to only work as two separate...
Top