Programming

Performance issue with accessing Microsoft.Office.Core.DocumentPro
Hi, I have a Excel COM addin which reads the CustomDocumentProperties section of a workbook. This is how I access a particular entry from the CustomDocumentProperties section DocumentProperties docProperties = (DocumentProperties) xlWorkbook.CustomDocumentProperties; doc... 21 Jan 2010 11:12

Oh look...the forum is not working again. NOT SURPRISES!!!!!
-- Cheers, Ryan ... 21 Jan 2010 10:04

Code for emailing Excel workbooks will only attach activeworkb
sw(a)fdc.com Y s:\Fin\Temporary\December Report - Zone 1.xls ab(a)fdc.com Y s:\Fin\Temporary\December Report - Zone 2.xls cd(a)fdc.com Y s:\Fin\Temporary\December Report - Zone 3.xls ef(a)dc.com Y s:\Fin\Temporary\December Report - Zone 4.xls and so on… and so on… Ok, I get a "path not found error". It isn't code that... 22 Jan 2010 17:29

Workbook BeforeSave
Is there some way to prevent saving under certain conditions int he workbook_before save method? Thanks, Barb Reinhardt ... 20 Jan 2010 16:19

When does conditional formating fire?
Hi I pull in data via some DDE links and my conditional formating does not change until I modify the sheet in some other way. How can I get conditional formating to fire after an update from my DDE links? ... 20 Jan 2010 15:12

One range inside another, Intersect
After I had the same situation, and reading some posts about checking to see if the cells in one range were contained in another range, I wrote the function below. It returns the boolean True or False value, and optionally, if range A is not entirely within range B, the first failing cell is returned. Publ... 20 Jan 2010 11:48

VBA Custom Toolbar
Win XP, Excel 2003 Assuming there is one, what is the extension of the file containing VBA Custom Toolbars and where is it located. donwb ... 20 Jan 2010 12:56

Shortcut key and UserForm
I want to use a shortcut key (Ctrl+z) to activate a UserForm but don't know for sure it is possible or how to go about it. I've always used a Command Button or a _Click() in the past. Any ideas on how to go about this? Thanks in advance. ... 20 Jan 2010 11:48

Querying Data from Access
All, I am using the charting features in Excel 2007 to build various charts from data stored in Access. I want the user to be able to select the Region, Country, or Site that he wishes to see data for, along with a range of dates. I have queries in Access that will summarize the data the way I need it. What I... 20 Jan 2010 10:39

Conversion from 123 to Excel
I just want to give a public thanks to all the people that give advice on here that is given to me and others on these boards. Because without this help I wouldn't have been able to convert the last company's report from 123 to Excel. You folks on here are awesome. Thanks again Steve ... 20 Jan 2010 08:25