vb6

How to pass security issues in Vista

Hi, We have vb6 application.We are unable to carry out following on vista machine 1. Register a dll from users directory 2. Start another exe 3. Write to a file in users directory. How can I overcome these issues thanks ...

Permission Denied opening an Excel File using Excel 12.0 Library & VB6

I have used Excel in my VB6 apps many times before, and have never run into such a weird problem trying to accomplish something very easy.. I am trying to open an excel (xls or xlsx) file and read through values, as you can probably see. When I try to open the file, I get an error 70 (permission denied) error. The odd thing is that the...

VB6 ADO Connection Pooling

We have a bunch of VB6 apps at our company. We are trying to debug a random SQL timeout error and did a trace with SQL Server Profiler on the Audit Login event. We noticed that the connections were coming in as nonpooled. We use the SQLOLEDB provider with SQL Server 2000 & 2005. I searched the internet and everything I come across says t...

Hex-Value in Visual Basic

Can someone just help me refresh my mind? How do you specify hex values in a Visual Basic 6 / VBScript Source? It's not 0xABCD as it is in C++, that's what I can remember... It was something similar... But what? ...

regular expression for extracting options inside select tag

Hi, I need to extract options in ``particular select tag. Is it possible to accomplish using one regex or I'll have to capture the inner html of select first and then the options? Here is an example of html: <select id="select_id"> <option selected value="">Select Type</option> <option value="1">1</option> <option value="2...

Feasibility of VPN connection using VB6 and RAS API

We have a modem terminal application written in VB6. It works great for what we need it to do, but there is a new requirement to initiate a VPN connection when dialing a particular provider. I've looked over some related posts and it looks like this may be possible using the RAS API. Can anyone suggest resources/advice for working with t...

Writing XML with VB 6.0

I need to write an error log to a XML file using Visual Basic 6.0. Is there an easy way to do this? The error log will contain the error number, source, desc, and a timestamp. Thanks, Jeff ...

What can we do about a randomly crashing app without source code?

I am trying to help a client with a problem, but I am running out of ideas. They have a custom, written in house application that runs on a schedule, but it crashes. I don't know how long it has been like this, so I don't think I can trace the crashes back to any particular software updates. The most unfortunate part is there is no longe...

VB6 Profiler

What is the best free or trial version profiler for VB6? ...

Will Windows 7 support the VB6 runtime?

I can't seem to find a straight answer on this. It appears that Visual Studio 6 won't be supported, but I'm only concerned with the runtime. We have some legacy apps that we'd rather not rewrite, but our customers will expect them to run on Windows 7. If anyone can provide a link to something official from MS on the topic, that would be...

VB6 ListBox Click and DblClick

I have a need to run different code when a user clicks or double-clicks an item in a VB6 ListBox control. When I click on the control, the Click event handler executes. However, I am finding that when I double-click on the control, both the Click and DblClick event handlers execute. Anyone have a good solution for getting just the DblCl...

How to tell if system state is idle asleep etc in vb6

I'm attempting to make my own instant messenger and want the user to go into idle/away mode if the computer hasn't been used in so long. Does anyone have a great idea on how to do this? ...

Is there a tool for converting VB to a scripting language, e.g. Python or Ruby?

I've discovered VB2Py, but it's been silent for almost 5 years. Are there any other tools out there which could be used to convert VB6 projects to Python, Ruby, Tcl, whatever? ...

VB6 code for Reading/Writing Windows Registry values

I'm looking for a good example of reading and writing to the Windows Registry using VB6. Yes, I know there are lots of mediocre examples. I spent an hour googling and testing. Some were incredibly complex, others had only some of the functions, and almost none of it had been vetted in any way (voted on). Since Stack Overflow is intend...

DSN-less ODBC connect string for legacy Sybase Adaptive Server Anywhere

This is a failed response to this article: Sybase, VB and ADO I just did a VB6 project connecting to a legacy ASA 7 database. After failing to use ASAProv OLEDB provider altogether (for one reason or another) and much research, here is the connect string for OLEDB Provider for ODBC shim for a DSN-less ODBC driver connection: Provider=M...

get current mouse cursor type

How do I get the current mouse cursor type? In Windows. I mean - if it's a hourglass, an arrow, etc? I need it even if the mouse is ouside of my application or even if my program is windlowless. In C#, Delphi or pure winapi, nevermind... Thank you very much in advance!! ...

Can .Net custom controls be used in VB6 form?

I am doing some maintenance on a VB6 Windows application. I have a .Net custom control component that I would like to use on a VB6 form. Is this possible? I know how to access non-visual .Net components from VB6 by generating a COM type library for the .Net DLL, but can a .Net custom control be used like a .OCX from VB6? If so, how is th...

Profiling a COM application?

I have a big application written in Visual Basic 6 and I need to profile it. Is there something like ANTS Profiler but for COM applications? ...

Deployment in an agile environment

In the past my development team we have mostly done waterfall development against an existing application and deployments were only really done towards the end of a release which would normally result in TEST, UAT, PROD releases normally only consisting of three to five releases in a two month cycle. A release was an MSI installer, depl...

To Extract/Display Macro (VBA) from .xls files using VB6 (without openning Excel)

Hi all, I understand it is possible to do so using excel macro, see: http://stackoverflow.com/questions/49724/programmatically-extract-macro-vba-code-from-word-2007-docs But What I want to do here is to use VB6 to make an application which does the same thing. I am having problem on how to point to the excel workbook (thisworkbook.VBpro...