Hello-
I have an Excel 2003 file being run in Excel 2007. For some reason, there is a reference link to Microsoft Excel Object Library 2.0. I am unable to 'uncheck' the reference as Excel s...
How do I show column headers for a Visual Basic 6.0 project. Below is snippit of code that populates the listbox with the recordset. The column hearders do not have to come from the databas...
I am trying to learn about using XML (reading / writing XML files) in VB6 by running a sample I found. The two statements related to the XML object that execute are:
Dim objXMLDOM As Ne...
When loading VB6 project I get the error File not found c:\windows\system32\ieframe.dll - Continue loading project?
What can I do to stop the error without pressing yes to continue loading ...
Hi .
we have created a template mail from access that uses vb code to send the template mail via outlook , some of the people in our organization wants to use this template to enter text in...
The code below loads a range into array where BAarray is a multidimensional array BAarray(1 TO 10, 1 TO 250)
I want to test BA(x,1) and if it is not an integer delete the entire element or...
How do you pass an array as a parameter.It should be simple but I am getting a type mismatch error. this should be simple but I have tryed a number of differant senarios.
I need some advice on how best to code event handling using VBA within MS Excel.
I have 1 workbook, with say 20 worksheets. Each worksheet is linked to a 3rd party app where the 3rd party a...
i want to learn jacob for doing tasks with excel. looking for any simple code using jacob and excel which runs without errors. i tried running the code in jacob help but i'm getting errors. to...
Hello,
I am writing a Windows application using VB in Visual Studio 2008. My application form has a TabControl to respond to navigation requests in the menubar and toolbar.
Due to RAM i...
badly need help, i need to produce the same output below in XML format using XML Objects thru VB.net 2005
http://biznetnetworks.dl.sourceforge.net/project/asteriskconnect/asteriskconnect/ConMan%20v.2/AstConManv2.zip
I downloaded this library collection. But I have a problem I can't understand...
I have a sql code that is created using TOAD, and I want to create a macro that will extract the data directly to excel. A sample code will do so that I can change the userna, datasource and p...
I am learning VB 2008, I would like to get a code to make a label or textbox font size bigger on a mouse over event.
I tried the following but does not work
Dim SZ As Integer
...
Hi All,
in order to make my application flexible I'd like to set object attributes by reading attribute name and values out of a table.
During runtime the attribute will be set by a value fr...
If I get the immediate box to print TxtBox.Text I get the value I input in the Text Box, as expected.
But if I set a variable Textvalue =TxtBox.Txt and print the value of Textvalue I get n...
I am using a textbox for the "Forms 2.0 object library" so that it will display Unicode Chrs.
But I need to be able to set the right margin, and don't see a method do it.
Can't send a EM_S...
I need to search 1 folder for the newest file. I then need to write out the file name with a line:
set sFilename = {"XXXX"}
where XXXX is the name of the file.
I need to have the file na...
Hi,
I want to run code only the first time a new workbook is created. In MS Word this can be accomplished using the Document_New event. Excel doesn't seem to have a similar event, but is th...
Hi
I am having trouble with a tiny aspect of a macro I created (it's probably really simple but I can't figure it out!).
Basically if you see the code below, you can see that I have refe...
I have a list of objects in a property on a class that I would like flattened in the other properties of the class. In the class below I want to parse the items in "addressList" and place ther...
How to implement bar code reader in VB6.0?
