Re: $$Excel-Macros$$ Show a Form in VSTO Excel

2010-07-23 Thread GAURAV JAIN
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

Re: $$Excel-Macros$$ Show a Form in VSTO Excel

2010-07-20 Thread Leandro
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

Re: $$Excel-Macros$$ Show a Form in VSTO Excel

2010-07-16 Thread Leandro
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.

Re: $$Excel-Macros$$ Show a Form in VSTO Excel

2010-07-16 Thread GAURAV JAIN
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").

Re: $$Excel-Macros$$ Show a Form in VSTO Excel

2010-07-16 Thread Leandro
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

Re: $$Excel-Macros$$ Show a Form in VSTO Excel

2010-07-16 Thread GAURAV JAIN
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

$$Excel-Macros$$ Show a Form in VSTO Excel

2010-07-15 Thread Leandro
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