
February 19th, 2003, 05:28 AM
|
|
Junior Member
|
|
Join Date: Feb 2003
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Problem with Decimal numbers when I try to import them from Excel to Visual Basic
Hi, I have the following problem...
When I import data from an excel that are of this form 2,3 then everything is ok.
But when I import data of the type 0,08 visual basic imports 0 and not 0,08.
This is how I import the data
Dim oExcel as new Excel.Application
Dim oWorkbook as new Excel.Workbook
Dim oWorksheet as new Excel.Worksheet
Set oWorkbook = oExcel.Workbooks.Open(folderPath & "\test.xls")
Set oWorksheet = oWorkbook.Worksheets("sheet1")
tempVar=oWorksheet.range("nameOfCell").value
What is the problem?
I would really appreciate an answer!Thank you
|