I know there is a simple answer to this, but I can't seem to find it in the
help file. I am using the VBA print# statement to create a text file with
numbers in right justified columns. One of the columns will contain a
floating point value and I need to contol the output width ...

I am trying to fill every column for B to whatever with "test".
I use following function to define the range. In this case Last_Column
= 12
Function Last_Column(My_Range As Range) As Long

I've created a Shim dll for my AddIn assembly. The Shim dll was built
as a VC++ project. I need to use this dll in my .NET project but it
says that the dll is not a valid COM component.
Aren;t these shim dll COM components ?

To all,
I have a macro that imports some data from a text file, and then
produces a graph of the data. I then save only the graph, and
associated worksheet ( i.e. the data ) as a seperate file. I use the

When I attempt to use the line -
xlBook.SaveAs (documentName)
to save an excek document I have created (or edited), I get an error
when this document is open by another process. I'm creating this excel

This is my first post. I have two list of data and want to extract
continous range.
eg. 1    2
     2    3

I have tries to find it in the Help section as well as in this
newsgroup, but without success.
I have a column that fill itself with data from countif formula. ok, so
far.

How can i modify macro below - to make it work for only sheets i've
selected (group) - instead of all sheets in active workbook.
Sub RenameWS()
   Dim ws As Worksheet

Filtering a list of email addresses in 1 column is very easy. But how can
the rows in other columns also be eliminated together with the duplicate
addresses?
Perhaps I haven't expressed myself clearly.

I'm trying to create a new collection containing all worksheets in the
active workbook except the last one, but I failed. Please help!
Regards,
Stefi

My macro fetches data from a website. I want this macro to get the data
every 30 seconds.
So I've inserted a time delay. Here's the code.
Start = Timer ' Set start time.

Dear Sir,
I had heared about Add Inns Functions.
Can you hap me in this reagrds. I want to know how to put all the
macros in one place & how to call them and how to create Add Ins.

11/01/06    10.0
11/02/06    10.0
11/03/06    10.0
11/04/06    10.0

in VSTO 2005, is there a way to get hold of the selected cells.
Say, user hold the Ctrl key and select multiple cell, is there a way to
get hold of them in VSTO? ActiveCell doesn't seem to be the answer.
THanks a lot

I'm looking for a way to read the tag information from an mp4 audio file
(m4a) into excel. Could anybody point me to some vb/vba sample code to read
the tags/atoms from an m4a file ?
Any help is appreciated,