Hi
we have developed a vba form to display our reports through forms, as the
application are used by many users, we would like to create a new text forms
as login username and password, where each user need to type there user name

I use the following macro and it used to run fine - until yesterday.
Then, I had to manually stop it (using the windows task manager). Now,
t's not working anymore. Well, it seems as if it's still working, but
the output file is not created.

From within a macro I'm trying to set the interior color of cells based on
their value, but I notice that cells which are already colored won't change.
Even manually they won't change. If I first clear format in the cells then
it works.

Please i need help. I am working on a large file.
I need my output to be place in another column.
The end result should look like this.
I know that i have to use the for loop and concatenate.

I have these files that I am receiving in Excel that are not set up to be
database friendly. I am spending hours cutting and pasting to rearrange them
into a mode where I can import them into a little Access Database that I have.
The problem is they are full of serial numbers some ...

Cant underatand why some plots go through fine, some fail....this is portion
of chart plotting. I didnt specifically want to include a huge vb macro in
here.
It fails at the line: Source:=Sheets(str2).Range("A1:A290,K1:K290,L1:L290")

On one sheet, column 5 is the customer number and column 6 is the new
customer number.  I do a little formatting to ensure both columns are text
and the old customer numbers are 7 characters in length.  If they are not 7
characters long, I add a space at the end of the old ...

I am having problems importing word file to excel.
I have about 70 Microsoft Word files and they do have different file
names.
Q1: Is it possible for me to import those word files to worksheets?

If something costs $0.68 and sells for $2.00 the profit is $1.32, but how do
calculate what the profit margin is in percentage?

I have about 60 (incresing everyday) .xls files in a folder called
"customers invoices"
Format of all the files is the same.
How can I exract data from all these files (from this folder)?

I have an Excel spreadsheet with the following columns:
No.     Date     Model     Part#
01      5/1       100         0120    0150      0156     0255    0325     0352
02      5/5       200         0170    1150      0956     0265    1325     2352

how do i schedule a print job ....i have an excel file which has to be
printed at a particular time like morning and in the evening after connecting
to a database , do i have to do this using task scheduler or is it something
that has to be coded using a macro........can anyone ...

I've determined that I use (or have used) the following references in Excel
2003
Microsoft ActiveX Data Objects 2.5 Library
DSO OLE Document Properties Reader 2.1

Thanks to Norman Jones for telling me the following.
Can anyone else confirm that, evidently, if a workbook resides in
Excel 2002's XLSTART auto startup directory, then Microflot overrides
what it calls "macro security" and cheerfully launches any Auto_Open

Please someone help me with Evaluate function. I have some rules written in
Access table as string with predefined variables in it like:
and(" & CCA & "<30, " & CCB & ">800)
and(""" & AAA & """=""" & AAB & """, """ & BBA & """<>""" & BBB & """)