• 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,605 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:
  • 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?

    jkeri360 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...

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

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.

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

Following