ATTN: SteveT

B

Bob Barnes

Steve - These did not work (Someone was Kind enough to
send me the code).

I understand why ".CopyFromRecordset" doesn't work.

objXLSheet.Range("A1").Value = strMyString

or

objXLSheet.Cells(rownr, colnr)= Me.lblMyLabel.Caption


hth

Bob --> TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top