Hello Experts,
Using VBA, I'd like to know how to search for a value in a column (say column E), then activate Cell A for whatever row the value in column e was found on. Let's say I ...
We currently use Sophos Anti Virus but an earlier version seems to be corrupting our machines so we have to uninstalll the older version and install the latest version.
What i'd like is a ...
how do you declare a global variable in VBA for excel that can be used in each sub routine?
can you explain this with an example? including how to declare it, initialise it, and use it in e...
anyone know of any good ones?
Hi . . . I found an article that describes exactly what I want to do: setup a scheduled task to request a URL. The article describes a lightweight script that can be used to make HTTP request...
First, I'm brand new to visual basic. I used to program quite a bit in Java, but it's been a few years. I recently downloaded and installed Microsoft Visual Basic 2008 Express Edition and ha...
Anyone know what I'm doing wrong? I want to export the user accounts and last logon to an excel spreadsheet ... out of Active Directory ... below is a modified version of my script.
Thanks,...
Forgive, I am not sure where to ask this. Please point me in the right direction if this is not it.
I have an application that I am running on a Citrix server (Windows 2000 Adv Server, SP3...
I have the following code:
Public Type t
name As String
section As String
End Type
Sub testing()
Dim c As New Collection
Dim rec As t
rec.name = "bob"
rec....
I'm having some problems with ShellExecute command in VB.net; even though I have read dozens of ShellExecute examples I can't seem to make it work. As it is, I bought the .net software just tw...
Hi. Using VB6 Pro SP 5, I want to get the currently logged on user of a remote PC by IP address on our WAN. I don't want to query the registry as my local logon may not have admin rights on t...
i created a simple project using visual basic 6.0 .
Here i want to register a dll (given the path of dll). I am trying to use
regsvr32 "C:\ABC\ABCDLL.dll"
but it's not working. I am look...
Hi all ..?
i developed a software in vb 6 and now i want to put some security in Instalations or running on my clien's machine..
tel me how can i get a Motherboard or CUP serial number throu...
I have written an Excel 2003 VBA macro to save an Excel sheet as a CSV file locally. I then want the macro to upload that CSV file to an FTP site using a hardcoded id & password.
I created...
I am utilizing a Timer in VB6 to wait a specified amount of time to look for the presence of a file on a server. This is my code:
Dim startTime As Double
startTime = Timer
Do While (Timer ...
Thanks for any help! I get this error when running the code:
ERROR:
"The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered."
Code line where error occurs (line 10 in s...
I am trying to use the "LIKE" operator to test a string
According to what i have found out "LIKE" should use regular expressions but..
I tried ..
"\sTE*" (example only)
to get ...
i have a form in my Vb application in that i have four fields as Startdate, EndDAte, StartTime, EndTime
i want to use Datepickercontrol. when user is going to create a new record he going to...
How can I determine the location of the system32 directory using VB? Do I need to read the environment variable WINDIR and then add the string "\system32". How would i do that? Or is there a s...
I need the following VBS code to start cmd.exe in either a minimized window or a hidden window:
Wshell.Run "cmd.exe /C" & chr(34) & "reg.exe query " & regPath & " /s >>" & filePath & chr(34...
I am writing a program in Visual Studio 2005 (VB.NET), which will need to open a Word Document and insert data into it from a database.
I have done this with VB6 and Office 2000 with no pr...
I am using following three ocx's in my application
a. comdlg32.ocx( Microsoft Common Dialog Control 6.0(SP3))
b. mscomctl.ocx (Microsoft Windows Commom Controls 6.0(SP4))
...
I have code set up to download information off of a Bloomberg terminal. Column A consists of CUSIPS and SEDOLS, which I use in BLP formulas. Because I have roughly 10,000 Cusips, the download ...
Hello...
Anyone know how to encode/decode the passwords
in .htpasswd (Apache Webserver) file ?
A piece of code will be greatly appreciated.
Thanks in advance.
Miranda
myr@dnet.net.id
I know and have VB6. I haven't been successful in locating a routine. This is urgent, for a work project. Thanks, Russ
