Help with this please
I trying to write for a buton the will change a cell color
each press will increment the ColorIndex property.
Also a question ...does the ColorIndex  # relate directly to the colo

Here's my code:
           UNITFOLDER = "G:\A F S\Monthly Reports\HiPath\CS\"
           FILENAME = "MONTHLYC_"
           NEWDIRECTORY = UNITFOLDER & RPTRUNDATE

I have a .ext file and I won't to convert it into a readable csv o
excel format. Does anyone has a solution?
Kind regards,
Bjor

How does calculation = semiautomatic work?  Can I use this setting to speed
up calculation of certian parts of very large sheets?

I want to know what I will get paid TODAY, THIS WEEK or by the
MONTH.
I don't know how to get the Day (C2),Week (D2) and Month.(E2).
I must add that if today is Thursday I need to know what I will get paid

I tried "DIM A$ AS STRING" which produced an error.
1)  How do you initalize/define a string variable?
2)  What is the proper way to initalize all other types of variables?
3)  Does VBA really restrict things to integers, bytes, boolean expressions,

If I have a scripting.dictionary object that is declared in a module
and used by a variety of functions in my workbook, and then I save my
workbook and close it, will that dictionary still be around with the
same data in it when I reopen the workbook. If not, how could I make it

My code cant seems to work,could you help me modified it,thanks
thousand times!
Sub formula()
'Count how many rows are there in a sheet

This may be simple for someone
Cell A1 = $3,500
Cell A2 = $2,000
example formula

I need an event procedure activate “Application.Calculation = xlAutomatic”
whenver the targeted sheets are selected. I have 10 worksheets in my workbook
where the event procedure should only affect Sheet1 to Sheet6
Purpose:

re: http://www.investor.reuters.wallst.com/stocks/Ratios.asp?ticker=IBM
Trying to retrieve specific info from the web page.
ie: EPS (TTM) vs TTM 1 Yr. Ago
I can't seem to retrieve any data from the page, I have tried using the

If there was a sensible, descriptive name for activex, what would it be?

I'm searching for possibly an add-in for converting hex to ASCII in Excel.

I try to assign my own sound from a list to a  command button.
Can I make this without macros? If the answer is "No". how Can I do it?
Thank for any help
Emil

I have about six worksheets.  Each worksheet has about ten pivots. I change
the raw data each day. After I input new data, I have to refresh each pivot.
Is there any way I can refresh all the pivots at the same time.  One way to
do is by making a macro but that increases the file ...