No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Discussion1VotesHow to enable FILTERS when sheet is protected
Hi All, How to enable FILTERS when sheet is protected? Do I have to manually unprotect everytime when i filter? I have provided ... -
Answered0VotesAuto-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 ... -
Unanswered0Votesc#: Excel App looses focus
I have a MS PowerPoint, I open MS Excel, from where I open the ColorDialog. Im using How do you pass the owner window to Show() method overload? to find the Excel IWin32Window ... -
Unanswered0VotesProblem using relative path in Excel
I have the following directory structure in Windows 7: test excel accounts 2011 accounts 2011.xlsx ... -
Unanswered0VotesExcel 2013 Crash
I created a workbook with macros which when opened and run the macro for the first time works without a problem. Leaving the workbook open, the next time I run the macro, Excel ... -
Unanswered0VotesWhat does absRelMode do in the following code to toggle through relative/absolute reference of cell.
I have found the VBA code below to change relative/absolute reference of a cell. I dont understand how the Static variable "absRelMode" effects the code and serves ... -
Unanswered0Votesfilter pivot tables by workbook range
Hello all, Have two separate sheets, each with a different pivot table. PT fields "Date" are filters. Need those Date ... -
Unanswered0VotesImport an excel table in a access file USING OFFICE 2010
Hi to everyone, i'm a newbye I have a problem with the vba code to import data from a table in excel file access. Using Office 2010, but the launch of the code gives me an ... -
Unanswered0VotesTime and date picker issues
In our office we all have Excel 2010 installed. I have created a spread sheet that uses the Date and time picker in both Date and Time. However 50% of the office ... -
Unanswered0VotesSelection.Subtotal
Thanks for taking the time to read my question. I would like to put subtotals into my spreadsheet using VBA. I can do this, however I need to add more subtotals and I can't seem to ... -
Unanswered0VotesExcel Spreadsheet into a SQL database
I want to know how to turn my Excel Spreadsheet into a SQL database. I first need a connection string then a way of executing an SQL command "INSERT INTO [table1] VALUES ... -
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 ... -
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 ... -
Unanswered0VotesxlEventRegister and cancellation of Async UDF (User Defined Function)
' ... 'Q'). I have tried to register a function with the correct syntax, but I have not be successful, xlfRegister simply returns error. I have however, been successful registering ... -
Unanswered0Voteslock cells in excel & add checkbox from web application
in my web application i need to export data to excel from datatable in a particular format this has been done i need to lock some cells range ... -
Unanswered0VotesPopulating a cell with the SelectedItem of a ListBox
So I am trying to finish off a Zip Code auto population Sub in Excel and I'm trying to handle Zip Codes that cover multiple Cities. In order to finish this off I need to be able have the ... -
Unanswered0Votesc#: Excel: FindWindow(rctrl_renwnd\0, caption); returns 0 ?!?
I have a ShowDialog, and Im trying to find out the IWin32Window owner of it, which is an Excel. I found solutions like IntPtr _windowHandle = ... -
Unanswered0VotesReferencing a Worksheet in Visual Studio as opposed to Excel
Again I'm working on my Zip search multi-city handling, and this time I have moved the project from purely Excel and Macros to purely Visual Studio, coding in Visual Basic still in an Excel ... -
Answered1VotesAvoid division with zero using variables in VBA
Hi, Many thanks in advance for any help provided. I am completly stuck after many days of programming. I got a problem with division by 0. I do subtotals of ... -
Unanswered0Votes2D arrays with LPXLOPER12 -- is it possible to dynamically size?
val.array.lparray[i].val.array.lparray[j].val.num for the value stored at (i,j)? Apparently, TheArray->val.array.lparray[i][j].val.num does not seem to be ... - Items 1 to 20 of 8794 Next ›


