Recent content by VisualBasicHelp

Hi, I would like to checkout a file from VSS, modify it and then check in back. How can I do it through VB . Thanks in advance

Hi Prgrmr, I know to program in VB. But am not so comfortable with the advanced VB. Please, can you detail, how can I find the version, considering me as a starter. With regards

Hi, How can I find the dll version, of a particular class, installed in my system, using a function/procedure. Thanks in advance

Thanks guys, for providing a better way of doing the code. Really appreciated.

Thanks Harley. This code is exactly what I actually needed. Many Thanks

Thanks Harley. Actually, I would like to run a task everyday, from today, which will check whether , it is the first monday of that particular month,if yes then it has to send a file.

Hi, How can I find the first monday of every month. With regards

Hi dippncope, I have tried this software and other softwares also. But I think, they don't give me the facility of replacing the existing image with another, keeping the same file name, as earlier. For eg. by mistake I capture one page, but later on I realize, that it should be another page...

Hi, Is there any available software, which can take the screen print while browing through HTML page/ sql query analyser or any other application running in windows (only print screen required page) and save it in a file automatically. I have tried wink and snagit. But it didn't server my...

Thanks . It worked. I tried with another excel sheet, it was working. There might be some problem with the existing excel sheet, now I have to find out that. Thanks Harley

To clear up the objects, I have added the code. Now this is my full set code- Dim xlApp As New Excel.Application Dim xlsheet As Excel.Worksheet Dim xlBook As Excel.Workbook Dim xl As Excel.Workbook Dim nRow As Integer Dim flag As Integer List1.Visible = False...

I have put a message box before closing the excel to show the value in that cell, at that time it correctly pops up the value. When I open the excel sheet manually, it has not been reflected there.

Thanks Harley, I changed Application to xlApp, but still the value is not getting stored in excel.

Hi hmckillop, I tried your code like the following, but when I open the excel, the value is not getting stored - Dim xlApp As New Excel.Application Dim xlsheet As Excel.Worksheet Dim xlBook As Excel.Workbook Dim xl As Excel.Workbook Dim nRow As Integer Dim flag As Integer...

Hi, I am trying update an already existing excel file through VB 6.0 . But when I say objExcel.Save, it shows me another dialog box, saying, "this file already exists, whether you want to replace it?" I don't want this dialog box to appear, it should be saved automatically. Please let me know...