Search results for query: *

Guys...I am writting application in VB to create an Excell spread sheet. User has the option of submit button to begin processing and exit button to close the VB application. I have a dillema which After the process of generating the Excel document completed and saved with all ActiveX...

Guys... I am very impressed and thankful with such replies. I can go to MSDN library and found ShBrowseForFolder and others tool, but they are in all in C++ structures. Where can I go to get the strucure and function written in Visual Basic 6.0. For example the structure for type BrowseInfo and...

Guys.. help me with these 2 question using VB. I have no problem to list a directory or files. But How do you have browse list or sort of a drive list that can shows or do explore list for all follders list such as "desktop, mycomputers, all the drives, and most important the network...

Guys.. Help me with these 2 questions. how do you code a connection to the computers in the network neighborhood. How do you list all computers in the network neighborhood. Thanks

VBSlammer...you have been very helpful and Great. Your reply is very well documented and correct. I utilize it your procedure and it works. Thanks a million. God Bless Thanks

VBSlammer.... I see your correction. However, my need is to solve the following statement that still don't work to save from .Xls to .CSV file. objectExl.ActiveWorkBook.SaveAS FileName:="H:\yan\VB\bamtrack\amex092002.csv", _ FileFormat:=xlCSV, CreateBackup:=False...

All experts outthere help please.. I am trying to convert excel file to .CSV file(Commad delimeted). I build the scripts from the macro test it and works. But it wont work when embended into VB. Here is sample of my code On Error Resume Next . . Set objectExl = GetObject(...

Folks... I am in Southern California at the vicinity of Los Angels County. Is there any VB group meeting or Club that you recommend to join?? Advice me for books reference - any intermediate to Advance level of "VB programming with Excel file" or "VB programming with...

JustinEzequiel.... your answer and example are well documented and perfect. I trully appreciate your kind and quick response. By the way ... any good books that you know as a reference for "VB programming with Excel file" and "VB programming with MicrosotWord - mail merge...

Folks... I believe I found the answer and I test and It works just great. I am open for any further advice, the more is the better Here the syntax in lieu of "objectExcel.Save or ObjectExcel.SaveAs..." The alternate save the excel file to the existing file...

I did you the save method as follow and still prompt me with the message that the file already exist. It does not do the auto replace save. Dim objectExcel as Object . . If objectExcel.FileExists ("C:\work\ExcelFile.xls") Then...

All experts out there...help me please I am writting a simple application using Vb6.0 to access the Excel file, make modification and save with the same file name. And I keep getting a prompt message as follow: The file 'H:\work\ExcelFile.xls' already exist. Do you want to replace the...

I would like to convert excel .prn file to txt using wordpad or word through VB scripts. I want it done in the background mode. I don't want to open the .prn file physically using the following command; 'Use the Shell or ShellExecute functions. 'Shell example: Shell("C:\Program...

Marksweetland... your replied to "Run time error 429" is very complete, absolutely academic and very helpful. I really appreciate your kind heart. I owe you much. And also Much thanks to Tek-Tips which I found it by accident through google. Does anybody know of VisualBasic clubs...

I am writting very basic program which resulting run time error 429. Dim objExcel as Object set objExcel = GetObject(, "Excel.Application") Though some suggested to use errorHandler,this does not really solve the problems; Some suggested missing/corrupt .DLL. and I don't know...