I am currently using the following macro to fix all values in the workbook
and then delete certain tabs. I recently added 5 charts to the tab I want to
keep and was wondering if anyone knows how to fix the charts on that tab as
embedded picture files in the worksheet. Any ...

Hello, I have code in my program that can open HTML Files and
search them for hrefs.  There are also HTML Documents that I need to
search.  If selected they open in IE, if I right click and say open
with, then they open as a text file.  Is there a way to do this in my

I have a row with 7 Cells each cell will contain a number. The user will
enter a number into each one, but I only want the user to be able to enter a
number 0-9
Example:

Hi,
I am creating a speadsheet that once i type in a service number in it will
automatically bring back the registration data into another field along with
the depot codes. i have tried a vlookup formula but it doesnt seem to work.

I was wondering if there was a way to (via macros) enter text into a cell,
and then resize that cell to accomodate the text?  Sometimes I enter text
into cells and the text is larger than the default size of a cell, and I
would like to have code that adjusts the size of the ...

Is there a formular that I can put in the last column " Last came"
that will look along the row for the last data entry that a Boy
attended and bring back the date on the top label?
So For example Harry's last attendance was in Jan-01, where as William

I am trying to come up with something that will look at rows 3 through 2800
and hide any row where the value in column g (of the respective row) was zero.

I'm Allen.
Is there a macro that will allow me to update an exchange rate on excel
sheet, directly from some exchange rate website , once every 24 hours or any
other time interval?

http://www.rondebruin.nl/windowsxpzip.htm#mail
Hi all - I am looking for something to create winzip files for EACH workbook
in C:\Test\ below. (Code comes from Ron's website above)
But I am getting a winzip folder instead.

I have a presorted Excel worksheet, & I'm trying to sort only the top part of
it from where I end up after the 1st sort (the 1st blank line after the top
part of the worksheet, but in tht middle of it[a daily variable starting
point]). This recorded macro & my attempt to get it ...

I created an array of string as follows:
Dim MyData(1 To 6, 1 To 6) As String
Then I gave values to the 36 array elements as follows:
MyData(1,1) = "New York"

I was hoping if someone could help me with a language problem I'm facing.  
The code below is suppose to extract strings from a worksheet and create
string table files that will be fed into a resrouce file.  I am using Excel
2007 currently.

Here is what I would like to assign a macro to do:
1. Copy information in row 1, columns B:N.
2. Paste that information in the first available row, starting in row 5.
3. Clear info in row 1, for new data entry

Hello, I have code in my program that can open HTML text files and
search them for hrefs.  There are also HTML Documents that I need to
search.  If selected they open in IE, if I right click and say open
with, then they open as a text file.  Is there a way to do this in my

hi,
I have the following:
   Columns("D:D").Select
for some reason columns C AND D are being selected?