I'm trying to get data imported from website to excel.
The link.
http://www.douanes.ci/Services/Grpproduit.asp?DateMaJ=29/02/2008
This is code 01 to 97 is called chapter wise data.

I am getting an error that says "file error:  material may be lost".  The
file way made with excel 2000 and is being used in excel 2003.  The file is
10.6 mk.  
Everything will copy except the buttons and pictures.  The macros are still

The user wants an easy way to select names. He is unhappy with Data
Validation as it is too slow. I added a list box to the Sheet which when
clicked will add the selected name to the active cell.
However, on testing I've noticed that if he selects Joe Bloggs and then

Is it possible to combine the following :-
   For Each MyCell In Sheets("Current Round Detailed").Range("C10:K10")
       If (MyCell.Value > 0 And MyCell.Offset(12).Value = vbNullString) Or
_

I'm using the basic version of solver that comes with excel.  I've been
defining the constraints, variables etc using VBA macros as shown in article
843304.  I now need to define the max time, number of iterations, precision
etc - basically the options that you can define from ...

I want to change the color of bullets in a textbox (shape) in XL 2007, but
keep getting errors. this is what I have tried:
ActiveSheet.Shapes("TESTBOX").TextFrame2.TextRange.ParagraphFormat.Bullet.Font.Color = 255
similarly, when I try to change the font name, character, or other

ThisWorkbook.SaveCopyAs Filename:="C:\Folder\XXXXX-" & inputText &
".xls"
however if the file already exists I get an error "1004".
I presume I require something like

Can anybody tell me whats wrong with this code / why it does not work.
The idea is that administrators will have access to a set of macros
listed in a menu but will not be able to access the menu list without
a password. It works without the input box, but l would like to have

Thanks. I want a verticle scrollbar on a label.
That may not be allowed....  but if it goes on the Form,
how it is controlled?
Thanks - Kirk

I want to require the user to enter his/her name in a specific cell (E59)
before the user can save the file.
I tried using Data Validation where I specified Text Length between 1 and
40, and left blank the check-box for "Ignore Blank". Nope.  I never

I have outlook application.
How can I know what sending mail without outlook?

I know example1 is right, example2 is wrong.
Please tell me, why is the second example wrong?
Following is my code:
Example(1)

Could anyone help with some VB code to do the following,
After double clicking a cell in say Row 17, a new row 18 is inserted.
Thanks - Kirk

Refering to the post in Excel Worksheet Function
Does anyone have any suggestions on how to load following web link into Temp
worksheet?
http://main.hsi.com.hk/hsicom/table/dyforma1.xls

My question is in column (B) I have many different names of companies and
there are also blank cells. I want to know if I can have a count of how many
times each name has appeared into a seperate worksheet. For example: B1 = ABC
Co.