I have an OLE link to an Excel spreadsheet. It works fine in my VB5 app.Once my user has updated the spreadsheet, I wish to retrieve some values from specific page/row/columns of this psreadsheet for use in my VB app.Could someone point me in the right direction please?I have searched the docs and c...

I have an OLE link to an Excel spreadsheet. It works fine in my VB5 app.Once my user has updated the spreadsheet, I wish to retrieve some values from specific page/row/columns of this psreadsheet for use in my VB app.Could someone point me in the right direction please?I have searched the docs and c...

Is there a need to spawn multiple threads in a simple VB app that just scans ports using Winsock?

Is there a need to spawn multiple threads in a simple VB app that just scans ports using Winsock?

Hi,How can get the decimal separator from the international settings ??I've an Error#13 in a small application using external file sended to a french friend which has the , for decimal separator - unfortunately the file generated contains . as decimal separator - actually I trap the error #13 b...

In the application I am developing, time and speed are very important.In the analysis we have conducted, we found that VB's InStr is considerably slow.I would like to know if anyone has written a function that does the same thing as VB's InStr but faster?Thank you, and please forward me an...

I have strange errors occurring when I want to run VBA-code inside Excel when the Excel-file is an application-object in Access.Access-Code is like:> Dim objExcel As Excel.Application> Dim wrkBook As Excel.Workbook> Dim strDokument As String > strDokument = "d:\...\test.xls">...

I've made a hardware that send data (bits) to PC using serial port.<br/>I use 4 bits of data.<br/>I know the pins which is used to send the bits to PC (using pin number 10, 11, 12, 13, 15, 16, and 17).<br/>Thanks.

I've made a hardware that send data (bits) to PC using serial port.<br/>I use 4 bits of data.<br/>I know the pins which is used to send the bits to PC (using pin number 10, 11, 12, 13, 15, 16, and 17).<br/>Thanks.

I want to change the way the system formats the date in the registry. If a users setting default to m/d/yy I want to change it to mm/dd/yyyy.<br/>Thanks<br/>Rick

When listview control is updated frequently and randomly it flickers too much.Since only one row is updated, WM_SETREDRAW message makes no difference as after updating one row the display is enabled.I did use listview messages like LVM_SETTEXT etc. to change the listitem and subitem values. But, lis...

Hi!!!Wondering if anyone have experience in converting Visual Basic 416bit systems to VB 6, 32bit. I understand that VBX controls, especiallyfrom third part vendors, can cause problems. What other problems,pitfalls are there? Brief descriptions will do, no details necessary.Thanks in advance/Johan J...

I need to retrieve the System Font Size so I can scale the app to fit the screen. I have used GetSystemMetrics to find out the resolution of the screen and scaled accordingly but by using Large Fonts a screen can change its displayable area. I have coded for any screen size - the customer is using 1...

