I have used OLE-automation to control Excel95 from Visual C++. Therefore I generated via the class-wizard with the Excel5-OLB-file the 4 classes Application, Workbooks, Worksheet and Range. The app...
http://www.experts-exchange.com/Programming/Languages/CPP/Q_10046250.html
Is there a way to make a Excel worksheet as a database and using recordset & sql statement to retrieve records?
Thanks
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10239475.html
Zones:
Visual BasicDate Answered: 12/10/1999 Grade: C Views: 0
I was wondering if there was a Function in Excel where you can look up the "Worksheet Names" within a file.
For Example :
Say I have a list of Employee Numbers on an excel Spreadsheet :
000...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_11999778.html
Zones:
Visual BasicDate Answered: 12/01/2000 Grade: A Views: 0
I have create a button on the fly in
an excel.application from a VB program
with the following code
Worksheets(CurrentSheet).Buttons.Add(4, 715, 290, 26).Select
Worksheets(CurrentSheet).Butt...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20036955.html
Zones:
Visual BasicDate Answered: 01/21/2001 Grade: A Views: 0
Hi guys,
Worksheets 1 to 7 are named Sheet1, ... Sheetn, ... Sheet7
In another worksheet [Main]:
D27:D33 contain from 1 to 7 different Country names [yes, the number of Countries does chan...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_201...
My client wants to copy the cells/formatting/column widths, etc of one worksheet to appox 400 add'l worksheets.
I know the code to add the additional worksheets but I can't figure out how to cop...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_202...
Hi,
I want to access a excel file which has 5-6 sheets,each with different worsheet name. How do I open a worksheet with a specific name.
Is this correct?
Excel.worksheets.Name("SURESH").open...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Controls/Q_20407045....
Zones:
VB ControlsDate Answered: 11/27/2002 Grade: B Views: 0
The title says it all really.
I would like an Excel expression that I can drop into a cell that will display the worksheet tab title in the cell.
I have a workbook that has numerous worksheet...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_205...
I have a macro in Excel that inserts new columns/rows, new formula, etc (which is triggered when the user presses a button). Before this all happens I need a few lines of code at the start of the ...
http://www.experts-exchange.com/Software/Misc/Q_20602319.html
Zones:
SoftwareDate Answered: 05/01/2003 Grade: B Views: 0
Iam trying to link information from a spreadsheet to another spreadsheet.
This is my Data
A B C
100 Apples 10/4/2002
200 Apples 10/3/2002
300 Oranges ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/09/2003 Grade: A Views: 0
