Situation: area - 100 rows x 50 cols; cell contents - there are only 1's
scattered throughout the whole area, like: row 3 contains the no. 1 in cells
B, D,E, AB, CD, row 10 contains no. 1 in cells D,F, AB, CC, FG, ... - what's
important here is the concept, not the positioning; ...

I have coded a macro for MS excel 2007. The macro has been placed under
Workbook_open event. It works fine as expected but it also opens the Visual
Basic editor auomatically displaying the macro codealong with excel sheet. I
tested the same by saving in Excel 2003 format. The ...

I have a series of cells on a worksheet which when clicked on open a
DialogBox. The DialogBox has ListBox which references another worksheet in
the same workbook, when I click OK it deposits the ListBox value into the
triggering cell. All of this works great, except, I also need ...

Hullo Everyone,
A quick question. I am trying to make all negative numbers come up as
zero with a dollar sign. I tried the ´general;"0" '  one but that
doesnt include the dollar sign.  Any ideas or tips?

 I want to find out how to read data from powerpoint including image
and text.  I want to do it dynamically way to read from ppt, purge the
data into Excel or somewhere text file and save the image as jpg or
gif.  I don't care using Excel or VB script to do it.  I need a way to

We get a spreadsheet everyday from our supplier with the status of our
production. These spreadsheets are snapshots of our production (that is the
status change of an order is only shown as the date of the spreadsheet and
not showing the dates the statuses changed for each order)

Is there a VB code that opens the "Insert Hyperlink" pop-up window? (i.e.
does the same thing as "Ctrl + K" or "Insert|Hyperlink...")
I want to be able to click on a botton (created from Forms toobar) to open
the "Insert Hyperlink" pop-up window, so I can then choose an address ...

Is there some way that I can see the assembly code for a VBA routine?
I have Office Excel 2003 and the VBA that comes with it (VB 6.3), with
Windows XP Pro SP2 running on an Intel Pentium M 770.

I wrote a program in vb.net 2005 to open a spread sheet, read data and then
close the spreadsheet. The probelm is it is not really closing.  
Dim xlApp As Excel.Application
       Dim xlBook As Excel.Workbook

Hi group,
Is it possible through coding to set macro security level at low when
application is opened?
K. Pedersen

WinXP Pro MSOffice 2003 Pro
I have a spreadsheet with hundreds of rows and 15 columns
Col A holds Company name
Each Company can have any number of line items on the spreadsheet

I am trying to prevent users from selecting the first 9 rows and row 318 in a
worksheet. Protecting the sheet will not work, because the user needs to be
able to change the width of columns and do other worksheet functions. The
following code only tests for the active cell:

The code below takes a bit time to populate the ID if I select bigger
range....Is there any way to expedite it.
Any help will be appreciated!!!!
Dim DataCell As Range

How do I declare a multidemensional array that has both strings and integers
in it?
Thanks

I have followed Ron's instructions from http://www.rondebruin.nl/cdo.htm and
I am not getting any emails.  A few things I know:
I am able to send .csv & .xls as attachments through our firewall.
The copy doesn't contain any VBA code so the firewall isn't blocking it.