40 pts.
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...
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...
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?
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?
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...
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...
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...
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...
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 ?
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 ?
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.
How can I get macros into a data validation list so I can select a macro to run from that list.
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,...
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,...
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.
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.
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...
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...
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...
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...
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?
in a folder or drive how can I find which excel spreadsheets contain macros without opening every one individually?
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...
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...
Updating textboxes on a Userform
How can I get real time information in a text Box on a userform when a macro is running
How can I get real time information in a text Box on a userform when a macro is running
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...
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...
New to macros (probably a simple question)
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...
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...
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...
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...
Crystal - number of printed pages based on database field
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'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...
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,...
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,...
Word macro to toggle tracked changes after running an "update fields"
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...
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...
