Hi Leandro,
Sorry Leandro,I was little bit busy,so i m not able to deliver it
immediately.
Please find the following code for Import text file.
Sub ImportTextFile()
Dim Fname As Object
Fname = Globals.ThisWorkbook.Application.GetOpenFilename("Text Files
(*.txt),*.txt", , "Select Text Data File
Hi Gaurav, maybe you can help again. Leveraging your knowledge.
In my project, described before, in the form there will be a button. I
want when
I click this button excel import an text file in another workbook. I
would like to
know how can I instantiate this workbook to get data from it to put in
Thanks once more Gaurav for your help.
Leandro
On 16 jul, 11:32, GAURAV JAIN wrote:
> Hi Leandro,
>
> For this,
>
> I created one text box & button in my vsto form.
>
> Go to button and Click it.Then write this code.
>
> Private Sub Button1_Click(ByVal sender As System.Object, ByVal e
> AsSystem.
Hi Leandro,
For this,
I created one text box & button in my vsto form.
Go to button and Click it.Then write this code.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e
AsSystem.EventArgs)
Handles Button1.Click
Dim x As Integer
x = TextBox1.Text
Globals.Sheet1.Range("A1:D1").
Thanks Gaurav for reply. The form loaded right, the first doubt was
solved.
I have another one, maybe you can help me too. I have a button in this
form. I wold like to use the "click" event of this button to acquire
data from
user, put this data in a range of one sheet and them get some data
from
Hi Leandro,
Use this Code:
*Dim frm as New Form_Name*
*frm.ShowDialog*
This code will work for u.
Cheers,
Gaurav Jain
On Thu, Jul 15, 2010 at 9:15 PM, Leandro wrote:
> I am new in VSTO and have a doubt.
>
> I´ve created a project using VS2008. This is a VSTO in fact. I have
> a workbook with
I am new in VSTO and have a doubt.
I´ve created a project using VS2008. This is a VSTO in fact. I have
a workbook with sheets and I would like to show a form with controls
when this workbook is opened and manipulate the sheets data in the
events of the controls which are in the form.
If someone h