Your right but do you know how I can set the format to the right property in excel using VB? I will set the value like this: objSheet.Range("H9").Value = Now() Then I should be able to use VB to format that excel object. If I can set the horizontal alignment to right (objSheet.Range("H9").HorizontalAlignment = xlRight) then I should be able to some way set the format property to tell it to show the date as "February 17, 2005". Do you know how? Thanks in advance!! Beginner in VB

Ritesh1234 wrote: You can copy a worksheet by using the Worksheet object's Copy method. To copy a worksheet to the same workbook as the source worksheet, you must specify either the Before or After argument of the Copy method. I am trying to copy a worksheet from one workbook to another workbook. From what I get from you is, copying a worksheet in the same workbook and not to a totally different workbook. I was able to add a sheet to the workbook but that doesn't solve the problem of copying the data over to it. This is my task. I am creating an excel document in Visual Basic code with 6 worksheets. Now I need to be able to create another sheet making it the cover sheet for that work book. I have another excel file that acts like a template as to what the cover sheet should look like. I need to copy that worksheet containing the cover sheet to the new file I created in visual basic. EX: Test.xls contains coverSheet Test2.xls contains 6 worksheets I need to take the coverSheet from test.xls and put that worksheet into test2.xls Is it possible to copy from one workbook to another different workbook? Thanks for the help:) Beginner in VB.Net

It's called "bootstrapping". You can't include the .NET Redistributable in the .MSI that contains your application because one of the pre-launch conditions for install is that the .NET Framework already be installed! So, you must use a non-.NET managed application as a Setup program to check for the required software that must be installed, and unpackage and launch the appropriate installers for them, then, lastly, launch the .MSI setup for your application. See this[^] excellent article on CodeProject for an example and explanation. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Very intresting article regarding .net and Linker http://www.joelonsoftware.com/articles/PleaseLinker.html[^]

Yes I did. I was able to use the imput mask in the access database and it worked when you opened access. When I pulled that column into a datagrid it didn't bring the mask with it. So it still displayed 1234567895 instead of 123-456-7895? Is there something special that I have to do in .Net to display the input mask as well?:doh: Thanks:cool: Tim

Thanks a million:-D Beginner in VB.Net

Still looking for a few. I don't have a mscor.dll file on my computer. Can you send it too me? Thanks.:) Beginner in VB.Net

no problem tim. :) take it easy. -jim

That's because when you use the .Text property, the text entered must match the mask format exactly. If not, you won't see anything. You can't use the MaskedEdit control to format the data for you. You have to use the String.Format method for that. Text Property (MaskedEdit Control)[^] RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

I created a dataset through access database. I just need the search, or find engine to locate the files faster, if the files are too long. I would do the same thing as you suggested. Mine is an address book, and I also have a password dialog. How would I also can make the password dialog, if i want to change my password code? My addressbook consist of First Name, Last Name, Address, City, State, Zip Code, Email. I would like to have a search button with code. Then I use a select statement for every field, then when the dataset populates, I can use the search and input box to enter the name of the person I am looking for? Or do I have to enter in a case select every persons name within a dataset? bravo659

you've probably sorted it now but a really simple way would be Private Sub DataGrid1_CurrentCellChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DataGrid1.CurrentCellChanged Dim oCell As DataGridCell oCell = DataGrid1.CurrentCell Dim lRowNum As Long lRowNum = oCell.RowNumber With DataGrid1 .Select(lRowNum) End With End Sub "If i was king cigarettes would be free."

Try to download the sample book from kidwaresoftware[^]. This book has only 50% of its set but you can read it just for understanding. I like this book too because it explain clearly and very good. But you need to know how to use VB6. You could find many more free sample chapter from kidware[^] website. A thousand mile of journey, begin with the first step. APO-CEDC Save Children Norway-Cambodia Office

Thanks dave;) Beginner in ASP.Net and VB.Net

Sorry for the late reply, time-zone difference and all. if the gmail doesn't work, send it to catpainter79 AT yahoo DOT com "if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler.

Use ADO.NET. What you should do is: 1. Set up your connection string in as Connection object. 2. Instantiate an DateAdapter object using the above connection 3. Fill a dataset using the adapter. 4. Change the values in the dataset 5. Call DataAdapter.Update Read up on ADO.NET[^]. :) "if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler.

Dave Kreskowiak wrote: Never heard of it... You shouldn't post a reply if you don't have the answer or a question about the topic.:doh::( Do you know anything about creating a data dictionary at all?:doh: Beginner in ASP.Net and VB.Net