First, thank you to all the contributors to this site as it has been a
valuable resource for learning and coding in VBA.
I have a problem I have not been able to resolve.  I have the code
below in a workbook (Voucher Form.xls) that is saved on a network

I am on a sheet called "Menu". I recorded some code that would copy a
worksheet called "Tables(main)" insert it at the end of the workbook
and then rename it to "TABLES"
which copys the sheets perfectly

Is it possible to remove the Worksheet Menu Bar from the
excel.application?
Thanks All.

Is there a command to break all links at once? I have 70 spreadsheets and
need to open, save as, and break a dozen links and the links are different in
each one. I would rather not have to edit the names of all the links if there
is an easier way. Thanks!

I have a group of data that contains city, state.  I need to separate this
into two separate fields.   I figured if I knew how to calculate the
position of the comma I could use the left and right functions to generate
this but I'm not for sure how to determine the position of ...

I currently work in a finance related job and study economics as well.
I would like to hear your opinions on which books/websites/tutorials
and skills are recommended and often used in the world of finance. I
most specifically would like to hear about what specific skills i.e.

How can I catch a Paste action behaviour(Paste menu click and ^v) and
default it to PasteSpecial-Values.
I should be able to catch these events and call my custom subroutine to
handle the situations.

Hi evry one,
I have an excel file which contain group of cells from A2 to A10, those
cell values are changing almost each 10 seconds. Any one can help me how to
read those values in visual basic studio .net 2003. The excel file is always

Can anyone help? i have written a macro to copy what i want from one sheet to
another,(in the same book) but then i want it to copy on the next line when i
run it again. so as i keep the first lot of info, thus ending up with a page
of info as you go.

Have workbooks with 6 - 8 worksheets.
Need to convert all "used" cells to text
  ie: no formulas, or vba left over
  (like RDB does with his SendMail add-in)

Have for some time used the following in a number of applications
     Columns("F:G").Select
             Selection.EntireColumn.Hidden = True
Works Great:

Hey, I have two series. I want to get a ratio of their changes, but i want
the ratio to lie between 0 and 1.  does anyone know how to do that?
someone suggested that i truncate or normalise. but i dont know how to.
please help.

I want to create a VBA macro in Excel which will play an audio file that is
hyperlinked from the cell next to the selected cell, but it is not to start
playing from the beginning of the file.  The start time is to be taken from
the active cell.  I want to know if it is possible ...

I have a major problem with a macro I built: It cant load forms.
THe user should be able to select an option from the dropdown list and
then be presented with a form but I get the following error:
Error Des: Could not set the value property. Type Mismatch

How do i color shade cells say yellow in a sheet that does not have
locked and FormulaHidden. The idea is to see at a glance which cells
are editable.  Many thks KZ