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
0
votes
1 answer

C++ Program crash on ApplyTheme method

I'm learning C++ PowerPoint automation basing on this sample code http://code.msdn.microsoft.com/office/CppAutomatePowerPoint-024b696c/sourcecode?fileId=52793&pathId=1940694257 Everything looks clear to me, but I've got problem when I'm trying to…
Bartek Kozłowski
  • 45
  • 4
0
votes
5 answers

How to read Microsoft Word documents in .NET?

How to read doc, docx file into .NET with C#.
haresh chande
  • 23
  • 2
  • 3
0
votes
1 answer

File Upload Corrupts Word Macros

I have a VB.net program. The user downloads, opens, saves and uploads a word document to the server it was downloaded from. The program I am using to upload my file needs to have parameters passed with it. The program works for about 80% of…
Ehaver282
  • 101
  • 2
  • 14
0
votes
0 answers

Windows Task Scheduler vbs file fails (but runs fine manually)

I'm using windows task scheduler to run the below script file on the event of an excel crash (application event 1000). If I run the script manually, the excel file 'E:\Test.xlsm' opens as excepted. However, when called from the task manager (on…
Yugmorf
  • 320
  • 1
  • 6
  • 20
0
votes
1 answer

Excel VBA Sort - Error when automated from Access 2007

I wrote some code in Excel 2007 VBA, which includes some sorting, and it works fine in Excel. Now I'm trying to get it to work from Access 2007, automating Excel. When I get to the Apply method, I get this error: "The sort reference is not valid.…
Greg Lovern
  • 958
  • 4
  • 18
  • 36
0
votes
0 answers

Silent Printing in Javascript

I want to print a DOCX document silently (without print dialog) in javascript. I actualy have a path of document but i want to print specific pages. Lets say client want to print first page. Is there any way of printing a specific page without print…
Atif Imtiaz
  • 215
  • 2
  • 4
  • 24
0
votes
4 answers

Error 6124 with Word automation

Why do I get an "Error 6124: You are not allowed to edit this section because it is protected." when running this code on certain machines? I do not get it on my development machine. The bookmarks are associated with form fields. Set objWordApp =…
CJ7
  • 22,579
  • 65
  • 193
  • 321
0
votes
1 answer

Creating Dynamic Watermarks for Powerpoint Objects in VB

Dear VB enthusiasts with Office-Automation experience, Context: I am trying to develop a Ribbon Add-In for Office Powerpoint using VB.Net in Visual Studio 2010. Problem: I am trying to add a watermark with dynamic and transparent text to all…
Robert
  • 531
  • 2
  • 7
  • 20
0
votes
0 answers

Add squiggles programmatically in Word

How can I programmatically add Squiggle line under specific words in MS Word using C# Automation? I guess I need to use the Range object, but I couldn't find and method / property that does that. Is there any way of doing this? Thanks!
ml123
  • 1,059
  • 2
  • 12
  • 27
0
votes
2 answers

System.Runtime.InteropServices.COMException (0x80080005)

I am getting the error: System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {91493441-5A91-11CF-8700-00AA0060263B} failed due to the following error: 80080005. for line…
Milind Anantwar
  • 81,290
  • 25
  • 94
  • 125
0
votes
1 answer

How to automate an Excel document and work on other excel document at the same time?

I'm using a program to automate an excel document and in the meantime I would like to open others Excel documents and work on these (not automated). When I open an document while my automation is running, the file I open is frozed and I can't…
user2310493
  • 103
  • 2
  • 7
0
votes
1 answer

Create docx with older msword8.h using Office 2010

When using Office Automation with MFC we have an old application written in Visual C++ that uses the headers from msword8.h of Word97, were are changing our systems to use Office 2010 i would like to know if without updating the msword8 files could…
user1249212
  • 333
  • 2
  • 5
  • 12
0
votes
1 answer

vb .net using excel automation to paste data into opened workbook

Is it possible to paste data into an already opened worksheet using office automation from vb.net? (I done it using oledb but is very slow.) Dim Folder As String = "C:\Users\gm1\Desktop\" Dim Filename As String = "Raw2Eng.xlsx" …
Gergo
  • 3
  • 3
0
votes
1 answer

Setting Excel NumberFormat for Dates ignoring the locale in native C++

I'm using Excel COM automation from native C++. My goal is to set the NumberFormat of a range for dates. The Problem is, the format string Excel expects depends on the user's locale. Example: If the locale is english i have to set the NumberFormat…
Naryoril
  • 401
  • 6
  • 19
0
votes
1 answer

web service MS Word compare automation cause freeze

My WebService uses ms word COM to compare 2 .doc files. When result file is going to be more than 1 Mb - it's hangs up. (for smaller files - everything is ok). It's happens when I publish&run WebService on IIS. (Host under win serv 2008 x64, IIS -…
Aksndr
  • 1
  • 2
1 2 3
…
53 54