Is there possibility to use in a Label caption the greek letter? And
more generally in captions of the ActiveX controls?
Regards
Dan

I just wanted to ask if there is a way of crating a macro of something like
that with Excel.
I need to feel a whole excel file with names, and they will be sorted by
numbers. Then I want to have a window that will have a place where I will put

I have been reading through numerous posts and various web pages on how
to connect to a database and just need some assistance with this please.
I have been given a connection string (from a C# app) with numerous
elements such as server name database name password etc, can I make a

Now here is the problem
i have diff. heading in column and diff. sub headings in the same
column and all sub headings in diff color. now if i give a range of
data in col. a and sub heading in row 10 then it goes on moving to find

Is it possible to type and execute code in the Immediate Window of an
instance of Excel automation?

i'm  writing macros  for an  excel file.
i've a macro which will read the data from  there are 30 to 40 work books
each work book contains 8  worksheets and copies that data
and paste the copied data into new workbook with corresponding 8  sheets.

can we write macro for getting values from a closed workbook and pasting
to another excel file. If possible can it be used for getting values
from multiple files?
This is extremely important..anyone wellversed pls revert

I am trying to find some kind of  Access or excel spreadsheet for staff
shifts or rotas, I am sure there must be an excel spreadsheet template
somewhere, I just can't find it.
Please could you advise?

could anyone help me write macro to open allexcel files from a folder
and copy certain rows and paste all details in a new excel sheet line
by line.
Thanks..

I need to change the value of cells found via application.vlookup in vba
Is there a simple way to do this from a userform?
Thanx

I want my visual basic code to get the value of a cell in another
workbook and put into a variable. Here is an example that does not
work:
Fund1Shares = "'E:\Finance\[Fund.xls]Fund'!$B$3"

i have created a marco to be able to print the sheet to a specified
printer and i have attached the macro to a button, but when i print it
creates another button and then keeps printing the sheet over and over
again and i have to cancel all the prints and close excel. Any

I have this small macro, that after printing 3pages, just give an error,
I guess it need some time of pause between every page, but I don't know
much about this language, (VBA) can someone help me?
Thanks,

Once someone helped me to do so:
 Set MyFile = Workbooks.Open(file1)
-> myfile becomes an object I can work with. (thanks!)
but how do I get the place, where my button is - the sheet, on which

I am new to VBA and need some help. I am trying to set up a worsheet
that will give me a timeline using conditional formating as follows:
Col A will have a input in the range, say 1 to 10, Col B will have a
start date, Col C will have an end date, Col D some other info, and