Hi all,
I'm using the code below to open a work book and move to a particular worksheet in the work book.
The problem arises in the Else Clause of the IF Then statement. I'm not sure how to set Excel to a particular sheet in the workbook, even though I have both the name of the sheet and the number of the sheet.
The work books can have either 1 or 2 worksheets in them. If it is 1 sheet, there is no problem....
Craigbob
Last Activity: Jan 6 '07, 12:39 AM
Joined: Sep 29 '06
Location:
-
VB6 Excel Worksheet help needed
-
Need some help please
Hi,
I'm new here and it has been several years since I've done any serious VB coding. I used to do a lot of VB6 development and have not really touched it in about 8 years. .NET is brand new to me as well.
I need to create a quickie application either in VB6 or preferably VB.NET that does the following:
Reads through a directory of .XLS files reads the contents of 2 cells and renames the file based on... -
Need some help please
Hi,
I'm new here and it has been several years since I've done any serious VB coding. I used to do a lot of VB6 development and have not really touched it in about 8 years. .NET is brand new to me as well.
I need to create a quickie application either in VB6 or preferably VB.NET that does the following:
Reads through a directory of .XLS files reads the contents of 2 cells and renames the file based on...
No activity results to display