Dynamic Image references in a cell 0 314 (11/17/2009 5:52:31 AM)
I am exporting a report from Access 2007 to Excel 2007 containing product information. I have an image for each product. Access does not export Images to Word or Excel. I have the URL or local path for...
Utf

HELP: Export data to word template and save it as a seperate file 0 171 (11/17/2009 5:26:03 AM)
Hi All, I want to export details from excel userform to a word template and save it at a different file. So basically once the user clicks the Export to word button this should happen: -Opens up a dia...
Utf

HELP: Trying to a word template with name from userform at a diff 0 137 (11/17/2009 5:25:22 AM)
Hi All, I want to export details from excel userform to a word template and save it at a different file. So basically once the user clicks the Export to word button this should happen: -Opens up a dia...
Utf

code to sum 8 textboxes 5 134 (11/16/2009 12:59:02 PM)
Hi there, I am trying to get a text box (txtsubtotal) to sum 8 other 'price' text boxes (txtprice1...txtprice8) when a command button (cmdCalculate) is clicked. Each 'price' text box is filled via a combo ...
Utf

what type is calendar control 6 175 (11/16/2009 1:55:00 PM)
running Excel 2003 (going to 2007 in the next few months) I have inserted a pop-up calendar (Insert/Object.../Calendar Control 11.0). No problems getting it to do what I want - except when I declare my var...
c1802362

PivotTableWizard 0 304 (11/16/2009 11:40:21 PM)
I am calling Excel to hold a series of database data and then create a pivot table from it (VB from Visual studio 2008 using office interop). Works fine on my development and test boxes (both have Office 2...
Don

Display ranges from one worksheet to another 2 414 (11/16/2009 9:16:11 PM)
I am running excel 2003. I have been given the task of creating a workbook where on one main sheet I want to display named ranges from up to 4 other worksheets based on the user selection. The ranges are...
Opal

paste linked cells show "0" 6 1444 (11/16/2009 6:49:26 PM)
I have a number of cells in a range (lets say A14:J52). Some of these cells are "paste linked" from cells on other sheets. Unfortunately, when the original cell is empty, the value of the "paste linked" ce...
Doug

Should be an easy but I can not figure it out!! 12 162 (11/16/2009 2:01:07 PM)
I have a text box where the user enters a date and it is assigned to variable txtDate. How to I convert that to the serial number of the date? Thanks for the help ...
Utf

Copy only visible cells after applying "Subtotals" 2 286 (11/16/2009 6:04:59 PM)
Hello, in an XL-list I need to copy only a block of subtotals to another area, without the detail rows in between. I believe there once was a command like "paste only visible cells" (or similar), but I c...
H