office-2007 Questions
5
Solved
Let's say that I've got a sheet - number one - with over 5000 rows (say, columns 'A' - 'H' each).
In another sheet - number two - I have a "to-remove-list" - a single column 'A' with 400 values, e...
Hawkinson asked 12/9, 2012 at 17:33
3
Solved
I am developing an application for automatic Excel to PDF generation. Every now and then (and without any apparent cause, the following popup comes up while the program runs:
Print driver host f...
Mobcap asked 24/7, 2014 at 14:38
4
Solved
What's the "best" way to read (just read) an Excel file from within an Access 2007 application. I only want to loop trough the rows and put the data into an Access table.
I don't want a manually i...
Ague asked 25/5, 2010 at 14:20
5
Solved
In a VBA module in excel 2007, is it possible to call a web service? If so, any code snippets? How would I add the web reference?
Vezza asked 23/1, 2009 at 22:49
4
Solved
I have an excel 2007 file (OpenXML format) with a connection to an xml file. This connection generates an excel table and pivot charts.
I am trying to find a way with OpenXML SDK v2 to do the same...
Mudskipper asked 11/10, 2010 at 5:25
8
Solved
Given
Select Case cmd
case "ONE": MsgBox "one"
case "TWO": MsgBox "two"
case "THREE": MsgBox "three"
End select
My requirement is if cmd = "ONE" I need "one" and then "two" displayed howe...
Piety asked 12/10, 2009 at 21:1
6
Solved
I am beginner in using Microsft.ACE.OLEDB 12.0. I create a Winforms application VS 2010.
And create a function for export data grid data to MS Access file. I using Microsoft Oledb
for export the ...
Ecstatic asked 18/7, 2013 at 6:34
5
Solved
I'm attempting to open a Word document, change some text and then save the changes to a new document. I can get the first bit done using the code below but I can't figure out how to save the change...
Unduly asked 11/1, 2012 at 11:4
6
Solved
I built an add-in for Microsoft Office Word. There isn't an issue using the add-in when Word is ran as Administrator, but when it's not ran as an Administrator, there are two common exceptions acce...
Kristiekristien asked 18/10, 2012 at 14:55
4
Solved
I'm considering replacing a (very) large body of Office-automation code with something that works with the Office XML format directly. I'm just starting out, but already I'm worried that it's too b...
Wortham asked 25/1, 2012 at 15:3
4
Solved
Is it possible to use the Open XML sdk to manipulate parts of document which is currently open in the Office app (word/ppt). I know the easiest thing is to use VSTO, but its slow and would involve ...
Outguess asked 14/3, 2010 at 13:18
6
Solved
I have an Outlook add in written in C#.
I was wondering how or if I could get the email address of the current user?
Thanks
Ultramontane asked 21/1, 2011 at 16:59
1
I am using the WPF ribbon CTP from Microsoft.
However, there is no sample. I am not sure where to start. The RibbonWindow does not have a property for the Ribbon. Does anyone have a sample that wor...
Berlauda asked 7/7, 2009 at 22:14
1
I'm trying to choose between ClosedXML, EPPlus, and possibly SpreadsheetLight. What reasons might I consider for picking one over the others?
Flagstaff asked 8/5, 2012 at 15:19
5
Solved
A process to quickly detect whether there is data in a given worksheet or not, without actually looping through all of the rows/columns of the worksheet.
For my current process, I am currently loop...
Numidia asked 27/2, 2010 at 12:22
4
Solved
I have developed a simple C# Winforms application that loads MS-Word 2007 documents via COM automation.
This is all very simple and straight forward, however depending on the document I need to p...
Plush asked 21/10, 2009 at 12:32
7
I know this is probably not the right place to ask this question, but I don't know where else to turn. I tried google, but it hasn't helped me this time.
I have Visio 2007 Professional. I am tryin...
Kathernkatheryn asked 19/11, 2010 at 0:10
1
Solved
I'm trying to implement a private subroutine to add a Sheet to the active workbook (Sheet being used so that one can choose to add xlForms, xlWorksheet, etc).
But I'm having a bizarre problem wit...
Aenneea asked 11/2, 2014 at 2:7
2
Solved
I'm trying to install Interop Assemblies for Microsoft Office on my web servers,
for the use of reading word documents from my site.
Can I install just the Assemblies?
Or the only way is installin...
Aerosol asked 14/3, 2011 at 17:31
2
Solved
I have an Excel worksheet that acts like an application, with form control buttons allowing users to 'navigate' through records. First, Previous, Next & Last cycle appropriately through one of ...
Gallinacean asked 14/6, 2013 at 15:9
4
I found a lot of nice icons from Microsoft Office 2007. Do you any idea for extract & save all icons as PNG files by using VBA?
Partial ImageMSO http://rabu4g.bay.livefilestore.com/y1p2SF1q63Y...
Lepidosiren asked 2/7, 2009 at 9:12
3
Solved
I am try to exporting datagridview data to excel file in my C# 4.0 Windows application.
we used Microsoft.Office.Interop.Excel dll version 12.0.0.0. It's works well and everything
is fine. But i...
Jonna asked 13/6, 2013 at 8:33
2
Solved
Oki, so im working on outlook .msg templates.
Opening them programmatically, inserting values base on what's in my db.
ex. when i want to add multiple reciepients at "To" field, instead of doing a...
Brandish asked 22/5, 2013 at 12:32
4
Solved
Where do I find helpful documentation for VBA programming? something like SitePoint for HTML development.
MSDN simply lists down and describes the operation and properties/methods of classes ...
Kerguelen asked 9/10, 2009 at 12:13
2
I want to disable "bold" toggle button in an Excel sheet.
How can I do it?
I have the following code but it's not working:
CommandBarControl test = excel1.Application.CommandBars["Formatting"].F...
Discrimination asked 26/11, 2012 at 12:45
1 Next >
© 2022 - 2024 — McMap. All rights reserved.