Question:

Capture cell content from Excel into VB Textbox or Label. how to get values from dataset which is

by Guest11128430  |  2 years, 8 month(s) ago

0 LIKES UnLike

how to get values from dataset which is filled by excell sheet fields

 Tags: capture, Cell, content, excel, label, textbox, VB

   Report
Answer The Question I've Same Question Too

1 ANSWERS

Sort By: Date  |  Rating
  1. Ali Abdullah
    Hi, Dim xl As Excel.Application Dim strFileName As String 'under project_references_ check Microsoft Excel Objects. Private Sub Command1_Click() Set xl = CreateObject("excel.Application") xl.Workbooks.Open ("C:\my documents\test_bed.xls") ' substitute your file here xl.Visible = False Text1 = xl.Worksheets("Sheet1").Range("A1").Value Text2 = xl.Worksheets("Sheet1").Range("A2").Value ActiveWorkbook.Save xl.Application.Quit Set xl = Nothing Hope it helps

You're reading: Capture cell content from Excel into VB Textbox or Label. how to get values from dataset which is

Question Stats

Latest activity: 2 years, 8 month(s) ago.
This question has been viewed 130 times and has 1 answers.

Similar Questions

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now