• 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:
  • 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....

    deepu93213,695 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:
  • 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:
  • 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:
  • How to accept user input and display the value in Excel 2007 macros

    I Created an Excel macro that prompts the user to enter two cell numbers. I want to then display a msgbox back showing the cells that were entered. Problem. My msgbox shows the text in my message and instead of showing the values the user entered, it shows 'TRUE'. Any ideas?

    jkeri355 pointsBadges:
  • Excel macro – create a chart

    I created a macro that reforms my data and creates a chart. Teh macro also includes selecting a chart layout that has an x and y axis field that I want to enter in some text. My macro works all the way except it does not record the content I put into the X and Y axis.   Why is that? and how can i...

    jkeri355 pointsBadges:
  • iSeries Access Macro to run from a program.

    I think I've asked the same question some months ago but didn't get any answer and couldn't be able to find one myself. The issue is: i have an iseries access macro that i run every day, but I do it from the Play button in the access menu. I would like to put this macro in a common directory (done)...

    Mawc10 pointsBadges:
  • Should I disable macros on a network-wide basis?

    Just wondering if it is generally a policy to disable macros from Word, etc. Is there a safe macros list or should they all be disabled? How would I go about doing this across the network?

    TeachMeIT975 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