i have above code
Please Login or Register to view this content.
i am writing data to excel files from from application
when execute below line it doesnot give error
sheet1.Range("L4").Value = datatable1.Rows.Count
but on executing
sheet1.Range("B4").Value = CStr(txtname.Text)
it gives type mismatch error
Extracted from Ms-office VBA help....
Boolean
A string containing True or False
Date
A string containing a date in the short date format of your system
Null
A run-time error
Empty
A zero-length string ("")
Error
A string containing the word Error followed by the error number
Other
numeric A string containing the number
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Is txtname.text a value, or a string? the CStr function expects a value.
You could replace that line with:
Which would then cope with being passed either a value or a string.Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks