I'm looking to write some VBA code to copy a large table from Excel into
Word, and format it so it fits nicely with columns the right width etc. Its
possible to copy and paste it manually, but its lots of work and I'll need
to do this regularly.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Hello,
I want to access the available user-defined chart formats. I will
present the names of the formats to the user in a list for him/her to
choose one.

I have code that looks at column headings based on a predefined
array.  For each column heading it looks at how many different items
“strRng” are in that heading and breaks out (copies)  of each
different type to a new sheet. For instance in the column there may be

I am trying to create one new list of matching data...I need to look at one
cell in one sheet and look to another sheet (column) and see if it shows up
there...if it does, I need to bring back the entire row of data for that
item...to a new sheet to start the "matching" list.  Is ...

Here is my code... everything working except copying and pasting the charts
as picture... no error, the picture of the excel chart just doesn't show up.  
thanks for any help.  SteveC
Sub test copy excel charts

I currently have a simple VB that selects data in row 60 and 61 (see
below).  Problem is that if a user adds lines (and its quite possible
that he may) the macro will not hide the correct row. Is there VB to
hide a named range...?

I've been looking into the possibility of dragging / dropping files onto a
userform control - where the control would grab the first files path for use
later... I have managed to get as far as the 'BeforeDropOrPaste' event - and
while I can see this is available in Label controls ...

I have the following data that I want to plot, "Days" for X and
"Yield" for Y.  However I want the size of the mark be different
depend on the "Weight".  How can I do that in Excel?
Yield    Weight    Days

Hi All.........
I am trying to create a macro that will test the DATE, and if it is an ODD
number, run Macro1, and if it is an EVEN number, run Macro2........
Can't seem to get there.......help please.

I'm having issues using the Public Sub ImportTextFile from the
cpearson site.  I am trying to import a datafile that was written
using VMS's DCL language.  When I manually copy and paste the data
into an excel sheet, the file shows up correctly.  When I try and use

I intended to use the result of RCOUNT variable to various other
procedures.
So I have named a cell by name  REF_NUMBR.
Flg is the vb code:

I have a workbook with several modules in it to do different tasks.  It was
written in Excel 2003 and it works great in Excel 2003 and Excel XP.
Unfortunately most of the users use Excel 2000 and when the try to do a
simple sort by running one of the modules attached to a button ...

Hi, I have a Procedure that inserts data from an Excel Range into an Access
table.  If there are rows without data in the Range, I get a Run-Time Error
'-2147467259(80004005) because a text field in Access can't be a zero-length
string.  No big deal! I don't want to insert blank ...

I am trying to do an outer join of three tables, using MS Query.  I
understand that this is possible, but that I must modify the SQL
code.  The following SQL code was generated by MS Query to perform an
outer join of two tables, Table_Field1 and Table_Field2.

I have an add-in that uses:
               Set MenuObject = Application.CommandBars(1). _
                   Controls.Add(Type:=msoControlPopup, _
                   Before:=PositionOrMacro, _