Okay, I wrote some code in a workbook (moving stuff from excel to word) that
remains in my temp directory.  Now, everytime I open a new workbook, VB
editor for both word and excel open automatically.  I've checked all the
usual suspects (all projects/modules viewable after ...

Thanks kevin for your quick replay, how can I remove it then when I close the
workbook, so that I wouldn't find this button on other worksheets?

I want to read Ms Word file line by line. Is there any way other than
Paragraph & Word to select range. Can i select range in MS word line by
line.
for eg. inplace of following code can i use "Line" in place of

My problem consists of integrating data from two locations.  In worksheet One
I have collected about 500 rows of data over 14 columns.  Column C houses
client names and thus acts as a unique identifier.  The rest of the columns
consists of address, financial data, etc....  ...

I am having touble using looping to remove records that contain a D when
two are together using the following:
Dim constantCells As Range
Dim Cell As Range

I use XP and Offic 2003 SP2. When I select Command Button from the Contol
Toolbox, and try to draw a new button, the button freaks out. The size is set
to
Height 768,75 and width 0,75. The buttonface is transparent. When I resize

I'm trying to set up a script to import a CSV with every column formatted as
text to avoid loss of leading zeros that may be part of an actual barcode or
asset ID. The CSV file itself comprises of close to 100 columns. I would also
like to be able to ask the user for the file ...

I'm trying to select every other row of data (2,4,6,8, etc) and move
these to a new column. What is the simplest and quickest way of doing
this?

I have a spreadsheet using 100 plus named ranges.
Is there a quick way to document all these ranges?
Many Thanks
Paul

i have this in a sheet
in 3 collumns
A=date -B= number -C= value
I want to see the value(C), for

I live in London, and I'm working on a english version of Excel and
VBA..
I've just finished a massive workbook for my mother with standard
english formulas, but it isn't recognised by her norwegian version on

Does anyone know how to change the editor's font size? I work on a laptop and
therefore have limited space.
Thanks

when opening an Excel workbook containing macros...the Excel prompts
always for Enable of disable the macros.
Is there a way to programm this so that this message doesn't appear and
the macros are run (so virtually push enable button)?

What determines the presence of a Horizontal scrollbar on a Listbox? I would
think it would be dependent on the width of the longest string you put in.
But, it doesn't appear that way. The longest string I put in is one
character long with a font size of 9. The width of the ...

I have developed .xla addins.
After installing the addin,
run Excel.exe and add a new workbook and add a change to the workbook,
and click 'x' icon on the top right of the Excel window.