• Using macros in Microsoft Word

    How can I use macros in Microsoft Word?

    ashibitiya5 pointsBadges:
  • Excel and Access integration and auto-population

    Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table.  Each site (7 in total) documents their internal defect data and sends it to me weekly.  I then merge all of this data (have been doing so manually) into one spreadsheet to...

    Sm6hans25 pointsBadges:
  • Import text from another excel workbook

    I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to...

    AenE15 pointsBadges:
  • Inserting pre-written parapgraph/sentences, phrases etc into a document

    I saw a Word file which did the following. There was a customized toolbar which popped up. You would place a cursor over the area you want the paragraph inserted, you click on a code letter/number and the paragraph would insrt into the desired location. I feel I'm word savy, i need to know where I...

    Drdreich5 pointsBadges:
  • MYOB open macro causes ‘macro disable’ messages when Office documents opened

    On a system that has MYOB installed every time a Office file is opened a message box appears saying that macros are disabled. I understand that the problem is due to the location that MYOB has used to store their macros. Can I move them and avoid this issue ?

    David995 pointsBadges:
  • How do I get a macro to move between workbooks?

    I have a template (workbook #1) that I would like to copy data out of and paste into the workbook that I run the macro from (workbooks 2, 3, 4, 5...). The problem is that when I record the macro from workbook, excel codes the name of that workbook, making the macro unusable in workbooks 3, 4, 5.......

    Bondsmith5 pointsBadges:
  • Why won’t the macro run in other worksheets?

    I want to make a table as part of a macro. The size of my document changes daily, so even though a choose control end before I make the table, it assigns specific cell numbers which it employs for subsequent runs of the macro. How to I get it to go to the last populated cell in a column...

    Felucha5 pointsBadges:
  • Can data in Excel 2003 be set up to automatically move from one sheet to another in a workbook?

    Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the others we...

    Kaylee5 pointsBadges:
  • Batch file with keyboard commands

    I am trying to create a batch file that utilizes keyboard commands for a Macro on my computer, but I cannot figure out how. Any ideas would be appreciated. The command I am trying to run is alt+S.

    Jab81815 pointsBadges:
  • Auto Capture Macros

    Can Auto Capture Macro programs be detected?

    amdenson10 pointsBadges:
  • New and having a macro problem

    I have set up a simple budget and spending spreadsheet with separate sheets for each month. The sheets are basically the same, columns are the same, but the number of rows may vary. I need to set up a macro that will sort an individual sheet on 3 columns and be able to use it on any other sheet....

    DarbyBrown5 pointsBadges:
  • Email individual invoices

    I have macros in MS Access that email reports to groups of people. I am trying to work a way where I run a macro and it will send the specific report to each person. I have a list of 52 membership invoices that go out annually. Is there a way to get the query or macro to send the specific invoice...

    Greg655 pointsBadges:
  • VBA to copy sent email subject and to fields

    We use a Corel X5 macro along with Outlook 2007&2010 here to send or "export" drawings from our art dept to the sales dept. The macro creates an email with the attached sketch and subject line filled in. I need to modify it to save the current sent email, subject and "TO" fields to a text file....

    swinehart68031,050 pointsBadges:
  • Microsoft Access 2010 DB Macro that allows a count of a date filter, and an email to be sent

    Hello, I was wondering if, within Outlook 2010, is it possible to have a script run that runs the date filter command within Access,displaying the weekly total number of values logged within the Access database. Once it pulls that value, I then would like it to send an email saying the count to a...

    Chris311fan5 pointsBadges:
  • Macro Script on AS/400

    Hi, Currently We are getting a Report on Monthly Basis using Macro script which runs manually on next day to monthend. Now, We have requirement for generating the Report on Monthend Date itself as part of over night process. Is there anyway to automate the Macro Scripts in AS400. Please suggest....

    deepu93214,290 pointsBadges:
  • Macro or not???

    I have a spreadsheet for a team of agents stats, the front page has agents along the top and stats down the left hand side. Each subsequent tab has that agents stats down the side and each column is the progressing weeks and a tab for the team which collates the agents info in to team figures...at...

    Malciebhoy5 pointsBadges:
  • Using macros in Lotus Notes

    Does LN have the ability to record and run macros? In other words can LN automatically "record" a series of rote tasks and write a macro that can be run, in much the same way that excel can? If so can someone instruct me on how to do so? Thanks

    cmk150 pointsBadges:
  • Excel 2003 Macros with Org Chart Parent

    Hello, I have a corporate org chart for which I am trying to write a macro. The Excel workbook is set up so that each company is in a unique cell. The subsidiary is one column to the right. For instance, I would like to return the values in the far right column for the data below. Thank you. COL  ...

    Vanillathunderrr5 pointsBadges:
  • Create a macro in Excel 2007 to disable save

    I need to create a macro in Excel 2007 to disable save

    Basilmartin5 pointsBadges:
  • Macros in a drop down list

    How can I get macros into a data validation list so I can select a macro to run from that list.

    Excerlnovice15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following