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...
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?
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...
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...
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 ?
How can I get macros into a data validation list so I can select a macro to run from that list.
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,...
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.
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...
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...
in a folder or drive how can I find which excel spreadsheets contain macros without opening every one individually?
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...
How can I get real time information in a text Box on a userform when a macro is running
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...
Cell c4 and c5 have check boxes. Cell E4 has a number. Cell F5 has a number. Cell E6 and F6 are blank but is where I want to total a the column. If the check box in cell C4 is checked then the check box in C5 cannot and vice versa. If the check box in C4 is checked it will add the number in E4...
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...
I'm relatively new to Crystal Reports, and most of the reports I’ve written are in Ver 7.0, I do have Ver 11, I have not done much with it yet. I have a Crystal Report that is used to generate a shipping label from a packing list in SQLBase. Most of the packing lists have more than line one...
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,...
I have a macro that will turn off track changes (if they are on or leave them off if they are off) and then update the field codes in the document. Now I need to know how to return the document to its original state after it runs the update portion of the macro (track changes back on if they were...


