Search results for query: *

Hi, The Excel is not closed after calling the vb code below. Help, please! Dim xlObject As Object Set xlObject = CreateObject("excel.application") xlObject.Application.Workbooks.Open "C:\Report\Report.xls" Worksheets("report").Activate ...... Worksheets("report").Cells(1, 2).Value =...

Hi, I got the error "Run-Time error '-2147024894 (80070002)': Method '~' of object '~' failed" when I run the following program: (MyProgram.exe is a VB executable) Dim objWsh As Object Set objWsh = CreateObject("wscript.shell") objWsh.Run ("C:\MyProgram.exe") Set objWsh =...

Hi, Everytime I run the following VB program, a WINWORD.EXE process is started. How could I terminate WINWORD.EXE? Thanks in Advance! Private Sub ModifyWordDocument() Dim strDocumentPath As String strDocumentPath = App.Path OpenDocument strDocumentPath & "\student0.doc"...

Hi, How can I read a command-line argument into VB6 program? i.e. c:\>myprogram.exe para1 Thanks in advance!

Hi, I want to use VB app to call VBA module in an Access database. Can someone please help? Thanks in advance!

Hi, FrameA is always visible and a PictureBox is only visible when a field in FrameB has focus on it. After the field lost focus, the PictureBox will become invisible again. Right now FrameA is on top of the PictureBox. Is there any property I can change to make the PictureBox on top of FrameA...

I want to count the number of records in a word document datafile. I don't know why it didn't returen the number of records(there records there) but always -1. Can someone point out what is wrong with this? Thanks in advance.

Hi, How can I use VB to open a word documnet and save it as a text file? Thanks in advance!

I am working on MS Word mail merge and trying to get a field (which has multiple values) from the data source file and then check if the substring of this field contains a text, if true then insert some messages into word document. The macro code below does not work. I always have problem with...

Hi, I can use GetTickCount to get the boot time for my machine. Is there a way to get the server boot time? Thanks in advance!

Hi, can I call a SQL Server 2000 stored procedure from vb6 using DAO? Thanks in Advance!

Hi, the scheduled job ran OK on Windows 2000 Professional for a couple of days. After I modified the program run by the job, it had problem last Friday and the status was "Could not start". I rescheduled a run at 1:45pm. Nothing happened --- Last run time was still last Friday. I...

Hi, we need to shutdown Windows 2000 in VB6. This program will do backup each night and then shutdown the workstation where the program resides. Thanks in advance!

Hi, the row section in an Excel pivot table, which reads data from an Access table, looks like below: Sex (drop down list) F M (blank) How can I change it to the follwoing without changing Access table: Sex (drop down list) Female Male Missing Data Thanks in advance!

Hi, How can I add page break or smething like that to a form so that each record is started on a new page when printing them out? Thanks in advance!

Hi, I removed a field from Access form. The form worked fine. But after I delete the corresponding column from the underlying table, then the Msgbox pops up when I open the form, asking to "Enter Parameter Value" for this deleted field. How can I get rid of the Msgbox? Thanks in advance!

How can I populate today's date auotmatically in Access form? Thanks!

Hi, I am tring to create a data entry form for 5 tables using Access 2000 wizard. An error message box saying "The wizards is unable to create your form" appears and the form is not created. However, if I use 4 of the 5 tables, the form is created ok. Please help. Thanks in advance!

In word 2002, The replacement for TAB is ^t, for example: .Replacement.Text = "^t". Does anyone know what character used for return key in word? Thank you very much for your great help!

I am working on a project that convert mail merge document from wordperfect 6.1 to word 2002. I figured out most of the problems. For some, I could not work it out. Please help me out. Thanks in advance for your great help. My first problem is: In wordperfect, it uses "Variable" to...