Office 2003 automation: dll built VB VS2005 in Office 2003
Wed, 24 Sep 2008 02:43:01 -0700
Hello! Please, help with VS2005-Office2003 automation.
I built very very simple project in VB VS2005 and compiled it to 'Release'
dll.
The VB project in VS2005 has COM class (and also option COM-visible checked).
After that, I add a reference to the built dll in Office 2003 (Excel or Word).
Now, I create n ...
|
MODI Document Images from System.Drawing images?
Tue, 16 Sep 2008 12:14:12 -0700
When working with the Microsoft Document Imagining (MODI) API, does anyone
know if it is possible to load .Net bitmap objects directly into the MODI
document images collection? Or is the only way to use MODI is to call the
document.create(filename) method?
Thanks! ...
|
How to control the OLAP Cube Value updating in Excel 2007 Workbook
Tue, 16 Sep 2008 09:11:01 -0700
I have a Excel 2007 worksheet that makes a connection to a OLAP Cube on a
server.
When I change a cube member, i.e., a parameter, the cube values update
themselves automatically.
When the parameter change is made programatically, the program execution
will NOT wait for the cube values to resolve before m ...
|
Fetching all calendars from outlook 2007
Tue, 16 Sep 2008 02:24:00 -0700
Hi all,
In outlook 2007 we can create multiple calendar for a user. library
Microsoft.Office.Interop.Outlook is provided to fetch outlook data. i used it
to fetch multiple calendars but could not succeeded. i was doing:
Outlook.MAPIFolder outlookFolder =
outlookNS.GetDefaultFolder(Outlook.OlDefaultFolder ...
|
Late bound event handling
Mon, 15 Sep 2008 12:19:02 -0700
Hi
I am writing an Excel addin using Visual Studio 2005 via the Shared Add-in
project. I understand that I can handle the WorkbookOpen event of Excel by
the following:-
Imports Microsoft.Office.Interop.Excel
Dim WithEvents objExcel as New Application
Public Sub objExcel_WorkbookOpen(wb as Workbook) Handl ...
|
How to access properties with array?
Thu, 11 Sep 2008 01:55:01 -0700
Hi
I am trying to create an automation program for Excel.
I have found this article
http://support.microsoft.com/kb/216686
and everything works fine.
But there's one problem. I need to access "ID" property of a cell, not just
a "value".
For "value" property, I can read and write with array, so it i ...
|
Opening files using VBS
Wed, 10 Sep 2008 08:05:02 -0700
I found a thread regarding opening an MDE using some VBS code. My problem is
that I'd like to open the file using Access Runtime.
I can open the MDE using a shortcut I created
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /runtime "actual
file path"
But, even though I can open it, no one else ca ...
|
|
|
C# inserting PageBreaks
Wed, 10 Sep 2008 07:34:01 -0700
What I am trying to do, is accurately place page breaks after certain
conditions.
The following only works at placing the break last, no matter how many
paragraphs come after it in the code:
[code]
object oPageBreak = Word.WdBreakType.wdPageBreak;
wrdRng[cvg] = aDoc.Bookmarks.get_Item(r ...
|
How to open Password Protected PPT File
Tue, 9 Sep 2008 05:05:42 -0700 (PDT)
Hi there,
I dont know if this the right forum to ask this question or not? If
not, please guide me through.
If yes,
I need to supply password to PPT file progrmatically.
I am using Office Interop and .NET 2.0 (C#)
I am coding like this:
ApplicationClass appPowerPoint = new ApplicationClass();
Presentation pr ...
|
Outlook 2007 - POP fails after Exchange Disco/Reco
Sun, 7 Sep 2008 21:05:01 -0700
This doesn't relate specifically to automation, but as it is an issue
affecting my development, I decided to post here.
I have an Outlook 2007 client set to connect to an Exchange mailbox and 3
POP mailboxes. The POP accounts deliver mail to the Exchange mailbox, not to
.pst files. Every night a backup rout ...
|
