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

I am using Microsoft Access 97. I am programming the forms using visual basic that comes with Access 97. I am trying to get a certain date in a certain format but can't figure out why it doesn't work. I am updating an excel document. Dim strDate as Date strDate = Format(Now, "mmmm d, yyyy") objSheet.Range("H9").Value = strDate this produces 2/16/2005 I am trying to out put February 16, 2005 What am I doing wrong? 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

How is this coded in visual basic 6? I have gotten everything but this. copy coversheet1 from test.xls in c:\test directory paste or create coversheet1 to test2.xls in c:\test2 directory both excel documents exist but I need to transfer a sheet from one document to the other. Any help would be greatly appreciated. Thanks Beginner in VB.Net

Is this possible? copy coversheet1 from test.xls in c:\test directory paste or create coversheet1 to test2.xls in c:\test2 directory both excel documents exist but I need to transfer a sheet from one document to the other. I am using visual basic 6. Any help would be greatly appreciated. Thanks Beginner in VB.Net

I am trying to copy one sheet out of an excel document and paste or create that sheet into another excel document. How in vb6 is this coded? Thanks:) Beginner in VB.Net

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

I have downloaded the framework 1.0 sp2 and installed it. How do I use it in my deployment project?:doh: Is there something I am missing here? Beginner in VB.Net

How do I do that? I need to figure out how to check if the computer has framework 1.0 and if it doesn't install it. It tells me that Dotnetfx.exe can be redistributed with your setup. How do you do this? Thanks:) Beginner in VB.Net

How do I check to see if it does and if it doesn't install framework 1.0? Dotnetfx.exe can be redistributed with your setup. How do you do this? Thanks:) Beginner in VB.Net

This is my first time deploying a windows application. I am able to deploy it correctly but I need some help with deploying it to a computer which doesn't have the .net framework installed. I am using visual studio 2002 with framework 1.0. Most example's only explain the framework 1.1. How is this done? Thanks:) Beginner in VB.Net

Hi Am I creating a new file called settings.ini or am I modifying an existing one? What is the file called that automatically installs .Net? If you know where it is just send me an email and attach it to the email (timothy at myactv dot com). Or if you can remember the link from where you got it, you can send me that too. Thanks:) Beginner in VB.Net

I am using Visual Studio 2002 Framework 1.0. How do I use the installshield? Again this is my first deployment so any examples would be great. Thanks:) Beginner in VB.Net

This is my first time delploying a windows application. I was able to deploy it to a computer that has .net installed but how do I deploy to a computer without .net installed. I think I need to add dotnetfx.exe to my installer but don't know how. Are their any walkthroughs out their that are simple to follow for a first timer? Please help. Thanks in advance, Beginner in VB.Net

Well my MS Access database has one column that is NUMERIC and can only contain NUMERIC figures. For example, 5623659899 can't be 562-365-9899. There for I don't know how to take the 10 digit number and display it in a datagrid using the "-" to make it look like a telephone number. I'm not sure how to do this myself. If you want too, I can send you the project for you to look at. Just let me know. DataGrid1 should produce Last Phone Red 123-456-7895 instead of --->1234567895 Blue 456-895-5698 --->4568955698 Yellow 458-652-1452 --->4586521452 Green 562-123-0258 --->5621230258 Please let me know if you want me to send you the project or if you are still unclear as to what I am trying to do. Thanks,:) Beginner in VB.Net

Is it possible to format a column in a datagrid using VB.Net to replicate a phone number? I am getting either a 0 or a ten digit number. I would like to display the ten digit number as a phone number in the datagrid (ex:123-456-7899). Is this possible?:doh: Thanks in advance, Beginner in VB.Net

Is it possible to mask a column in a datagrid using VB.Net? I am getting either a 0 or a ten digit number. I would like to display the ten digit number as a phone number in the datagrid (ex:123-456-7899). Is this possible?:doh: Thanks in advance, Beginner in VB.Net

Thanks a million:-D Beginner in VB.Net

Does anyone know how to use an if statement in VB.Net to catch if a user enters a character instead of a number?:doh: The user should only be entering numbers in a textbox and if they enter a letter, I want to catch it. Thanks in advance:) 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