Description:
Microsoft Office Excel newsgroup.
|
|
|
Excel and Dataviz Sheets To Go
|
| |
I had an interesting experience today with Excel and Dataviz Sheets To Go, a spreadsheet application for handheld mobile devices. A client asked me to make an Excel spreadsheet with many formulas, for use in their Blackberries. At the time, they were sure it was Excel on their blackberries, but I was pretty sure it couldn't be, and... more »
|
|
Compare two worksheets in the same workbook and highlight difference
|
| |
Hello All, If anyone could help me with a VBA Macro that will compare two worksheets in the same workbook and highlight the difference, it would be greatly appreciated. Both worksheets have the same number of columns (12) but not the same number of rows. The first worksheet is called "CURRENT" that has the... more »
|
|
create a spreadsheet from another app
|
| |
Hi, I am creating Excel spreadsheets from our application. We start Excel and then send DDE commands to it to create spreadsheets. Is there a better way of doing this that is not so error prone ? Excel seems to have DDE problems often and there seems to be some mysterious re-entrency problems where both our application and... more »
|
|
Error : Cannot access the file <file path>
|
| |
Hi, I have WCF service running on windows XP under IIS 5.1. I have reference of Microsoft.Office.Interop.Excel dll. I am creating an excel file at run time and able to create application object as below but when i am trying to save workbook I am getting below error : Microsoft Office Excel cannot access the file 'file path'. There are several... more »
|
|
Stillen Performance Parts
|
| |
...VVVVVVVVVVVVVVVVVVVVVVVVVVV VVVVVVVVVVVVVVVVVVVVVVVVVVVVVV VVVVVVVVVVVVVVV .... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .... more »
|
|
cannot create excel through ASP.NET
|
| |
I am using Microsoft.Office.Interop.Excel 12.0 to generate an xl file at the server(win 2003),add some sheets of data and download it to client.But it throws me an exception when I add sheets to workbook . _Workbook workbook = workbooks.Add(XlWBATemplate.xl WBATWorksheet); The exception message is as follows.... more »
|
|
The Excel Macro Message
|
| |
Hi I have an excel 03 woorkbook that had macros nowi i have the option for macros disabled with notification if i open the workbook and enable the macro a message box appears with message "update test results" and when i try to open this workbook from some other application using InvokeMember function in c# i get the same message box. i want to supress... more »
|
|
VB.Net Create Excel Worksheet Error when other UI instance has err
|
| |
There is a 2007 UI Excel instance up with an error on it and there is a vb.net program that tries to create a worksheet intance. See the info below. Thanks in advance. Excel UI Dialog Error: The file you are trying to open test.xls is in a different format then specified by the file extension.... more »
|
|
Catch Excel Macro Errors in C#
|
| |
Hello, I have a C# service which basically converts XLS (2003) files to interactive HTML pages at runtime. In this service, I have three types of macros: 1) GenerateWorkSheet (converts a multi sheet XLS workbook to interactive HTML) 2) GeneratePivotChart (converts a pivot chart active XLS workbook to HTML)... more »
|
|
Chart.ChartWizard() throw an exception indicate that ChartWizard() is not valid.
|
| |
environment: Win2003ent vc2005sp1 office2003sp3 i wanna to operate excel from a dll. i generated MsExcel.h and MsExcel.cpp from excel's typelib. when running this code: COleVariant covOptional((long)DISP_E_PARAM NOTFOUND, VT_ERROR); VARIANT ret; ret = sheet.ChartObjects(covOptional ); _MsExcel::ChartObjects chartObjects;//_MsExcel is my own's namespace... more »
|
|
|