How do I get my Query to pull data from a local copy rather than one on a
different server?
For example, if you have the same folder on two different servers:
F:\UserApp

Hi
I am exporting the values from Excel to text file (CSV file).
If the total number of rows are few thousands it's OK. But when I have about
50K records, it takes about 45 to 55 minutes.  Is there a way to speed up

I'm not an avid user of excel, which will explain the problem I'm
having.
What I want to do:
Take 1 very long column of data, paste it into a new sheet, and split

I have some pretty simple code that is trying to move the "value" from
one range to another.....each range happens to be a single cell. Each
cell has been formatted in the worksheets to be number format
$#,##0.000000 (i.e. six decimals - yes I am dealing with fractions of a

Is there a way I can determine the .address of the cell that is the
result of the Control+Home on any sheet that I might activate (and
I have over 100 sheets)?
I'd like to incorporate it into a

I have a spreadsheet with various words and numbers in each cell.  The
arrangement of numbers in the string can vary.  I want to extract from the
text string, the first 3 numbers as numbers.
Example

So I decided to post it here.  I have read as many message boards as I
could find about the error I continue to receive.  "Compile Error: Only
comments may appear after End Sub, End Function, or End Property"  I
have seen posts referring to either APIs or Function Declarations.  I

The code I'm writing requires me to check to see if a worksheet named
"Top" already exists before the macro creates one. My test for a
sheet named Top isn't working because if I dim ws as a worksheet or
worksheets or an object, I get an "Object doesn't support that

I am trying to build a class module that has, among other things, a
collection consisting of items of a user-defined type.  VBA is not
cooperating.  Let say the type declaration is:
[Private?] Type ItemData

I have a simple form that allows the user to select items from a list
box.  I want to store those items in an array to be used in some other
user forms.  I'm having a problem testing this process.
1) Question: This is a two column list box.  Can I store both columns

I have the following macro which reviews embedded charts on worksheets and
lists out the series information on a separate worksheet.  I want to do the
same thing for the charts that are CHART sheets, rather than worksheets.  
What do I need to change?

If I leave the module that my macro is in named Module1, the shortcut key for
my macro works. If I change the name of the module, the shortcut key doesn't
work. Is it acceptable to change the module name? How do I connect the
shortcut key to the new name?

Hi - A client of mine is getting the "Runtime Error Type 13 Mismatch" error
when they execute a macro on a spreadsheet I created.  Any idea on why this
was created and how I might be able to correct this issue?
Thanks,

Hi..
Is there a way tpo seperate or extract out first or last name from the same
cell?
for example, if in cell A1 we have John Smith, can I able top extract out

I have a date in both B1 and B2 (sheet "Macro Data"). In my macro, I have the
following code:
Dim EndDate As Date
Dim StartDate As Date