I have a range named OMSZ, and I'd like to use this name in Find, but this
line gives an error:
MyVar = ThisWorkbook.Names("OMSZ").Find("StringToSearchFor", [A1], , ,
xlByRows, xlNext).Row

I've exported a file from Outlook into excel and used this code:
Code:
--------------------
   Sub removelinebreaks()

Currently, every night i am reveiving excel file  (csv extension) that i need
transfer to my access database. What I have done everynight is manual typing
to access.
any one can help me so i can use macro to made my life easier please?

I have successfully password protected my workbook AND the VB code, hidden
all worksheets except one that states 'macros must be enabled', and all in
all I'm pretty chuffed.  The only problem is, when the password is entered
into the input box, it can be read by anyone looking over ...

I want to change (in a macro) a workbook name before saving. Fo
instance: the original file is opened as "test.xls", an InputBox ask
for the extension (here: _abc) and on saving the name should b
"test_abc.xls". I don't want the original file to be overwritten. Ho

I am using the code from
http://www.contextures.com/excelfiles.html
to display input messages in a textbox. It is working fine unless a cell
happens to be merged.

I have this problem trying to move a range to another worksheet
For intance I need to highlight and move (also delete leftover blank
spaces) the range containing event column "rev" to sheet 2. The
solution should be able to take any range size (i.e x rows of event

I have about 100 sheets each named in terms of a node in a telecom network.
For each node I have to graph a series of values and also find a max within a
range. I want to use a variable naming convention for worsheets in my VB
code.  For example in the following line of code ...

I have the following Macro,
In the numbers 1-2-3
there is a mistake
Thanks in advance.

I am preparing a basic excel worksheet to present various projects using a 1
line (row) entry for each project. One cell in each row will hold a color
based 'status value', while the next cell will show trend.
I am using 4 colors to represent the status, and a +, - or = to ...

I am an auditor and we use excel extensively to document our work.  We use
text boxes often to write our analysis and audit results.  The word
processing options in text boxes are very primitive.
I suggest that Word and Excel be integrated to a point where a text box is

i try to make a kind of mapping from a external vb application. from
this application i want to open a .csv file, search for a string in the
first column and return the string from the second column in the same
row.

Ok don't laugh (to hard).
The goal is to insert a dynamic formula in Column 'I' Matching the last
used cell in Column 'C'.
By dynamic, i mean the formula should advance each cell downward.

I have a custom menu bar ("DTSheet") with three popups each of whihc ha
a number of (sub)menu items. Each of the three menu bar popups has a
index which I can find using:
For Each cntrl In CommandBars("DTSheet").Controls

I'm trying to verify input given via an input box:
Code
-------------------
   Sub copyData()