Stack Overflow
Stack Overflow

Questions tagged [office-automation]

Use this tag for questions related to automating MS Office Products ( Excel, Outlook, PowerPoint, Access, Word, Project, etc. ). Automation in this context means the use of an external software, not an MS Office product, to execute a variety of operations on MS Office products. For questions about macros use the relevant tags for example "excel" and "vba". Do not use this tag if your question is not about automatic control.

Automation in this context means the use of computer systems to execute a variety of operations such as word processing, spreadsheet calculation, database manipulation, etc. without user interruption.

If you have a specific programming question about Excel or Word (or any other product from the MS Office package) and it is not about automating it via external software then use tags like , , , etc.

805 questions
2
votes
1 answer

When calling Excel from VB.NET app, how do I make Excel appear in front of app?

I have a VB.NET application that uses Microsoft.Office.Interop.Excel to simply open up a spreadsheet, pump over some data to it, refresh the data in the pivot tables and then present the user with the spreadsheet. The code is pretty simple (error…
Tall Tyke
  • 171
  • 1
  • 3
  • 14
2
votes
0 answers

Get running instance of application from WMI process?

I'm trying to get hold of running instances of MS Access 2010+ (on Win10) but the usual tip; GetObject(, "Access.Application") ... for works only for hidden instances started by myself with script, but not any instances started from GUI by the…
RIL
  • 185
  • 2
  • 11
2
votes
1 answer

Determine if Outlook is available for automation

I have a module that will automate Outlook but it should be skipped if Outlook isn't available. Simply checking whether Outlook is installed is not sufficient because if there is a fresh Office install, launching Outlook will simply launch the…
this
  • 1,406
  • 11
  • 23
2
votes
1 answer

Is it possible to generate a PowerPoint roadmap timeline from C#?

I know PowerPoint has an API like Excel and word. Is there anyway to generate a timeline roadmap programatically (I have a list of milestones and dates from a database)? Does anyone have any links or example code on how to get started on trying to…
leora
  • 188,729
  • 360
  • 878
  • 1,366
2
votes
2 answers

Outlook/Exchange - how to programmatically export users in distribution list?

How do I export all of the names and email addresses from a distribution list in Outlook using code? I have access to an Outlook 2000 or Outlook 2007 client. Ideally I would like the code to be in C#.
Brian Lyttle
  • 14,558
  • 15
  • 68
  • 104
2
votes
1 answer

Excel Automation Addin - functions not working

Edit: The real solution to what I wanted to do can be found on this post here. I just wanted to expose some compiled functions to excel. This proved to be very easy using the Excel DNA nuget package. You just add a class library, add the nuget…
gerodim
  • 131
  • 8
2
votes
1 answer

Calling to Word Application after closing it manually produces "RPC server is unavailable" error

I have TWordApplication named App component on my form. It's ConnectKind property is set to ckRunningOrNew and AutoConnect property is True. When my procedure finishes, Word window appears on screen and after doing some tasks I close it. Next call…
Danatela
  • 349
  • 8
  • 28
2
votes
2 answers

How to Force Word to Embed Images when Converting from HTML to RTF?

I'm using Word's automation features to convert an HTML file with images into an RTF file. Problem is that Word does not embed the images in the RTF file, instead using INCLUDEPICTURE to reference the images externally. The knock-on effect of this…
user1793036
  • 199
  • 1
  • 8
2
votes
2 answers

Word Automation with ASP.NET

I have an old application that uses Microsoft Word automation in asp.net and I need to install it on a Windows Server 2012 R2 x64 with Office 2013 Standard x86. I know that Office automation in server technologies like IIS should be avoided but I…
Vladimir
  • 1,425
  • 16
  • 31
2
votes
1 answer

VBA Automation Error (System call failed) while running Excel 2013 macro from Access 2013

I have an Access (2013) database that I use to store/process all of our data received from a Qualtrics online survey. The raw data downloaded from Qualtrics is in a csv file that's poorly formatted for importing to Access, so I've got a fairly…
Jack
  • 23
  • 1
  • 3
2
votes
1 answer

Where can I find the MS Office Interfaces to do some automation in C++ and COM

I have found the file MSPPT.OLB, but not able to open it with Oleview.exe. Isn't this documentation there on MSDN, all I can find is C# interfaces. (May be I have missed/ or not a very good user of google)
user2783263
2
votes
1 answer

creating a recursive flowchart in visio with c#

I've managed to learn enough about programmatically authoring visio diagrams to create shapes with custom properties which I can use to populate a diagram. I can connect the shapes with dynamic connectors and get visio to lay them out…
Todd
  • 140
  • 9
2
votes
1 answer

Adding picture to powerpoint slides via C# throws The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

Hie guys, I have a block of code here: System.Net.WebClient wc = new System.Net.WebClient(); byte[] data = wc.DownloadData(xmlTempNode.Attributes["imageurl"].Value.ToString()); MemoryStream ms = new MemoryStream(data); System.Drawing.Image img =…
Milind Anantwar
  • 81,290
  • 25
  • 94
  • 125
2
votes
2 answers

Write formula with double quote symbol in Excel with C#

I would like to write a formula in a Excel cell. I managed to write simple formula but I have an issue with the following formula : =IF(OR(ISBLANK(I20631);ISBLANK(F20631));"";I20631=F20631) In my C# programm it tried this…
user2310493
  • 103
  • 2
  • 7
2
votes
1 answer

Word Interop Move Table Row

Does anyone know a way to move a row in a table? I have a table with dynamic number of row, that I want to manipulate by code (interop c#). For example I want to move the row with the index 5 to index 8 or the other way round (index 8 to index…
Tobias
  • 2,945
  • 5
  • 41
  • 59
1 2 3
…
53 54