February 19th, 2003, 06:28 AM
Join Date: Feb 2003
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")
What is the problem?
I would really appreciate an answer!Thank you