Is there a speed issue that anyone has run into with vba code that performs as expected when debugging but doesn't when ran normally. For word, I created code to create/format three text columns and manipulate a paragraph's before and after spacing as the document is populated with text. It...
I have a template in my Word Startup folder. Everything works fine but one of the button's tooltip was the macro module's name. Microsoft KB indicates that one can only change the tooltip by using some VBA code as follows:
Sub ChangeToolTip()
With CommandBars("Standard") ' The toolbar...
I thought I could enter my own descriptive tooltip for a custom Word toolbar button by simply selecting Tools > Customize and then right clicking the button and entering the short description in the Name field. However, it just defaults to the name of the module. And, changing the module name...
A protected project I'm using in Word displays "Reached bottom of list" in a message box. I want to incorporate that message as part of my error checking for another macro that'll exit when that message is displayed. If the project wasn't protected I could probably just incorporate its error...
Besides the default tasks created by SBS 2003 upon installation I've scheduled a vbscript task and another database application specific task. With the exception of the db task they run as expected. The db works when I run it manually from the task's properties. However, I'm finding that when I...
Hopefully someone can render some help here...
I'm importing a comma-delimited text file with each row containing a unique numeric identifier for each customer along with an account value among many other items. A customer may have more than just one account so I need a way to sum the value of...
I have a text file that contains three lines and is formatted as follows:
"Prefix","Sequential #","Ignore this Field"
"Ignore this Field"
"Ignore this Field"
The following code is meant to read the whole file and increment the sequential number by 1 and write out all three lines - I hoped. It...
I'm trying to get my head around writing to a specific field. My text file contains 3 rows of info. The first row contains three fields comma delimited while to second and third rows only contain one field per say. Example:
"Prefix","Incremental #","ignore this field"
"ignore this line"
"ignore...
I'm looking for assistance in creating a "selection criteria" or filter of sorts that would limit the report results to names contained within a csv file. More specifically, using RS i'm generating a report with various selection criteria. This report is for the most part a standard report...
I'm hoping that there may be a member here that is using v3.03 that came bundled with the contact management software Maximizer v7.0. My question is:
In accessing a RS report via Maximizer - despite Maximizer prompting the user whether the report is for the current record or all records in the...
For purposes of security, continuity and simplicity I would like to do the following on a workbook in which I've enabled security measures for both the underlying VBA and formulas.
1. Disable the File/Save option to prevent users from having multiple copies that would eventually become...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.