RE: [Talk] Reading from an Excel File

Thu, 21 Apr 2005 14:45:53 -0700

Title: Reading from an Excel File

The following line works to select a specific sheet in the open workbook.

 

Set oWrkSheet = oExcel.Worksheets("Marina Adjustments")

oWrkSheet.Activate

 

Hope it will help.

 

Morris Benjamin

Daniel Freeman Hospital

310-448-7833

[EMAIL PROTECTED]

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mitchell Sherry - Mid West Div.
Sent: Thursday, April 21, 2005 2:28 PM
To: '[email protected]'
Subject: RE: [Talk] Reading from an Excel File

 

The tab you are wanting to read from has to be the first on the left ...

 

thanx, sherry

HCA Midwest Division IT&S

Applications Programmer/Analyst

816/823-0406

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Linda Ralston
Sent: Thursday, April 21, 2005 4:25 PM
To: [email protected]
Subject: [Talk] Reading from an Excel File

Has anyone written a script that reads data from and Excel file with multiple worksheets?
I am able to read a .txt file easily but I'm not sure what the trick is for reading from an excel file.  I could convert it to .txt if I have to but I'd rather not.

Thanks.

Linda Ralston, ISP
Applications Analyst
Information Management
Peace Country Health
Grande Prairie, AB Canada
780-538-7135

 

Reply via email to