I inherited some Excel code that does this:
Set fso = CreateObject("Scripting.FileSystemObject")
strTempFile = fso.GetSpecialFolder(2) & "\" & fso.GetTempName & ".txt"
'2 = TemporaryFolder.

how can I assign a large number of named sheets to an array variable
(varArray).
In otherwords if I have a collection of large number of named worksheets
like "ASD","XZC","BNM",.......etc.

I've done some testing using different versions of Excel which I hope will
help me to ask my question more specifically in order to get my issue
resolved. Thanks to the community for your patients.
I've created a function that formats my date field to mmddyy so that all I

Hi, I hope that somebody can help me.
Every month we receive a CSV file file produced by an outside company, which
consists of approx. 52 columns and about 100 rows of data.
The problem we have is that neither the columns, nor the rows are ever in

Hi, I am having some trouble getting the date from the pop-up calendar
to populate into my worksheet.
Sheet1 contains this code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

I have just got a new computer and have moved my Personal.xls file to it. It
works ok, but now I got an error in the calander tool in Personal.xls:
Private Sub Workbook_Open()
=>    Dim NewControl As CommandBarControl ;THIS IS WHERE THE DEBUGGE STOPS

I need to delete every other row in a 2000 row Excel 2007 spreadsheet.  Could
someone help me with the code with this.  I am ok with Word VBA but NOT Excel.
Thanks!

Good Morning all
We are using MS Excel 2002
Using VBA Code, is there a way to copy a single entire sheet from a diferent
workseet?

I want to perform the action in the code line below:
Worksheets("Clusters Summary Report").Move before:=Worksheets("Cluster 1")
This works fine, but the problem is "Cluster 1" is not always going to be
the first worksheet inj the workbook. I am looking for a say to tell the code

I have installed on my pc both versions of ms excel, 2003 and 2007. If I
open a file by dblclick, it opens in 2007, but if i open excel 2003 first,
and then dblclick the file, it opens in 2003. How can I create a shortcut to
a specific file that automatically opens in 2003?

How do you reference a cell on a different worksheet.  My problem happens
when the source cell get moved the reference follows it.  I'm attempting to
have my formula always reference a certain cell regardless if the contents
of that cell have been moved.  In other words my ...

I have a macro that is used to copy a source file (dim srcfile as string) out
to a path (dim destpath as string).  
user inputs the full source file path into a text box.
(srcfile=txt_source.text)

 I'm using Excel 2003.  I have a worksheet with a button on it that
does a PrintPreview.  The button works fine in the Excel 2003
environment.  But when a user loads my .XLS into Internet Explorer (I
assume IE automates Excel) the button fails and gives an error like:

Is it possible to (when a different sheet is active)
This is extremely simplified, but represents the problem.
I think I'm hoping "With" carries a little more juice.
Sub WorkingIt()

Is there a test (and what is it?) that could be used to avoid using on
error resume next before a line like this?
.SpecialCells(xlCellTypeBlanks).count returns an error if there are no
blanks in the referred-to range.