No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0Votes
Treeview control wizard
Before I have a question about "how to fill level 3 of treeview by query" but I did not get answer, after searching a lot in Google I read that there is a control wizard that works ...1 Replies | 34 Views | masoud sedighy - Wednesday, June 19, 2013 12:30 PM | Last Reply Quist Zhang - 53 minutes ago -
Unanswered0Votes
Problem with Ribbon when upgrading from VS2010 to VS2012.
Hi Folks, I recently obtained VS2012. I had already developed a solution (an Excel addin) in VS2010. I assumed that my solution would run in VS2012. When I tried to build the ...0 Replies | 27 Views | Bernie Ok - 8 hours 30 minutes ago -
Answered0Votes
Excel Import Date from MS Access Based on ID in Table
In Excel, I'm trying to import data from MS Access. Here's my code: Sub Access_to_Excel() Dim cn As Object, rs As ...2 Replies | 42 Views | ryguy72 - Saturday, June 22, 2013 6:34 PM | Last Reply ryguy72 - 10 hours 7 minutes ago -
Answered0Votes
Cumulative SUM as of an specific date within the year of the parameter value
Hello, I have a worksheet that keeps track of sales for the past few years including the current year. I would like to be able to get the YTD sum based on the ...6 Replies | 68 Views | Databasico - Saturday, June 22, 2013 1:40 AM | Last Reply Databasico - 13 hours 12 minutes ago -
Unanswered0Votes
simple code for save as if file already exsist
Hi I got this simple code to just do a save as: Sub SAVE() ThisWorkbook.SaveAs "d:\My Documents\filling_stocktake" & ...2 Replies | 138 Views | Mark030 - Saturday, June 08, 2013 12:50 AM | Last Reply Damon Zheng - 13 hours 28 minutes ago -
Answered0Votes
Windows paths in VB as variables ... how to?
I've added a macro to my floating toolbar in a spreadsheet that then gets plastered to the ribbon. The calculator gets launched here at home just fine where I have WinXP but I'm sure there'll be ...2 Replies | 110 Views | SGFan - Thursday, June 13, 2013 9:01 AM | Last Reply SGFan - 15 hours 2 minutes ago -
Answered0Votes
VBA way to bring up dialogue box for user to enter filtering text that then filters a specific column?
TEXT FILTERS ... > CONTAINS It would be ideal if a macro could just bring up the criteria box that I could then assigns keystrokes to operate and then the user could type in ...2 Replies | 88 Views | SGFan - Tuesday, June 11, 2013 6:18 PM | Last Reply SGFan - 15 hours 10 minutes ago -
Answered0Votes
Find and Replace in Excel Sheet
hi i had a requirement to find and replace the "~" only at the positions 9th 18th 27th........ in a excel sheet single cell. i had tried VBA and excel ...9 Replies | 597 Views | david billa - Thursday, January 03, 2013 7:44 AM | Last Reply Yamadera - 16 hours 41 minutes ago -
Answered0Votes
lock 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 ...2 Replies | 126 Views | SRekha - Saturday, June 15, 2013 3:59 PM | Last Reply Damon Zheng - 18 hours 56 minutes ago -
Unanswered0Votes
Excel 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 ...4 Replies | 87 Views | demcc - Tuesday, June 18, 2013 6:00 PM | Last Reply demcc - 19 hours 11 minutes ago -
Unanswered0Votes
Require vba code for user form
Hi Forum, I am downloading the data from our company's web. And I have to check the THC details (Truck Hire Chalan ) Truck Hire, Advance and Balance with the hard copy. I ...1 Replies | 41 Views | satputenandkumar0 - Saturday, June 22, 2013 9:58 AM | Last Reply Vish Mishra - 20 hours 13 minutes ago -
Unanswered0Votes
Not enough memory error
I am creating a lightswitch app which I am testing with very low charge. I instaled powerpivot in excel and when I import tables from localhost as feeds, it shows me the tables, ...0 Replies | 47 Views | joao_silva - Sunday, June 23, 2013 12:51 AM -
Unanswered0Votes
Referencing 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 ...6 Replies | 116 Views | cmpuncle - Saturday, June 15, 2013 7:30 PM | Last Reply cmpuncle - Saturday, June 22, 2013 5:17 PM -
Unanswered0Votes
How to Count the Occurrences of a Word in a Text File
I have VBA code that loops through multiple text files in multiple folders. This code works fine. What I can't really figure out is how to count the occurrences of a specific word in each ...8 Replies | 139 Views | ryguy72 - Thursday, June 13, 2013 11:15 PM | Last Reply ryguy72 - Saturday, June 22, 2013 4:26 PM -
Unanswered0Votes
xlEventRegister 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 ...2 Replies | 102 Views | Ian.Clegg - Monday, June 17, 2013 9:14 AM | Last Reply Govert van Drimmelen - Saturday, June 22, 2013 2:48 PM -
Unanswered0Votes
VBA to bring up filter box for text strings?
CONTAINS... > CUSTOM AUTOFILTER ("COMPANY") CONTAINS = (where we type in our text to filter out of). Even better if we could get that "Custom AutoFilter" box ...2 Replies | 48 Views | SGFan - Friday, June 21, 2013 8:01 PM | Last Reply SGFan - Saturday, June 22, 2013 2:19 PM -
Unanswered0Votes
excel vba auto row insert if column value more than 0 which has a formula which is hidden and locked
i have sheet say sheet3 in which column M had a formula (i.e column I - Column P) which vary as per row and also the formula is hidden and locked so that no one can see this formula. Column I is ...2 Replies | 48 Views | vipul.j.ca - Friday, June 21, 2013 7:05 AM | Last Reply vipul.j.ca - Saturday, June 22, 2013 1:05 PM -
Unanswered0Votes
Sharing Violation error while saving my excel VBA Code file with a chart control
I have just placed a chart control in my excel VBA code file. But I am not able to save that as it gives me an error message- "Your changes could not be saved because of a sharing violation. Try ...4 Replies | 53 Views | aprajitaj - Thursday, June 20, 2013 6:07 PM | Last Reply aprajitaj - Saturday, June 22, 2013 12:58 PM -
Answered0Votes
Visual studio 2012 - Excel application with windows forms
I am creating an Excel / SQL application in VS2012 (VB) and I want to get input information from the user. I have added a form to the project with appropriate text boxes etc. How do I open the form ...1 Replies | 35 Views | carblinglespeed - Saturday, June 22, 2013 10:26 AM | Last Reply carblinglespeed - Saturday, June 22, 2013 10:43 AM -
Unanswered0Votes
List the names of Tables available in an Excel Sheet Programatically/
I wanted to programatically list all the table names of an Excel sheet in C#. I was able to access the Excel Workbook and then a particular Work Sheet, now I wanted to list the tables present in that ...0 Replies | 30 Views | Chas484 - Friday, June 21, 2013 9:25 PM - Items 1 to 20 of 8815 Next ›