I am using Excel 2003 SP2 and VB 6.3
I am trying to use Excel to copy from the server.
for that I use "scripting.filesystemobject" to get the list of files.
'my code is..........

I found an old post that I was able to modify, but I still have a couple
questions. Here is a copy/paste of what I posted to the old post from January:
-----------------------------------------------------------------------------
I too was looking for a way to create passwords and ...

I have 2 questions:
1) how do i use a stored procedure within Excel VBA passing a
nvarchar(100) parameter?
2) how do I get the users to select that parameter from a dropdown

I have an access database which is linked to an Excel doc via pivottables
when I copy both files the excel doc is still linked to the database on the
old location. How can I change the location to search in out of excel. It's
not working via data range properties (gray).

I've a workbook that needs to email the active sheet to multiple, user
entered, recipients using Lotus Notes.  Thanks to lots of "borrowed" code
from here and other sites, I have the majority of the code done.
The bit I'm stuck on is how to collect the email address(es) from the ...

I have a macro that saves off a copy of a file. i would like to put a date
stamp and/or possibly a time stamp on the filename. Is there anyway of doing
this? thanks.

I searched through the forum but I can't find the solution I'm looking
for. I want the Cell Link in a single Spinner control to depend on the
value of another cell.  In other words, if A1=0, then the Spinner
control will index C1, and if A1=1 then the Spinner control will index

To all,
I have an xy chart. When the user clicks on it I would like it to open
up in the print preview window ready to print. The chart is embedded
in a worksheet called 'chart' and not in its own worksheet.

Excel must have an internal mechanism for managing any OnTime events I have
scheduled. Is it possible for me to interrrogate Excel to find out what if
any OnTime Events are currently scheduled? I have searched the help files and
come up with nothing. I found Fred Cumming's OnTime ...

I have a column with 15 values and from these values I need a list of all
non-repeating pairs possible. Simple task, but for us not-so-well-versed in
the Excel development environment - is there a code sample? Thanks!

THIS MY DATA       
EMP. NO.    NAME     NOS
3120    MICHAEL     530
3120    MICHAEL     550

i am writing a piece of code where user is prompted to browse and
choose a .sql file. i am taking the file location in a variable.
Now, i want to connect to the database (Oracle). Once I am connected
to Oracle, instead of writing the query I want to give the filename

Here is my problem: I have 5 reports with similar structure. All of them
have pivot tables and vba code. All the pivot tables are based on data in the
data sheet which is extracted from an Access db using vba code.
The situation is one of the report's pivot table's data has ...

Hi
If i use the function if in a sheet
and i want
F12 >3900 and F12 < 3999

I have some code which is returning a starting point and end point for cells
which contain data or formulas in a spreadsheet.  I want to limit this to
only cells which display data.  My formulas concatenate data from an input
sheet but display "" on lines in which no data has ...