o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Can I use the Exists method in VBA -

Hi,

I am trying to find out whether a particular item of the CustomDocumentProperties collection exists.

Using the Exists method does not seem to work.

Any ideas?

Thanks

 

Can I use the Exists method in VBA -
Hi, I am trying to find out whether a particular item of the CustomDocumentProperties collection exists. Using the Exists method does not seem to work. Any ideas? Thanks

Using Exists method inside Word VBA - Please help :) -
Hi, I am running some VBA code which creates a custom toolbar inside normal.dot. To prevent the custom tool bar being created every time word is activated, I am trying to use the Exists method to check whether the custom toolbar has already been created. However, this does not s

Yes another dataset search question -
Hey guys, there has got to be an easy way to do what I'm trying to do and I've done multiple searches on this forum and can't find the exact answer. I'm using VB.net and oledb to connect to my database and fill my recordset. What I need is some easy way to check and see if a record

[2005] I need a quick and dirty sorted list -
I need to be able to store a sorted, 1 dimension array of string values. I need to be able to add a string and remove a string, by name. When adding, it needs to sort automatically. When adding, if the item already exists, it just ignores the add. When removing, if it doesn't exist

Folder exists - Resolved -
Hello all. I'm new to this forum and relatively new to VB.NET programming. I have used the File.Exists method with great success. Now I've run up on something that requires me to determine if a folder exists. I know I could attempt to write a dummy file to the folder and catch the

Execute method -
When I use the execute method to run a make-table query, it errors if the table already exists. I want the query to overwrite the table if it exists. Is there a way to do this without having to delete the table with code? Matt(+)

checking if an ITEM already exists in a listview -
Sorry wrong forum -> should be VS 2005 instead of classic vb hi, I'm currenly trying to load two textfiles in a listview. afterwards i'm updating one of the columns where i have the following problem i donnot know if a certain index of the item already exist so for inst

Checking if method of object exists -
I have a Variant array and only some of its members have the method .accName, so if I pass though the array with a For loop an error is raised on the 'rows' in the array without the method .accName. Is there a way I can check if an object has a method before calling it and raising an e

VB-Excel SaveAs method, if file exists, rename without prompting -
When using the SaveAs method in VB to save my Excel sheet, if the user entered an existing filename, I want my code to just append a 1 to the end of the filename, save it and move on, no prompting, etc. Right now if the file exists, a msgbox pops up asking if i want to over-right, i

