Hello,
I need to parse a comma-delimted string into an array using VB Script. However there is a catch, some of my entries are embedded within single quotes. If the the comma is within th...
Hi experts,
i have a problem with a vba macro in excel! Some entries from column "A" and "B" shell be filtert and added to column "D" and "E"
In column "A" and "B" there are entries like t...
my oracle table has some null values.
how do i check for null value in a filed in vb.
i tried :
if rs.fields(0).value is null
if rs.fields(0).value is empty
if rs.fields(0).value i...
Hi all.
I'm trying to create a VB function that will read the last line of a text file(input.txt) and then writes the contents of the line to a new text file (c:\output.txt)
I want to r...
For example you can use IsEmpty() to check if a variable has not been initialized. In VB6 how do you check if an object is set to nothing?
Thanks!
Is there a way to close a program in VB6 with only knowing the file name "AL-Admin.exe"?
I have a way to close by caption but not by file name.
Public Sub CloseProgram(ByVal Caption As S...
Hey everybody,
My code is actually a vbscript, but I couldn't find it in the languages. A VB or vbscript solution would be fine with me.
My script launches a dos.cmd file using a Shell ...
Hi experts, the following code works fine on 3 machines so far. But others I have tested on give me a runtime error 52. Bad filename or number. Any ideas?
Here is my code...
Private Sub ...
Hello, I'm trying to figure out how to work FindWindow properly.
This coding works in general.. What it does is find a textbox, and add some text to it.. I found it on this site somewhere....
Hi guys was wondering if anyone knew why i cant get this code to run?
Cheers
Nathan
Hello All,
I am trying to write a vbscript that will map network shares for my users. The easiest way for me to automate the process for my users is to use a drop down box and allow them t...
Hi,
This code I am executing in MS Access 2003 ----Module
In my code listed below.
In Access db
I created table1 ----tblDBlocation
Table2-----tblLinktables
In table1 I am s...
hi
the following script does the job (sends ESC to the app and causes it to exit) IF i dont focus on a different window between the moment i run the script and the app is finished starting....
Hi,
I have been looking at ways of detecting USB device arrival. I have searched high and low and have come up with the following. Using Subclassing of WndProc() I have manged to receive a ...
Can any one give me character code for OHM Symbol (). I tried in Character Code sets in MSDN help but I couldn?t find it.
I will appreciate any help on this.
Thanks.
Hi,
I need to insert a PDF file into a SQL Server 2005 varbinary(MAX) field using Visual Basic 6. I have successfully coded a different C# application to do this by loading the file into a...
I need a vbscript that will take a text file that has data that looks exactly like the following (the ... is just to note that there can be many names in the list, it doesn't actually appear i...
how to Make a CAB file & Extract it?
without using the Makecab.exe, i want to make cab files and extract also (like in vb packaging & deployment).
Hello,
I have a string value that I'm sending to MSExcel cell to display. The problem is that Excel is truncating trailing zero's when I don't want it to. I tried several different cell ...
Hi,
I have created a VB class and during the running of my program many instances of this class are created...Is it possible to add these 'objects' (only of one Class type) into a VB Dictio...
I have created an outlook autoemail from within MS Word
with the following code(thanks ee) :-
Public Sub insert_attachment()
On Error GoTo PROC_ERR
'Get path and filename ...
Hi,
I am working on an intranet page to launch excel.at the time of creating the excel sheet its giving a pop up window saying
'An activex control on this page might be unsafe to intera...
I'm trying to write a file listing from a specific directory into a txt file which will be used at a later point in my code. To do that I'm using a .bat file that I call from within my proced...
i have to calculate certain things in my vb project... there fore i need to use the floor function, however when i run it in my computer it gives an error 35: sub or function is not defined......
Hi,
I'm pretty new to VBA and have written a small function that aims to Vlookup in a range of cells and return a true or false, I've shown it below.
Two problems, a) how do I use the fu...
