add watermark to powerpoint
I want to add watermark to powerpoint file from c# by using powerpoint object library but I could not find any example/documentation which explains how to do it. Is it possible at all? Any hints or suggestions? ...
office-automation
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 programatically fill out a timeline roadmap template in powerpoint Here's a (not great) ...
MS Access 2003/2007 VBA - How can I take a date field from a recordset and string the dd-MMM-yyyy format?
i have some VB that uses DAO to grab some data, one field being a date field (as in date of a transaction). its not date/time, just simply date like dd/mm/yyyy. so on an access form i know how to do this, but right now i am working on some excel/ppt automation. i use something like this simple example DAO sql string, openrecordset to ge...
Copy Excel Worksheet from one Workbook to another with Powershell
Hi, I'd like to copy (or move) a worksheet from one workbook to another workbook with Powershell. I had done this before and cant remember how. I think I used CopyTo() funtion. Just to get started. $missing = [System.Type]::missing $excel = New-Object -Com Excel.Application $wb1 = $excel.Workbooks.Add($missing) $wb2 = $excel.Workboo...
How to compare 2 excel sheet column values
I have 2 Excel sheets (using Excel 2007) Excel sheet1 with column names name kumar manu kiran anu Excel sheet2 with column names name kumar anu I will upload the sheets and then I click on a button (here I will compare the names columns from each sheet) then I need to add the names missing from sheet 2 to a...
Automatically adding rows to excel file template
Hi, I am running .net 4.0 asp.net app on IIS 7. I want to know if there is an easy way of adding rows to an excel 2007/2010 (not too fussed) template file that a user can download from the server. For example, the user might check a couple of tick boxes and clicks a button on the web page. The server does a sql query on a table and com...
Enabling MS-Access functions to be called from a VBScript With only Run-Time installed
Specifically, I'm running into this. I want to call a function that resides in a MS-Access mdb file. Unfortunately, the box that it's going to be run from (Windows Server 2003) does not have Access installed on it. I installed the runtime environment onto it just fine and it can open up the file normally and everything, but it can no...
Ruby Office Automation - cannot get event handlers to work in MSWord
Ruby version 1.9.1p430 running on W7 with Office 2010. I am trying to catch the DocumentBeforeClose event but I cannot even get close to get it to work! I have followed some examples using Excel where the SheetSelectionChange is handled. It works without any problem. Using the same process, I wanted to handle the above Word event. My...
what approach to use instead of server side Office automation for importing tasks from MSProject
I have to open up MSProject file from a different Sharepoint site and ensure that all the tasks are read from the file and bound to ASP.NET Grid. I have used the office Interop assemblies and have encountered some errors. I also came to know that Microsoft doesn't support server side office automation. Is there any recommended way of ...
EXCEL AUTOMATION IN .NET ( COM Error )
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154. i don't have ms-office in my system. I added the reference 'Microsoft.Office.Interop.Excel.dll' in my .net project(C# code behind). i get the above error FROM the BELOW line Application excel ...