Network Folder Exists -
I have a program that sometimes needs to check for the existance of certain folders on network machines. When a computer is fresh from a reboot and no network browsing has been done, I am unable to confirm the existance of the folder using the FileSystemObject (even though I know it ex

[2005] class/method exists -
In VB .NET, is it possible to create an instance of a class by name. The setup I want to create is a set of inherited class: BasicClass | | V BasicClassUserName --> extends BasicClass The BasicClass contains functionality that is generic to all users and the BasicClassUser

Disimilar names... -
hello, iam a vb beginner.i hope you will clear.. there is one text box,it is connected to the database.i have to enter n number of names in the textbox one by one by using commandbutton.the same name should not exists.if same name exists it should show some message.if it is not a sim

What is the most fastest way to see if a string already exists in an array -
Anyone know? Currently I have 25,000 records in a mysql database. What I am doing right now to see if something exists is the statement.. rs.Open "INSERT INTO yIDs (yID) VALUES ('" & yID & "')", Mysql_Connection if the string doesnt exist, it is ad

Well - Number of times file exists -
I know how to determine if a file exists, but I need a way of seeing how may times a particular files exists. I am assigning photos to a particular product, and want to have multiple examples in same folder. If user add a picture, and two already exists, how can I make it so the ne

can i verify that this email exists -
Dear all, can i thru vb check that a certain email exists. i have a web registeration form, it is used for subscription in my newsletter. i want to know if a certain email really exists without sending a confirmation email and then waiting for it's reply and so on. i need only to

Method or data member not found...BUT IT EXISTS!!! -
I have 2 VB projects....an EXE and a DLL. The EXE references the DLL. In the DLL I have a class called Woof with a function called Fish. Now I run the DLL in the VB IDE...then reference the VBP project from the EXE, that is also running in a VB IDE, but it beeps and gives me the

If file exists, then... -
Trying to think of how this would look. But basically, when I create a file (txt) using my program, and I create another it just overwrites the previous file. How do i check to see if a file exists and prompt the user to choose a different name. i.e. If Chralire Brown exists then ms

Detect if a record exists using conn.execute -
Hi everybody, Assuming one uses only ADODB.Connection (No Rs or loops to drive into the columns), is it possible to send a SQL query and discover if one/more records satisfying the query exists in a DB. Sufficient if we can find the no. of records satisfying the SQL. Any other effect

Restoring a form ! -
OK this should be easy, I have a small application that uses 2 forms what I want to do is restore the 2nd form from the taskbar when the user tries to access it, assuming of course that it already exists. I've got all the code to check if an instance of the form exists, but can't se

Execute query -
When I use the execute method to run a make-table query, it errors if the table already exists. I want the query to overwrite the table if it exists. Is there a way to do this without having to delete the table with code? Matt(+)

Checking if web file exists... -
Hi, how can i check if a web file exists? For example if www.mysite.com/myfile.exe exists then msgbox "exists". Is this going to be complicated...? Thanks in advance

Urgent:Help with accessing Files -
Hi, I have a small problem with accessing files. How do I check whether a file exists on the hard disk or not. is the same method applicable for checking database fiels MS-Jet database. I require this to write a subroutine that creates a database if it does not exist... is t

RAS: enumerating alternate phones -
Unlike RASEnumEntries, I do not think there exists an enum method for the alternate phone numbers assigned to a single RAS entry. The MSDN describes using RasGetSubEntryProperties: "In addition, a subentry can include a list of alternate phone numbers to dial if RAS cannot make a

Checking if exists -
Using ASP how can I check that a file exists within the same directory as my web pages. I want to check if it exists then delete it.

Does object exists -
Hey, Can I check a page if an object exists. For example I want to see if document.All(txtExample) exists, before I doe any changes with it. Mark

Find WinWord.exe on computer -
i am making an add-in program for MS WORD and i need to find the direct path of MS WORD so that i can use it to launch it from my vb program. i have used the Dir$ method: if len(dir$("winword.exe")) <> 0 then msgbox "It exists" else msgbox "It

File exists - case insensitive -
Hi all, I want to know whether any vb function is available to find whether file exists. The function should also check whether file name case sensitivity. FileExists method returns true, if I give the input as "SampleImage.jpg", but actual filename is "sample

[2008] Folder exists and create, file exists and delete, and process exists and end -
Hello everyone! I am using Microsoft Visual Basic 2008 Express Edition. How do I check to see if a folder exists? If the folder exists, how do I check to see if a file in the folder exists? If the file exists, how do I check to see if the file is running? If the file is running, how do

Probable VB6 problem with ADO [resolved] -
Hi, new to the forum and quite new to programming with VB. As part of my HE course project I'm connecting to a MS Access database through a VB front end. Because I'm teaching myself this stuff I'm doing the prototype thing and incrementing my project a litle at a time to confirm my lea

[2005] check if any file exists -
hi i need to be able to see if there is any file in the directory with a certain name. i can see if file exists system.IO.file.exists(path) but it doesnt work the way i want it to because the files have different and unknown extensions

Can't close Workkbooks... -
I tried other ways of closing it, but it is still in the Tast Manager ... It opens it up and that's it ... how the hell do I close it I use Microsoft Excel 11.0 Lib. here is the code [highlight=VB] Public Sub Check_Validity2() On Error GoTo NoFile Set myBook = Workbooks

Determining if an object exists -
I am trying to write code that adds items to a collection. The problem I face is that I need to determine if an item already exists, I don't want to add it again. Because of the number of items in the collection, I do not want to loop through them all checking each one. Is there

checking if a class exists before using it -
I was making a control which has properties which modify its parentform. Unfortunately, it doesnt like me refering to the parent form because there is a small chance that there is no parent form. Is there a way to have the code check to see if an object exists and then preform an actio

[2.0] Detect if file exists online -
I have always been using WebClient.DownloadFile() to retrieve files, but if I want to just check if a file exists, would there be a faster way? I don't need the file to be downloaded, I just need to confirm it exists. Similarly to how a ping works. Thanks in advance.

If File Exists -
I am wanting to check to see if a specific file exists on a workstation. If the file C:\AAA.EXE exists, i want to set the check box chkAAA to true, if not there, leave it blank. Any help would be appreciated

Test whether a control exists -
Hi guys, I am using the .NET compact Framework. I was just wondering whether it is possible to test if a control exists on a form? If it is possible then how is it achieved? (say for example purpose i want to test whether a textbox exists!) Thanks in advance

does this table exist -
Hello!! I want to check if a particular table exists in the database or not.. In order to do this i am passing a select query to the database. "select * from xyz" suppose the table dosen't exist, i get an error message as follows: "Invalid object na

Creating a char-array of a string -
I need to put a string "HELLO" into a char array so i can access it with mycrars(0) = H etc... Is there a method for doing this in VB? I tried split, but it doesn't work without a delimiter. I have written a function myself in vb that does this, but now I am curious if

[2005] Testing whether a control exists -
Is there some easy way to determine if a control exists? The problem I have is that I create an array of controls (labels for example) that gets re-dim'd from time to time. Id like to be able to say, if MyLabel(35).Exists then do something. I have been using; If MyPanel.Contains(My

Ensure path exists -
What is the code to make sure that a path exists? If the path exists it doesn't do anything, otherwise, it creates the path. I think it's an API, but I can't remember it.