 |  |  |  |  |  |  |  |
VB 6.0 - Excel Error: #VALUE!
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
Good morning everybody.
I need a quick direction here. A column ("Comments") in my spreadsheet that is is supposed to have text values is displaying:
"#VALUE!"
Note: my input data is coming from an access query.
The underlined Below is the data in the "Comments" field in the query (recordset):
"3/21/2005: Compare this new file with the file created in the last pay cycle of 2004",
But when imported to the spreadsheet, it displays "#VALUE!" instead.
What am I doing wrong?
tgifgemini
I need a quick direction here. A column ("Comments") in my spreadsheet that is is supposed to have text values is displaying:
"#VALUE!"
Note: my input data is coming from an access query.
The underlined Below is the data in the "Comments" field in the query (recordset):
"3/21/2005: Compare this new file with the file created in the last pay cycle of 2004",
But when imported to the spreadsheet, it displays "#VALUE!" instead.
What am I doing wrong?
tgifgemini
Most probably Excel is trying to compute "3/21/2005" as a number or date. Then it is finding some text and getting messed up. If possible, try putting the 3/21/2005 part within quotes : "'3/21/2005' : Compare ..." etc.
Last edited by aparnesh; Aug 3rd, 2007 at 2:38 pm.
You are correct in your analysis. However, how do I tweak to code to accomplish the objective?
This is the code that is populating that column:
This is the data from the query(recordset):
"3/21/2005: Compare this new file with the file created in the last pay cycle of 2004"
You mean I should do something like this?:
[code]xlWksht.Cells(ii, 9).Value = & "'" & rsin![Comments] & "'"?
tgifgemini
This is the code that is populating that column:
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
This is the data from the query(recordset):
"3/21/2005: Compare this new file with the file created in the last pay cycle of 2004"
You mean I should do something like this?:
[code]xlWksht.Cells(ii, 9).Value = & "'" & rsin![Comments] & "'"?
tgifgemini
|
Similar Threads
- Can't get rid of MSOHEV.DLL (Windows Software)
- Need soem advice (Visual Basic 4 / 5 / 6)
- Excel solver using VB6 (Visual Basic 4 / 5 / 6)
- problem in exporting crystal report (ASP.NET)
- Corel Quattro 9 Excel error (Windows 95 / 98 / Me)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Recordset pointer NOT advancing to next record
- Next Thread: how to open a pdf file using form in access and creation of browser button
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
