Hi there, im trying to manipulate excel file XLS with C# by using Microsoft.Office.Interop.Excel the workbook im trying to manipulate has shared protection between users i have the file pw and i have the pw of the cells which i want to access and edit. if i try to do that from excel i do the following open the file type the pw go...
I know this isn't directly programming related, but at the same time... Mac Excel 2008 doesn't support VBA or Macros...which I need for a class... Does anybody know of a solution? I need a way to write simple macros on Mac in Excel--if it's possible. Please don't give vague answers if you don't know for sure. This is a serious questi...
Hi all. I have an Excel 2007 xlsx file that I would like to programmatically convert to an .xls file. The xlsx file is an export from a reporting tool, and I would like to convert it to xls for better compatibility with the software stack of my application users. The xlsx is as plain as it gets. Just rows with data and basic type inform...
Does VSTO 3.0 (using Visual Studio 2008) support both Office 2003 and Office 2007 installed side-by-side on a single development computer so that both Office 2003 and Office 2007 can be targeted (in separate solutions)? I have seen conflicting information about this. NO: http://msdn.microsoft.com/en-us/library/bb398242.aspx Visual ...
Hello all, Here is my problem Use case: - User will use a tool enables him to create a Form template that includes place holders for TextBoxes and data items. -After that user will upload the template to a website - Then user requests the template by the web site . website will replaces placeholders and shows the user the form. - then...
I have a custom url protocol handler for urls of the form myhandler://path/to/something. This is registered to a locally installed client application that handles the requests and does "the right thing". However, when I have a link of that form in outlook (2007), outlook displays a big scary warning that says: Microsoft office has ide...
It would make my user's lives much easier if I could do the following; Allow an Excel document to be viewed (not edited) in Internet Explorer 8 Facilitate jumping to particular sheets in that document I can embed the Excel file using an iframe which works, but I am utterly stuck when it comes to jumping to a particular named workshee...
Quick Summary How can I create a hyperlink to a specific cell in Excel that will work from Firefox, or achieve the same result in javascript? Detailed Description I have an excel spreadsheet that users enter data into. This spreadsheet is then used to generate some diagrams in SVG. The diagrams are displayed in Firefox (though this ...
I am trying to work with the Windows clipboard and Office Interop in an ASP.NET web application. Everything works well on my local machine running XP (i have created a Windows application first which ran perfectly well on local machine). Then I have executed it on a server running Windows Server 2003 and it worked there as well. Then I...
I want to use ms office communicator client apis, and i wan to use those in python is it possible to do ? ...
I need to connect to Excel table through TADOConnection, and I don't know what to write into ConnectionsString property. For Excel Version 8 I use Jet, for 12 I use ACE, what about 11? And how should connectionstring look? ...
In chapter 15 of The Deadline by Tom DeMarco working extra hours is discussed. One of the characters says she forces the developers out of the office every evening so that they can't work extra hours. She says this makes people concentrate on their work, use time more productively and lets them get more things done. The way she does tha...
Hello, i have this code in a powerpoint addin but it's not working and giving me an exception. The exception says: "Value does not fall within expected range". Any ideas what i'm doing wrong? this.Application.ActivePresentation.ExportAsFixedFormat(path, PpFixedFormatType.ppFixedFormatTypeXPS, ...
I have a .NET winforms app that automates Excel and checks for a worksheet password. The requirements are to be able to detect 1) that the protection is turned off 2) that the password is removed (protected but there is no password) 3) that the password matches the correct password from a database To meet the second requirement the prog...
Hi, would anyone suggest a free solution to programmatically convert Office documents (mostly .doc) to PDF in the form of a .NET library or a command-line application i can call from my program? Thanks PS: I know I can use SaveAs PDF in newer versions of Office, but some of the clients where the program will run still have older versio...
Hello, I am using MS Office 2007. Please let me know that how can I copy whole data from sheet one to sheet two. I want to copy the whole data from row 5 to onward in sheet two. The whole scenrio is given below in detail. Sheet one: Copy the data from column B and Row 3 Sheet Two: Paste the Copied Data in Column B and Row 3 Shee...
Hi , I was trying to create a setup project using VS2008. Is there anyway to detect if a particular Office 2010 application is installed or not? (as a prerequisite) .eg: i want to detect if Powerpoint 2010 is installed on client machine. I was trying to use windows installer search option in lauch condition but unable to find wha...
I'm trying to set the Calculation property on an OLAP PivotField with VSTO 3.0. For example: pivotField.Calculation = XlPivotFieldCalculation.PercentOf; If I do the above, the value I assign does not stay (Excel appears to revert the change). I suspect the reason is that the BaseField property of the PivotField also needs to be popu...
Hi, I have an outlook addin that I have been developing for some time now, and am experiencing a problem. If I have a computer with two 'administrator' users (call them User A and User B), the addin installs and runs just fine as long as the same user tries to run it. In other words, if User A installs the addin, then User A has no pro...
Hi, When importing an excel spreadsheet in Sharepoint, the following error pops up in a web dialog with the following message-"Automation server can't create object". What is wrong? does office needs to be installed to import spreadsheets or will installing the primary interop assemblies for Office fix this issue. Thanks ...