No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0Votes
Copying Multiple Worksheets Into New Workbook
I have a master workbook where sometimes I need to copy 2 - 3 worksheets from that master book into a new book. I have gotten close to acheiving this, but my problem is my code is ...3 Replies | 267 Views | toptierdawg03 - 3 hours 52 minutes ago | Last Reply Vish Mishra - 1 hour 3 minutes ago -
Unanswered0Votes
vb.net to kick start hyperlink
Iam using a third party product that produces the Excel sheet, so I have limited control. I can now get the =HYPERLINK("brn-0001.xlsx") in a cell, but it is not recognized as a link ...1 Replies | 42 Views | TheBrenda - 2 hours 57 minutes ago | Last Reply TheBrenda - 1 hour 33 minutes ago -
Unanswered0Votes
how to add transition effect to a winform
Hello: I have been researching and so far have nothing about this. I want to know if there is a way that I can add transition effects to my winforms. I have about 3 winforms on my ...0 Replies | 51 Views | JMazorra - 3 hours 14 minutes ago -
Unanswered0Votes
Excel =Hyperlink("file:// format for a relative file
I want to create a relative file:/// hyperlink but cannot get it to work. The file I want to open is in the same folder as the Excel workbook that has the link. This ...3 Replies | 76 Views | TheBrenda - Wednesday, July 03, 2013 8:14 PM | Last Reply TheBrenda - 3 hours 49 minutes ago -
Unanswered0Votes
How to generate XML using VBA programming?
Hi, I have following data in my excel ...0 Replies | 29 Views | Pankaj_Shelar - 5 hours 6 minutes ago -
Unanswered1Votes
how to call a function in Vb.net
Hello: This may seem elemental, but I created a function and placed within a module. and now I am trying to call the function. I used VBA before, so I know how to do it there. ...1 Replies | 62 Views | JMazorra - 20 hours 47 minutes ago | Last Reply varocarbas - 12 hours 3 minutes ago -
Unanswered0Votes
Get Value From Double Entry Table
Hello, I have the following tables: How can I calculate values in column C3 based on the second table? Basically, for first ...1 Replies | 56 Views | MDMoura - Friday, July 05, 2013 8:32 PM | Last Reply Andreas Killer - 13 hours 41 minutes ago -
Unanswered0Votes
Excel web services programming
Hi, I have an Excel Web Access webpart, where a user is allowed to enter certain parameters in the published workbook and ...3 Replies | 98 Views | Cooltechie1234 - Saturday, June 29, 2013 4:13 PM | Last Reply Cooltechie1234 - 16 hours 27 minutes ago -
Unanswered0Votes
How to Update Data in an MS Access Table Based on What is in an Excel Sheet?
0 CONum = ...0 Replies | 53 Views | ryguy72 - 19 hours 40 minutes ago -
Answered0Votes
Add a PowerView theme ?
Has anyone found a solution to add a Theme in the PowerView add-in in Excel 2013 ? We want to add our own color chart. Thanks in advance for your ...2 Replies | 79 Views | Bohor - Thursday, June 27, 2013 3:44 PM | Last Reply Bohor - Friday, July 05, 2013 8:55 PM -
Unanswered0Votes
Data Validation Combo Box Shrinking
I've used the "Data Validation Combo Box using Named Ranges" which works very well. The only issue I'm having is the Combo Box does not seem to hold its size. It seems to shrink ...1 Replies | 60 Views | Rhino V - Friday, July 05, 2013 3:36 PM | Last Reply ZachariahS - Friday, July 05, 2013 7:02 PM -
Unanswered0Votes
How to create a secondary axis that does not delete when you refresh or apply slicers.
I have a basic pivot table with two vertical axis. I also have slicers to filter my data. The secondary vertical axis format goes away when I apply a slicer ...0 Replies | 42 Views | Dessie27 - Friday, July 05, 2013 5:45 PM -
Unanswered0Votes
Date Value from SQL Server to Excel Table type lost
Good day, I have a data source from SQL Server 2008 containing employee hire dates. All dates on SQL are Date data types. I created a table in Excel 2013 (ODBC ...2 Replies | 69 Views | Andre Uys - Wednesday, July 03, 2013 4:23 PM | Last Reply Andre Uys - Friday, July 05, 2013 5:23 PM -
Unanswered0Votes
Working with Modules, how to reference the workbook and worksheet?
Hello: I will be using the line: Globals.dsbEmployeeBoard.Select() several times throughout my workbook. I do not want to write the same line over and ...0 Replies | 42 Views | JMazorra - Friday, July 05, 2013 5:12 PM -
Unanswered0Votes
Error while Importing excel file to Datagridview
Hi, I am trying to import an excel file File.xlsx. I am using Windows XP. When I try to import an excel file, I get the following ...9 Replies | 107 Views | Devaks - Monday, July 01, 2013 10:15 AM | Last Reply Jeffrey-2013 - Friday, July 05, 2013 2:54 PM -
Unanswered0Votes
Marshal.FinalReleaseComObject exactly when have I used an object?
I am calling Hyperlinks.Add but don't assign the returned object to anything. Should I assign it and then immediately call FinalReleaseComObject on it? If I reuse a range object by ...1 Replies | 43 Views | Tom Groszko - Friday, July 05, 2013 2:00 PM | Last Reply Jeffrey-2013 - Friday, July 05, 2013 2:43 PM -
Answered0Votes
Data manipulation- data Merge II
20 don't join ...2 Replies | 53 Views | David_1234 - Thursday, July 04, 2013 9:13 PM | Last Reply David_1234 - Friday, July 05, 2013 7:13 AM -
Unanswered0Votes
Connection issues with a Pivottable connected to an Access database
Hello, I have an issue at the office for which I could use your help/ explanation. Let me first describe the issue. The case: I have a report in Excel ...0 Replies | 53 Views | Der Snoober - Friday, July 05, 2013 6:48 AM -
Answered3Votes
how to call excel macros programmatically in C#?
Hi, I have a requirement where i need to call excel (2003) macros in C# program. Can anyone help me with a code snippet to do the same? The excel macro function ...7 Replies | 6505 Views | Nayna - Tuesday, March 20, 2012 6:51 AM | Last Reply ryguy72 - Friday, July 05, 2013 4:47 AM -
Answered2Votes
Is there a Data Validation bug in Excel 2007
Hi, I am applying custom data validation to a column (C, rows 20 to 170) of names through an indirect reference [Indirect($Q$9)] because data validation will not allow use of a User ...4 Replies | 124 Views | leoblack - Sunday, June 30, 2013 3:29 AM | Last Reply leoblack - Friday, July 05, 2013 2:52 AM - Items 1 to 20 of 8908 Next ›