Search results for query: *

I have a template add-in in the startup path for MS Word 2003 (SP3). If I have a user with Outlook set to use Word as the email editor, this affects the template add-in for Word. If Outlook is loaded first, followed by Word, the template code does not fire. However it works correctly if Word...

You probably need to recalculate those cells in order to refresh (one of the down-sides of a custom function).

No, should be fine for just a single cell. Maybe try it first on another example. Start a new workbook and copy and paste the code into it. In cell A1, type the word "Test". In cell A1 again, press Ctrl+K to create a hyperlink, and enter a valid web address in the Address section. In cell B1...

Your formula should be "=GetLink(cell)", where cell is the cell address containing the hyperlink.

Where did you paste the code? * Open your workbook * Press Alt-F11 to go to the VBE window * Make sure the Project Explorer is displayed down the left - you should see "VBAProject (YourWorkbook)". If not, select View | Project Explorer * Insert a module into your workbook by selecting Insert |...

Create a function in the VBE window of your workbook as follows: Public Function GetLink(rng As Range) GetLink = rng.Hyperlinks(1).Address End Function In your worksheet, your formula would be "=GetLink(A1)", assuming that cell A1 contains the link.

Put any controls you want "frozen" in the form header.

If you don't want zeros to appear, select Format | Cell | Number. Change Category to "Custom" and enter your format. The way the number formats work is you specify a format for positive numbers, a format for negative numbers, and a format for zero (there's probably more, but this covers the...

Also, you don't need to select the cell before clearing the contents.

I ended up creating a calculation workbook (actually 3 of them due to file size) using SUMPRODUCT, then DSUM on the report to consolidate the results and allow the required flexibility. The workbooks are set to manual calculation so changing the criteria on the report calculates the active sheet...

Did you find the solution for this? I'm looking to do the same thing!

Hi Neil, Nope, already tried this one. I was eventually able to work around the problem by copying all cells in the sheet, pasting into a new workbook and saving the file. In fact my code now tests the file size and performs this procedure when the file size of the template exceeds 1MB. The...

Dickx, just found the following knowledgebase article which solves the restriction I mentioned above: http://www.vbaexpress.com/kb/getarticle.php?kb_id=365

Copy the following code to the worksheet Selection Change event. Dim rng As Range If ActiveSheet.AutoFilterMode = True Then For Each rng In Range("A1", Range("A1").End(xlToRight)) With ActiveSheet.AutoFilter.Filters(rng.Column) If .On Then...

I came across the same problem, but in a worksheet being formatted via VBA. The number of columns is dynamic, so setting a specific value doesn't work. However so far the following has been successful: ' page setup With ActiveSheet.PageSetup .PrintTitleRows = "$1:$2"...

I've been given the task of providing recommendations for upgrades to an Access 2003 database that links to SQL Server data. I have one user in particular that is bypassing the Access application and creating his own, directly linking to the tables. What I want to do is allow read/write...

YoungCougar's suggestion will work for a quick and dirty option, however you'll probably need to build in some shortcuts for inserting the current time and selecting an activity (Phone call etc.). For the time option you could create a macro (and attach it to a shortcut keystroke) where the...

I think you're looking at building a custom application for this, or perhaps investigating some off-the-shelf software - Outlook is not going to do it for you [sadeyes]

Do you know roughly how long you were editing the form? You won't see any duration displayed until you have been running the timer for at least a minute. I ran the export in Outlook 2003 and the Duration field was included - which format did you export the data to, and what version of Outlook...

What you need is the Journal. When you insert a new Journal entry, you'll see there is a "Start Timer" and "Pause Timer" button. This allows you to record the duration of the item (such as telephone calls and meetings). You can link a Journal item to a Contact, but I'm not sure how you'll go...