• 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:
  • 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:
  • Date Range in Excel Macro

    Hi, I just want to know if its possible to do a macro wherein I can select the dates to be read in my report. For instance, I have a Table (below) where column A is the Date, column B is the name of Agents, Column C is the Section and the Column D is the Error Category. A window will pop-up where...

    Eron09135 pointsBadges:
  • converting a macro

    can a macro made in WordPerfect be converted over to Word?

    Tootsie8815 pointsBadges:
  • SAS date macro variable

    Hello, i'm new in SAS I'm writing this code below :     data _test_ ; d1 = put(mdy(month(today())-   1,1,year(today())-1),yymmdd10.);     call symput('d1',"'"||put(d1,9.)||" 23:59:59'") ; d2 = put(mdy(month(today())-   1,1,year(today())),yymmdd10.);     call symput('d2',"'"||put(d2,9.)||"...

    Iamjeannie30 pointsBadges:
  • Macro date a year from today

    Does any know how to create a year date from today ? for example today = 9/3/2010 I would like to get the macro variable that give 9/1/2009

    Iamjeannie30 pointsBadges:
  • Conditions in Automation Macros

    I am trying to figure out how to make a condition in an automation macros that says If [Forms!testing!hc leader] = (Leaders name) then open (query name) and apply output to (report name). Can anyone help me? The parentheses are not in the macros that was put there for this question. Thanks!

    ConfusedAccessUser5 pointsBadges:
  • Business Process Automation tools

    What tools do you use in your department for business process automation, eg, running reports, executing macros, etc. What are some of your go-to solutions?

    JennyMack4,280 pointsBadges:
  • Making a macro in as400

    how to make a macro in as400

    Ritug40 pointsBadges:
  • Hide macro

    I want to use a macro that will hide rows in the range of 17 to 61 where a value in column B is 0 on a protected sheet.  This has to be automatic (multi-user friendly) rather than using advanced filtering.

    Drroadrage5 pointsBadges:
  • Running macros when the reset key is locked

    include the [reset] function in a Macro to reset the operator input error   I was trying to include the [reset] key in my macro to "unlock" the keyboard and continue the macro. Can this be done? Or is there a setting I need to play around to allow macro's to run when the key is...

    AS400 - Ask the Expert485 pointsBadges:
  • Office Groove- Macro help

    I am new to Office Groove and i can't find any groove macro samples out there to work from. I am trying to make a macro that goes through the rows of specific columns and finds the ones that are empty. Then it counts how many of them are empty in the specific column and then outputs the number to...

    Dug50 pointsBadges:
  • MS-Word macro “step into” button

    Greetings! In Word 2003, I'm trying to trace the execution of my macro to look for an apparent bug. The macro window has a button called "Step into" that I thought would display a step-by-step trace of the macro, but all it appears to do is open the macro in edit mode and place the cursor on its...

    BruceDLimber20 pointsBadges:
  • Import data from Lotus notes into Openoffice

    I've found many articles on the web of how to manipulate Open Office from the outside, but what I need is to manipulate the outside from within Open Office. We have some spreadsheets which have macros that connect to a Lotus Notes database using COM and we are looking into porting them over to Open...

    Silvius5 pointsBadges:
  • Outlook 2003: trim leading spaces from email subject with VBA macro

    Hello, some email clients send emails with an extra leading space added to the subject. As a result message sorting on subject in outlook 2003 does not work correctly: these messages are considered to have a different subject and so the entire conversation is split in two seperate conversations,...

    Slay40 pointsBadges:
  • new to macros – extracting data

    Hello, I'm just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box(course...

    Oistins2610 pointsBadges:
  • find which excel spreadsheets contain macros

    in a folder or drive how can I find which excel spreadsheets contain macros without opening every one individually?

    FreemaG5 pointsBadges:
  • New to macros

    Hi, I'm just learning how to use macros and the first thing I'm trying to do is create a macro that will pull a character from a cell and place it in a new cell- for example "right(c10,1)". My problem is I have a large list that I want to do this with but everytime I click on my macro button it...

    Buyer5 pointsBadges:
  • Updating textboxes on a Userform

    How can I get real time information in a text Box on a userform when a macro is running

    Alanr5 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