Hi there - please excuse my ignorance - I've never used VBA before so
I do need some help!
I would like to make the replacement text into autocorrect formatted
into italic text (as it will be latin text) - I have the following,

Hi all, i am wanting to save a file "myFile.xls" as "myFile_Apr-08.xls".
It must always be the last month to present date.
Any help would be much appreciated.

I have foll data
criteria     score    Unique   answer
yes    4          yes       20
yes    6          no        116

Hi All.......
Here's a snippet of code, mostly taken from Ron de Bruin's fine
page.......it works fine for preparing to send an email in my Lotus
Notes.......it takes it right up to the point where I have to press the

following code via macro recorder is intended to create a named database
range "Format_all" via cursor movement selection and then to format for
printing uisng data sort commands. But I need to eliminate fixed range
definition since the number of rows of data needs to be able to ...

How to restrict textbox in userform for the following entry
SEP 08
I mean first three cheractors Alphabatic and space and two cheractors
number.

I need to create a link in excel cell which can execute set of dos commands.
Can anybody help me out?

Hello, I'm building a solution that is heavily dependant on dates, the
problem I'm having is in certain situations it's switching the day and month
around. I'm from the UK so we use dd/mm/yy - where as Americans use mm/dd/yy
so I'm guessing it's somehow reverting to American ...

I am writing a query to populate an excel sheet in the same way that I
have in many occasions in the past:
1) open the db using DAO
2) run the query with OpenRecordset

I have two worksheets: 1 and 2. In worksheet 1, I have all my raw
data. In worksheet 2, I want to only display the sum of some of the
cells in worksheet 1
e.g. Worksheet 1

I'm getting an "invalid procedure call or argument" every time I try
to take control of a collection of files that I've grabbed. With this
setup:
Dim wkbk1 As Workbook, wkbk2 As Workbook

I have a SQL export which comes as an excel file containing a large amount of
data I don't need.  I would like to write a macro to find and organize the
data based on the column headings, however, the columns are variable so I
cannot use the column reference.  I.e. I need to find ...

I'd like to retrieve some data (name, department, e-mail address) of members
of a group from Outlook Address book from Excel VBA. Please, help me how to
do it!
Thanks,

I have a UserForm in which I have a List Box. The user can add items
to the list box. At the end I have to get all items from the list box
control and transfer them into a spreadsheet column.
Appreciate any help to achieve this.

I have an application that walks through all the Excel files in a huge
directory tree and, for each Excel file it finds,
1.  It opens the Excel file,
2.  checks the Workbook Object properties of that file,