probably not right forum but maybe someone can direct
getting this error
Unable to reigister the DLL/OCX: DllRegisterServer export not found.
comdlg32.ocx is in system32 sub-directory dataed 8/04/2004 10:00 pm 276,992

This is getting rather aggrivating.  I swore this code worked for the most
part yesterday.  Anyway, I am trying to write a code that will Automatically
fill in Data if there is an entry in the Y column.  If there is nothing in
the Y column and there is nothing in the B column or ...

I am trying to do the same thing with my drop down list. I get my macro
to run using the shortcut key, but when I select a item from my drop
down, it does  not take me to another worksheet within my book. The
code is exactly the same, can you help me with this problem.

I need help with a small program to arrange a data file:
This is the data file:
data
A

I need a macro to insert a space every 4 characters e.g.
It will change the contents of :
CY11A01
To

How do i shift alternate cell one place right and then wrap them in a record
occuping 50000 lines. i mean i want to shift B1, then D1 and in B2 and D2
respectively and continie this utill all records are shifted.

I am sorry if this is a too basic question. Unfortunately I couldnot find a
solution so far.
I wish to write a function in VBA which would modify the cells (which is
passed as a parameter) and also return a value. Something like this:

Hi expert,
I have to say that I have no experience in VBscript before, I am a dat
warehouse analyst and need to complete a report out of SQL Server.
I need to have a little excel vbscript with ADO recordset code t

I have created a template in my verison of excel 2000, when testing it in
other versions of excel I have installed on a virtual machine I am getting
the error message
"cannot find project or library ", upon debugging the code I can see that it

How can I specify what the activecell is, If I try to select a new
range (see below) this doesn't seem to change the active cell
(according to activecell.rows)
Excel.Sheets("ALLIncidents").Range("A1")

=VLOOKUP(TM1!B192,(CONCATENATE("List2B_",TM1!B14)),3,FALSE)
This formula, is to check for a value, in a named range. The Rang
depends on what the CONCATENATE("List2B_",TMS!B14) generates...
However Im getting an error when doing this.. anyone know why

I want to sum up the value of the cell A1, A2, A3 and A4 in cell C1
this is done,
by the following
In the Worksheet_change Event

I have an application written in VB which runs a particular macro in a few
Excel workbooks. Is there a way to capture the errors raised in the macro in
VB? Specifically, I dont want Excel or VBA to display any errors. All errors
must be transfered to the VB code calling the macro ...

I have four books that I need to bring one sheet from each into a Maste
book for analysis. The sheets are all in the same format and location.
I have suceeded in pulling the used range from within a workbook bu
not across several workbooks into one.

I need some help on comma separated text files, changing them and
saving them.
I have got two text files.
The first file "ES_EF_AIG_20141440_105708_d.txt" has employee payment