Hi,
The following statement will be able to find the number of rows used in an Excel sheet.
LastRow is a variable which stores the value of used rows.
oExcel is an object of an Excel application.
...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10153254.html
Zones:
Visual BasicDate Answered: 04/26/1999 Grade: A Views: 0
I would like to know how to add code into my program the checks to see if there are any excel files saved as the same name as the one that i will be saving my excel workbook as.
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_10162678.html
Zones:
VB DBDate Answered: 05/19/1999 Grade: B Views: 0
I'm writing a database program in VB that connects to access
How can I export the data to excel so I can add formulas and all that fun stuff to it
any help with this would be greatly appreciated
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_10190834.html
Zones:
VB DBDate Answered: 08/06/1999 Grade: B Views: 0
My problem is that I send a mail within attachment (example: file.doc), the user receives this mail with file but this file without it extension, only "file". The user doesnt knows what type is thi...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10237957.html
Zones:
Visual BasicDate Answered: 11/24/1999 Grade: B Views: 0
I asked a question a while back, and I know how to add values to cells, etc, but I want to know the following:
1) How do I copy a sheet and rename it using VB?
2) How can I save under a diffe...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10351289.html
Zones:
Visual BasicDate Answered: 05/17/2000 Grade: A Views: 0
I am working on some data in diferent workbooks and in diferent worksheets.I want to use these data with a visual basic program so that I can come to some conclusions.What vb version should I use a...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_11422218.html
Office 97:
You can save an individual sheet as an HTM document, but if I try to record it as a macro in order to see the VBA code, the macro is blank.
Is there VBA/VB code avaialble to perfor...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_11968338.html
Zones:
Visual BasicDate Answered: 11/14/2001 Grade: A Views: 0
I think it is an eazy question, I just don't know the best way to create an excel file from and kept adding to the information.
Here is what I need to do
1) take information from multipy tex...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20078607.html
Zones:
Visual BasicDate Answered: 02/17/2001 Grade: A Views: 0
I want to be able to read/write data from an Access database in an Excel sheet. What is the best way to do this, and how do I do it? I've done some Visual Basic database developement before, but ne...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_200...
Takes forever to convert and excel to a text file. Any suggestions??
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20110646.html
Zones:
Visual BasicDate Answered: 05/16/2001 Grade: A Views: 0