Hello All: I am working on this project which get the information from serial port using DOS program. Problem is when I run my program(vb program) and Click on Sen(to send data to dos program which is running, it says (Frozen in window down in my toolbar), but if i bring the Dos window in full scree...

How do I make crystal reports print a report between a certain date. The one<br/>that I have tried out so far is [in Date " & Beginning & " to Date " & Ending]<br/>but it doesn't work. Please help. This is urgent. Thanks.

How do I make crystal reports print a report between a certain date. The one<br/>that I have tried out so far is [in Date " & Beginning & " to Date " & Ending]<br/>but it doesn't work. Please help. This is urgent. Thanks.

hi,<br/> any body have any idea of how to read .BMP file using 'c' language ?

Installation programs, generated by VB6 Package Deployment Wizard for Visual Basic Projects fail during startup with message, like this: "Invalid line in setup information file!Section: Setup1 Files@ODKOB32.DLL,$(WinSysPath),,$(Shared),6.18.98 12:00:00AM,16896,4.0.81.69"I have VisualStudio'98 S...

In the Module, I haveDim X As CAutoSet X = New CAuto and uses X to do something.After that I call a form. In this form, I haveDim WithEvents X As CAutoSet X = New CAutoCAuto is a DCOM objectIf CAuto is in the same PC with client, there is no problem happened.If CAuto is in the different PC with clie...

Hi Everyone,I would like a program that can create global and local groups in NT and then assign users (with passwords and all) to these groups. Also, I would like to set permissions on files and folders dependent on the groups I have created. How do I do this?Your help will be appreciated, thanks i...

Running Oracle sql scripts. Would like to dump contents of STDOUT to a console and to a text file. I've done the console portion of it. Need help with the text file portion. Thanks.

Hi there Gurus...The thing is that i vant to launch the Dial up networking Dialog as follows...Dim lDun As LonglDun = Shell ( "rundll32.exe rnaui.dll , RnaDial " & "Tele2" , vbNormalFocus )And it works fine... but i also want to specify som agruments like Password and UserID.I tried to look in some...

I am not familiar with VB. As I understand, in c++ at the point of the execution of a return statement within a function, the program exits the function returning that value even if there is more code that can be executed. Is this true in VB

I am not familiar with VB. As I understand, in c++ at the point of the execution of a return statement within a function, the program exits the function returning that value even if there is more code that can be executed. Is this true in VB

I have a form with bound controls to a data source.The text and list controls work ok but I can't seem toget the option button to update when I change records.What it the best way to update the option buttons andcheck marks when changing to a new record.Thanks for any replies....

I have a form in which I have displayed many shape controls ( All the Shape Controls are in a single control array ). When I right-click on a Shape Control I display a PopupMenu . It works.But when I go to another Shape Control and Right-click nothing happens. The previous Pop-Menu remains. I am not...

Anyone had any experience converting Intuits Quick Books <br/>data files to an Access.mdb

We have multiple programmers working on different modules of the same VB<br/>project. Apparently in Visual SourceSafe only one programmer can be working on<br/>the project at a time. Is there a better source control solution out there?

Can anyone tell me how to change the color of the text on a button?

Can anyone tell me how to change the color of the text on a button?

Hello,I recently got Help Workshop from microsoft. Unfortunately the instructions included aren't very clear on the process of makeing a help file. Also, there are no example included with the package. Does anyone know of a website that has instructions or tutorials on creating help files with...

Hi...<br/>I'm searching for patches maker for VB. Perhaps you can tell me what patcher is the best and where can I can I get it or download it?? Thanx!<br/>Pamalite<br/>PS It will be better if the patcher is a freeware!

I have a ListView Control in a form and I display many items similar to the Network Neighbourhood View on Windows NT.Each Icon carries some text . <br/>How do I Change the color of the icon ? I am able to change the font of the Text .<br/>Thanks in Advance<br/>Anand

I am using the ShellExecute API to execute a program that needs to be active prior to the logon screen in my VB6 app is shown. However,when the logon screen is shown I am unable to start typing into theusername textbox, I must first click the textbox. In the activate event of the signon form I am se...

Hello!I'm using Crystal Report 6.0 with Cristal Report Viewer and need to set a new data source for the report and its subreport.How to use SetDataSource from the Report and its Subreport to my Recordset. I know what to do for an report without a subreport but for the two, no.Thanks...

Does anyone know how to do a scrolling form?<br/>I used to use a VBX from Sheridan called VBASCroll - came with VBASSIST<br/>I dont have access to an OCX. As powerful as VB6 is I am hopeful that it can be done within the VB6 environment<br/>Thanks for any help<br/>Rob Hermans

Does anyone know how to do a scrolling form?<br/>I used to use a VBX from Sheridan called VBASCroll - came with VBASSIST<br/>I dont have access to an OCX. As powerful as VB6 is I am hopeful that it can be done within the VB6 environment<br/>Thanks for any help<br/>Rob Hermans

Hi: there<br/> How can I compare date in vb?<br/>I only compare date not time, it's really trouble that I have to format<br/>long time to date, but I can't comare two string?<br/>any ideal?<br/>thanks<br/>George

Hi , I am using TreeView control , I have to display all the selectd server networkdirectories in the treeview control , Currently I am using Common Dialog control ,but in that It's displaying all my local machine directories , but i want to display all the current servernetwork directories ....

TELL ME ON USING MSGRAPH IN VB

TELL ME ON USING MSGRAPH IN VB

How do i read the default path to the application that has been set as default for a file with a extention.<br/>Example:-<br/>If i pick up a file with say a .bmp extention how do i check the registry for the correct name and path to the associated application.<br/>Thanks

How do i read the default path to the application that has been set as default for a file with a extention.<br/>Example:-<br/>If i pick up a file with say a .bmp extention how do i check the registry for the correct name and path to the associated application.<br/>Thanks

I have some process happening in Form1 and I want to display another form above this form.This is similar to the Task Manager. When I kill a process , the Clock Screen appears and at the same time the Process is killed. If I try to start or stop a service and at the same time try to run a modeless f...

I have set up my application so that it can be used 15 times. The registry entry records the number of times and after 15 the game does not work. Could anybody tell me how it might be possible to give the user a key that would remove the registry entry so that the user could continue using the appli...

how can I print reports created in Access 97 from VB6 without loading Access?

I am looking for some help converting a "short" API function,printing textbox data to the printer exactly as seen on screen.The following code works in VB4 16 but not in VB4 32.The printer spools takes the paper and spits it out but does not print any text.I'm using a Form, textbox, Bas module,...

Hi, Is there any support in ActiveX controls to save property at run time like in ActiveX document. I want my control to persist all its properties on users machine.

While connecting and closing is a no problem, but once i .close and want to reconnect ( .connect ) again, somehow the other side wouldnt want to respond to my .connectDo i need like to initialize something or close some other function before reconnecting ( .connect ) again?Client connects to server....

hi<br/>has anyone Cleared the Vb 6.0 Microsoft exam. <br/>regards<br/>Mathew Cornelius