Programming

Hyperlink opens word template for editting, not as new document
I have created hyperlinks to Word documents and templates in Excel. Clicking the hyperlinks causes the templates to open in Word for editting. I need to have the templates open new documents based on the templates. How can I do this? ... 2 Feb 2010 17:29

routing slip in 2007
I understand that feature was removed from 2007. Is there any work around? Thanks in adavance, Luis ... 2 Feb 2010 17:29

Pictures/Clipart
Is there a formula or way to return a picture from one workbook to another?(without copy and paste) ... 2 Feb 2010 17:29

OleObject-Preventing deletion
Hello, Is there a way that could prevent the user manually deleting an OleObject (ActiveX) from the ActiveSheet? Thanks Avi ... 2 Feb 2010 17:29

Class Programming
If I know the name of a textbox object that exists on my worksheet, how can I get the value of the textbox object based on the textbox name in my class module? Thanks Steve ... 27 Jan 2010 23:55

How do I draw shapes on a user form? (VBA Excel 2007)
I'm trying to draw shapes on a user form (ie arrows, circles, ovals, etc). Can this be done? ... 27 Jan 2010 17:12

QAT Reference to Macros in Another Workbook Don't Stick
Running Excel 2007 under Vista. I have one workbook which will contain all my data, and a second which contains a set of macros. By adding the second workbook as a reference, I am able to access all of the macros from the first. (I did have to add a dummy macro to the first workbook to get the reference to stick... 27 Jan 2010 14:56

undo a macro
Hello. I am trying to figure out if the condition of a worksheet or workbook can be captured prior to running a macro so that the results of the macro can be undone by using the the undo button. -- Thanks, Mike ... 27 Jan 2010 13:47

Pivot Table Fields
I added a couple of columns to an Excel 2007 spreadsheet. When I went to generate a pivot table, all but one of the fields that I added do not show in the field list. I've refreshed the table, got out Excel & tried again all with no luck. Anybody have any suggestions as to why all the fields are not showing?... 28 Jan 2010 04:15

Help with a macro to display documents
I have the code listed below that searches a folder and if it finds any PDF files its displays them with a hyperlink in the spreadsheet. My problem is that under the MAIN folder I have tons of files now and its very hard to find the PDF I am looking for. I redid my file structure under main and now I have fold... 27 Jan 2010 12:38