VB Forum / General 2 / March 2007

I am tring to automatically create and name new worksheets in excel using
VB.
I have found out how to  create and name sheets but I want my sheets to be
named after consecutive months - so at the moment I have a long "If then

I am tring to get the name of the last sheet in a workbook but have
obviously got my syntax wrong somewhere - this is what I am using;
If Worksheet.Name(Worksheets.Count) = "Jan" Then
this gives an 'object required' error - can anyone help me find the right

Hello to all out there,
 I need some help for some testing: I have 5 categories that could
either be a Yes or No.  The order isn't important so it can be any
combinations of Y OR N for 1 set.  I used the combination formula to

I have a form with a large number of (input) text boxes.  The input data is all
numerical.  After entering a data point, I would like to be able to press the
*Enter* key and have the focus move to the next tab position.
From the help files:

Does anybody know how i can print a range of websites from code? The
URL of the websites are listed is in an text file or in a access
database table. Accessing this data isn't the problem, printing the
url is.

Can anyone point me to the right direction/s.
I have this one machine that is connected to an optical device, where
the vendors of this machine won't allow us install anything on it
except printers drivers.

In all my VB.NET 2005 routines, I already inserted a Try...Catch routine in
order to handle my errors.
Is it possible - despite the presence of the Try...Catch routine, to let the
program break on every error thus giving me the opportunity to adapt my

In all my VB.NET 2005 routines, I already inserted a Try...Catch routine in
order to handle my errors.
Is it possible - despite the presence of the Try...Catch routine, to let the
program break on every error thus giving me the opportunity to adapt my

Just got an Idea for a tiny little utility
I want to write...
I have 8-10 network shares listed under
"My Network Places" (WinXP)

I want to store an error in the logfile. but i want to know the
Definitiion af logmode.
Pllzzzz Help me.  Thanks in Advance,

am new in VB programming. I am doing a macro in excel and wonder if
there is good way to use additem function to add data to combobox.
I have a long list of comboboxes to fill in with the same entries.
Right now I use new additem list for every combobox, although content

Vista seems confused about what GMT is:
my date/time is 3/27/2007 5:14PM in GMT -8 Pacific Time (US & Canada)
if I set the additional clock to both available GMTs:
GMT (Greenwich Mean Time: Dublin, Edinburgh, Lisbon, London)

I prgramatically save a PDF document as text using automation.  I then
process the document in VB.
However, my client now has one of his clients sending an image of a
document in a PDF file.

Over time I have installed evaluation controls for demo purposes in VB. Some
I have purchased, some I have not.
The ones I have no use for I have removed via Add/Remove Programs.
However, many still seem to appear in the list of components from the

I've worked a lot with Access Databases and can use the NZ function.  When
adding two fields together if one is "non zero" then the two will still add
ok..... However, NZ is not a function recognized in Visual Basic.
I'm building a program in VB 6.0 to use with my Access Database ...