Is it possible to assign a variable range to an Embeded Control Toolbox
ComboBox?  If so, how?  Here's the code I've been trying to get to work.
Private Sub Workbook_Open()
Dim IMDS As Worksheet

I have a spreadsheet which needs to be refreshed with current data
periodically.  This spreadsheet is used by people at remote sites that
are not connected to our companies data.  So I email them the raw data
and they import this data to the spreadsheet through VB code.

My code works fine until it hits the command ActiveWorkbook.Save.  That's
when I get teh error:
Run-time error '1004':  Methond 'Save' of object '_Workbook' failed
This code was working fine, but now all of a suddent doesn't work fine in

Thanks to peoplehere, I have a script that's working great for me but it
involves settings comments for cells.  I want to to some more advanced things
with the Comments box but don't know how.
1) How can I add a Line Return in the comments box when adding text to the

I'm using TextToColumns in a macro to convert several huge text files
to a spreadsheet.  Some of the raw data is numbers but I need everything
to be copied as text.  I found this question numerous times in this
forum but none with the answer I'm looking for.  

I am trying to show the format shape dialog in Excel 2007 programatically
when a line is selected, but the below code does not show the form or throw
an exception either, anyone have any ideas?
I have tried setting screen updating to true.

I used the macro below to hide columns, but want to add code that says
unhide all columns and leave the cursor where it is before the below code is
run.  How would I add that into this macro? (I don't want to use 'custom
view' because the cursor is left exactly where the view was ...

Something I thought would be so simple has turned into a nightmare.  I
need to open a workbook named index.xls Read Only and then hide 25 of
the 26 worksheets.  Yes, I tried to create a new workbook and paste
link of the one worksheet I need, but the workbook is heavy laden with

I have a 24meg excel file. I was wondering if using VBA can reduce the size
of the file and make the file calculate quicker?
Thanks

I know how to create email and send it or just display, but i can not
find any info how safe this email as draft, without sending.
BR
JBLPL

How do I do that in VB?
For each value 'abc' is found in columnL starting from cell L2 then
turn values in columnE starting C2 positive to negative (vice versa)
Thanks

VB compiler does not recognize the Vb String function yielding a "Can't find
project or library" error.

I have macro in my workbook (Excel2003) which breaks formula links for text
boxes present in the workbook. The code used for the same is
              "shp.DrawingObject.Formula = Empty"
This works perfectly fine in Excle 2003 but, when run in Excel 2007 all the

Hello I have a On Error Goto statement, yet it only works once, then It just
ignores and tries to execute although this causes it to crash.
I'm attempting to grab stuff from a collection
Set tmp = lookUpCollection.Item("Monkey"), there is no object with the key

I have set of data in two columns. This data should get segregated in
different tables which will further be used for plotting graphs (depending on
the number of tables the data is segregated/ sorted in. The data is like
this: 1-2, 2-3, 3-4, 4-5, 4-6,6-7. Here note that the first ...