No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0VotesExcel Crash with OLE object
Hello: I am experiencing an Excel crash under odd conditions. This is the kind of crash in 2010 that manifests with a dialog box which says "Excel has stopped working" Then it ... -
Unanswered0VotesProgramatically closing ProtectedViewWindow(s)
I’m building a very specific purpose add-in which, before it runs, I want to make sure there are no open windows inside the Excel instance. I’m able to count and ... -
Unanswered0VotesRun-time error '1004': Method "Select" of object "Charts" failed
Hi Everyone, I am new to VB Script. Basically i m creating the graphs in the ppt and i want to select the chart sheet so that the graph is ... -
Answered0Votesc# : Excel 2010: Excel.Chart -> X Axis -> Hide the labels ?
an x-axis. I want to hide / switch off the displaying of the labels in the axis (but leave the rest of the x-axis, i.e. not to delete it) . How could this be done ? ( I ... -
Unanswered0VotesVBA for excel requirement
Hi, I need the VBA codes for the below two conditions. 1. Delete the entire row based on a comment in the ... -
Unanswered0VotesExcel.Workbooks.OpenText function behaves differently in .NET 4 vs .NET 3.5
Below is a complete code example that demonstrates the problem. When I set the Target Framework to .NET 3.5 then Excel will autodetect the cell data type and set it's type to date. When I set it to ... -
Unanswered1VotesHow to combine multiple SQL rows based upon an identifier
Hi everyone. So right now I have an access database that contains rows of printer/copier transactions, with a column that defines whether or not the printer is black or white. I'm now at ... -
Unanswered0VotesLate Binding in VB.NET - Formating Excel sheet cell with resource font file
Hi. I am looking a way to format Excel sheet cell with font which is embedded resource in my project. Actually, this font is barcode file. I understand its a little complicate to ... -
Unanswered0Votesdelete all blank cells
Fundamentally the question is whether Excel has an embedded feature to delete all blank cells? - or to auto sort all columns to bring data to the top? The situation is that we ... -
Unanswered0VotesHow to search for a field in a sheet then let that field and some related fields appear in another sheet?
Here is the logic of my question: In a sheet, I have a row with "apple", "orange", "banana" Then there are information data for each ... -
Unanswered0VotesExecuting a sql command from excel
ConnStr = "Provider=SQLOLEDB;Data Source=serverName;Initial Catalog=databaseName;User ID=userName;Password=userPassword;" cmdStr = "SELECT * FROM ... -
Unanswered0VotesAuto-Update for Excel 2007 Workbook C# project
Hi All, Is there a way to add auto-update feature to an Excel 2007 Workbook C# project ? So far I've seen tutorials only for WPF applications auto-update. Thanks ... -
Unanswered0VotesFlowchart Code - 2 question?
I have 2 question pertaining to C# and VBA (excel2010) I am wondering about looking for and app(s) or addin(s) for visual studio and or excel 1. To make ... -
Proposed0VotesHow to show a TextBox on Button click in Excel
Hello, I am trying to do a comparison of my events in Excel. I have added an Button and would like to have an text-box pops-up after we click on the button. Later ... -
Unanswered0VotesExcel/Access 2007/2010 vba chart error "specified dimension is not valid"
I have a procedure in Access 2010 that creates a spreadsheet and adds some data and charts. This works correctly in Access 2010, but when I run it in Access 2007 with Excel 2007, upon saving I get the ... -
Unanswered0VotesPivot Table Sort on "Show Values As" field
Hi, I have a pivot table within which I am choosing the "Show Values As" option to show values as the difference from a base valu column. Now I want to sort by that ... -
Unanswered0VotesCell Formatting in Excel 2010 vs 2013?
Hello, Our web application uses Apache POI and Jasper Reports to export data to an Excel spreadsheet. Everything works fine with Excel 2003 - 2010. However, when an exported ... -
Answered0Votes"Add XML Maps..." Button Disabled in Excel 2010
Hi All, I am working with Excel 2010 file and when I display the XML Source pane the "Add XML Maps..." button is disabled. There are no maps associated with the ... -
Unanswered0Votes.xls file not opening in windows 7, created through VB.NET application in VS 2005
Hi, I have a VB.NET (VS2005) application that creates .xls files using the Interop.Excel version 1.5. The file is created and opened succesfully from the application. But ... - Items 1 to 20 of 8784 Next ›


