VB Forum / VB Syntax / October 2005

I have a small problem that I can't seem to solve.
I have an Excel spreadsheet that is created and filled from my VB6 app. No
problems. Until, one of the reports does not follow my "standard" template.
One of the reports has one table/column block less than the others.

I read the macro about pastespecial datatype = wdPasteText but when i try to
copy text in a different format (for instance a different font) and i want to
paste it into a new document then the above macro will not remove the format
of the copied text.

I have the following property in a ActiveX control
Public Enum DataType
   Currency_Type  '  0
   IntegerNoThousandSeperator_Type    '  1

Either the newserver isn't accepting messages for this group, or
this group is seeing a dramatic lack of use.
If common paths aren't maintained, they can easily get
swallowed up by the encroaching jungle....

I am opening a form so:
       frmA.Show vbModal, Me
at which point the main app icon no longer shows up during Alt+Tab
switching, neither does the icon for the modal dialog.  The borderstyle is

I'm sure this is something pretty trivial but can't seem to figure out how
to do it.
I'm using Generic Lists in quite a few places in my app and for some of them
want to be able to create a ToString method that would return a formatted

I need some help figuring this out. I've tried several different methods,
none of which work 100% of the time.
I am a network admin, so I have administrative rights to all the machines. I
wrote an app that does a network scan for specific running processes with the

I have a text field and I need to substring out characters 2 thru 5 and put
them into another text field.
I am REAL NEW at VB.
What is the syntax to do this???

I have a Sub that takes a ParamArray argument. I want to pass the argument  
to a function with the following signature:
Public Function ReplaceArgs(ByVal Text As String, _
ParamArray args() As Variant) As String

I've a form with on it a picturebox. How can I make the picturebox
transparent, so I can see the form (and it's controls) it's on thru it.
Thx
B.

I am using RegExp with VB6 and would like to search a string with my pattern
staring at the end. Is there a way to do this?
Thanks
marcos

After looking at the sample OfficePlan in Visio 2003 SDK
I can't translate from C# to VB the following statements:
 newEvent = documentEvents.AddAdvise( _
 (CType(VisEventCodes.visEvtAdd, Short) + _

I am writing some vb script that is writing to an excel file.  I have 2
issues with my code below.  The first issue is that when I open the file that
is created, it opens 2 files.  One is named Book1 and the other is named with
the correct name.  When I take out the line that ...

       I just want this bit to check that the specified string ends with pst
which does not work and I want the string "path" to be inserted in to the msg
which doesn't work either. Sorry if this is really lame but I am just
learning.

I am trying to write a program that will create an Excel spreadsheet or open
one that already exists.  I am using the following but I keep getting an
error (Run-time error 1004) that the file does not exist.
Here is the code I am using but what am I doing wrong?