VB Forum / VB Syntax / March 2006

I'm moving from VB6 to VB 2005. Two questions:
1. One book I'm using has syntax like
   Dim testConnection as SqlConnection = New
SqlConnection(connectionString)

hi everbody
i am trying to use sheel function at activate wordpad through vb
is there any way to use properties of wordpa?
myobj=shell(pathname,windowstat)

I run this code to list all the CD tracks from the My Music Library the
FileName is hard typed into the program like:-
FileName = Dir("C:\Documents and Settings\Ron\My Documents\My Music\The
Artists Name\The CD Name\*.*")

how to get user path in VB6 code base on their user profile ?
thks a lot
suwon

  I have an .exe file in for which we do not have the source code.  The
.exe was written in vb 5.
The program is very important to us.  Is there a wasy we get to the source
code from .exe file.  

is there any function in vb lke between()
e.g if between(a1, a2,a3) then
      some code
    end if

i have several textboxes. When 'ok' is pressed i need to findout if the
value is a string or an integer and then do what ever i need to do...
how do I find out value type?
i tryed:

I have an excel sheet with information as below:
s/n|Surname |First_name |Picture     |Rt_thumb   |Lft_Thumb
1  John         James        d:\aaa.jpg  d:\bbb.jpg    d:\ccc.jpg
2  Festus      Kujore        d:\ddd.jpg  d:\eee.jpg    d:\fff.jpg

I have written a screensaver, but I need to change the file name to an .exe
and then to a .scr i think.  I am unsure of how to do this... If anyone could
give me some help to convert my screensaver into a file that can be
recognized by the properties menu on the computer that ...

Is there any method that I could use to save a webpage as an image even if the webpage is larger than the screen?
Thank you

I don't know if I am in the right area or not, but I have a little calender
program that a friend wrote and on some computers the first day of the week
starts on Sunday and on the others, it starts on Monday.  There are 4 files
that make up this program, a .EXE, .FRM, .VBP, and  ...

I'm banging my head against a wall here. I'm trying to get the Shell()
function to execute a particular command-line, and failing. The command line
is:
   CMD /C  "path\tool.exe" param 1>stdout.tmp 2>stderr.tmp

I am converting an EXCEL VBA application to Visual Basic (2003).
I am not having much luck finding how to convert statements containing
references to things like ThisWorkbook.Sheets("sheetname").
I am not using Visual Studio Tools (which may be my problem)... I would

hi
I have a text file like ;
acNo   name  amt
acno=space(10)

I am new to VBA- specifically in excel.  I am able to open file, read
file, and close file.  Each line read has several “cells” of data.
However, the testfile.txt is comma delimited.
Basically, I have a database.txt file which contains information that I