VB Forum / VB Syntax / June 2004

What _exactly_ is the syntax of the string that CLng will accept without
throwing an exception (an "error" in VB speak)?
where is this documented?

I have recorded the following macro using Excel. Cursor was in cell E7
   Selection.Cut
   Range("E5").Select
   ActiveSheet.Paste

I am completely new to VB (have been using MS Access with an SQL Server
backend).
In access I have a report with subreports where each report is based on a
table that is populated at runtime with the necessary data.  Subreport is

I use a couple class modules in my projects to speed development and am
looking to do the following:
Private mvarFieldObject as Object
Public Property Set FieldObject(ByVal vData As Object)

i'm a student informatics and i'm busy with a music database project.
I've a database with all my songs in and i want to play them with Windows
media player.
So i have a listbox, when i select song they stand in that lisbox and when i

I need to launch an external application using the Shell command. However,
this particular application needs to be run from it's current location or
will not launch properly. For example, this won't work.....
shell environ("comspec") & " /c " & """C:\Program Files\Some

Set WordApp = CreateObject("Word.Application"
Set CurDocument = GetObject("c:\MyFile.doc"
CurDocument.SaveAs FileName:="c:\MyFile.txt", FileFormat:=???
Anyone know the keyword to save a Word Document as a Text File

Is there a way to open a form as if modal (when it's actually not) so that
the following code is executed??
Thanks,
Ivan

Does any one know if a property can be an array??? I mean, I build a structure called mStr and I want my property to be an  array of it...I know I can do
Public Property ListItems() As mSt
but I need the property ListItems to be an array so that I can call it :  mClass.ListItems(1) ...

The example on :
http://msdn.microsoft.com/library/en-us/oledb/htm/oledbprovinvoking_the_data_sha
ping_service_for_ole_db.asp
shows how to associate a "daughter" recordset to a parent recordset.
What I really want to do is to associate two sibling recordsets to a single

I have been working on a project where I frequently use the STR function.
The project file got modified and now that function is gone. It doesn't even
register in autocomplete anymore. I assume there is some sort of "include"
file I must have misplaced. Anyone know what's going on ...

I'm trying to write a vb program to search through a specified folder and its subfolders looking for files with certain extensions.  I want to be get the size of all the files and folders minus these certain extensions.  To do this, I am trying to use the FSO.  Right now I have ...

What is the syntax for exporting Access tables into Excel Files?

I think this is a fairly simple question, but for some reason I am
struggling to find the solution!
Assume I get an address into my app which looks as follows:
The Purple Widget Company, 4 Privet Drive, Little Whinging, Surrey,

Does any one know how to have a Property on an ActiveX control to only be available at Run time
What I was wanting to do was to have a property (Let/Get) that is available at run time, but I didn't want it to show up in the Properties list during development time
Is this possible