• Registered: 2020-02-12
  • Posts: 20

Topic: Create an application that depend on an Excel file

Hello Everybody,
Could you help me in my question,please?
I want to Create an application that depend on an Excel file.
For Example:
I want to link my textboxes and labels with excel cells
How to do that?Is there a guide?
Thanks in advance

  • Registered: 2014-11-13
  • Posts: 370

Re: Create an application that depend on an Excel file

See this topic

http://myvisualdatabase.com/forum/viewtopic.php?id=6946

Domebil

domebil's Website

3 Reply by leprince2007 (edited by leprince2007 2020-09-12 19:51:13)

  • Registered: 2020-02-12
  • Posts: 20

Re: Create an application that depend on an Excel file

I saw the post but it isnot what I want.
I want to link my application to an excel file.or use the excel file as my database.
example:
textboxes get data from the excel file:
Textbox1.text=sheet1.range("A1")
Textbox2.text=sheet1.range("b1")
Textbox3.text=sheet1.range("c1")
button:(insert data to excel file)
sheet1.range("A1")=Textbox1.text
sheet1.range("b1")=Textbox2.text
sheet1.range("c1")=Textbox3.text
and more like that.
thanks for helping

  • Registered: 2014-11-13
  • Posts: 370

Re: Create an application that depend on an Excel file

Do you want to import and export the entire database in excel?

Domebil

domebil's Website

5 Reply by leprince2007 (edited by leprince2007 2020-09-13 15:09:35)

  • Registered: 2020-02-12
  • Posts: 20

Re: Create an application that depend on an Excel file

domebil wrote:

Do you want to import and export the entire database in excel?

No ,I want to get data from some cells only.
See my 3rd comment :I want to make code like it.

  • Registered: 2020-02-12
  • Posts: 20

Re: Create an application that depend on an Excel file

up up up