The following command shows the Find Dialog box but how do I capture
the results of that search.
Application.Dialogs(xlDialogFormulaFind).Show
If I try set stuff = Application.Dialogs(xlDialogFormulaFind).Show

I am receiving a run-time error "13" when I try to run a USerform in VBA.
When I try to debug the problem - I do not get an indication where the
problem is. Below is the code. Does anyone see what might be causing the
error?

Sorry if there is already an answer to this question, hoever I have searched
as many key words as I can think of and cant find the answer.
I have a macro that retrieves files and list file attributes from within a
directory. I would like when the macro is started that a file ...

If someone Protects or Unprotects a worksheet, how does one "capture"
that fact so that I will know when to cause a manual Calculation?
--

I have written a macro which copies a worksheet and then alters some
of the values in the copied sheet.
Everything works fine except that any text cells with more than 255
characters are truncated.

When i open a CSV file in Excel and edit it and then save it. Excel removes
the text qualifiers onwards from the line 14 when the last  two or three
columns of my csv are empty. Also i am using double qouts for the
qualification of my data

I've been tasked with automating a spreadsheet for the boss that needs
to pull SQL data from one of our DB servers, and then format and
import into Excel.  The mechanics of doing so aren't the problem.
I want to know how I can securely do this over the web.  We'll have

How to find a string data type related functions? I mean a list of all of
summary in VBA Help.
Clara

I have an error in my custom UI xml file, but can't for the life of me
find it. Did microsoft, or anyone else for that matte, publish a
syntax checker tool to bverify the xml file.
If there is an error, office just ignores the entire file without

I have a spreadsheet with 26 rows and 40 columns, some cells of which
have the background color of "tan".  I need to count the colored cells
within each column.  I've been going round and round with the vba
coding I found at http://www.xldynamic.com/source/xld.ColourCounter.html

I wanted to get direction on how to automate the dowload of CSV files from a
website.  Below are the details on where the CSV files are located within the
website:
- The website requires a login and password

Okay, I have tried using the item part of a folder collection object and a
file collection object.
I have tried it initially as late binding, then as early binding, neither
method helped.

I want to quickly find all data in column A to finding range in column
B toW.
I set the loop in column A and use  find method for range column B
toW , but it doesn't work.

Is it possiable to open a .exe program with excel macro?
Thanks Mike

I found this code that when you CTRL+G from Visual Basic it displays all my
printers:
Sub PrinterSelect_macro()
   Dim wshNetwork As Object