I've been trying to do some SQL work in VBA to allow people to change
database fields more easily.
I managed to:
extract the data from the file,

I've just installed Office 2007 in my new Vista PC and wish to import
my macros from my copy of Excel 2003 on my old PC, but I can't find
them.  Can anyone help?
Thanks, MrBill

I am wondering, when using the hyperlink formula, is there a way to
open a file in a folder regardless of the filename extension.
I have file names with these extensions in a folder
000340011.tif

I am using the text function, with the following formula:
=TEXT(Data!A10,"##.#%") - where Data! refers to the sheet that the data is on
This is working fine.
However, some of the for some of the cells that I will be using this on,

We have users that use the same spreadsheets that are in a shared folder on
our network.  The workbooks are NOT set as Shared Workbooks...
Previously, if a user tried to open a spreadsheet that another user had
open, they would receive a warning that they were about to open the ...

i need to find a equation of ellipse which join two points, how do i
get the equation from the excell sheet?

Is it possible to open an excel document at the top of the sheet no
matter how it's saved.. without using a macro (I dont want users to
have to enable macros)??  If it is possible, how?
Any help would be greatly appreciated!!!

As long as I've been doing this I've never encountered this problem
before.  I have only one form and no modules.  When the program
starts, unless certain conditions are met I want to exit before
showing it.

I am trying to filter a database and show only the records that match
certain criteria.  For example, in column A I have employee business units.
I would like to be able filter that list somehow to show only those
employees in a particular business unit.  I don't just want a count ...

Bonjour,
J'ai un document avec une macro mais elle a un problème, elle m'éfface une
formule qui est dans une cellule de total, où faut-il aller pour vérifier et
éventuellement modifier une macro. merci d'avance pour votre aide.

I have someone who's Replace command replaces everything in one pass. With
mine however I have to repeat the process. This is Excel 2003
An example is lets say you want to replace all occurrences of two spaces
with one. The first time the Replace command is run it only makes one ...

Starting a new financial year I want to clear all last year's data from a
table, but leave the formulas and formatting.
Any suggestions?
Jeff

Hi All
I’ve seen this so many times but none include a function for blank cells?
I’m trying to find the min, max, mode, median etc…. for a list of values
given an IDL (CELL F12) to look up.

I have inserted a check box in my spreadsheet (using Excel 2003), but I can't
resize the check box or the description.  I can resize the entire box, but
the check box and description stay the same size.  I have tried check boxes
from both the forms toolbar and the control toolbar ...

Hi fellows
My workbook is design to collect data from local files an put them
together as a "bigger" database. A number of spreadsheets in this
workbook contain each one single specific pivottable that reports on