I use following code to read DB table to Excel worksheet:
This works OK, but I need to find certain value from the DB and write that value to a specific cell. I know how to create SQL string to get that value but I don't know how to write it to a cell. I modified the code a bit:Please Login or Register to view this content.
but this doesn't work, it writes DB column name to that cell and results an error at some point. Any ideas?Please Login or Register to view this content.
Bookmarks