I have a pop-up web page that takes a dataset and exports it to Excel.  I
have included the code sample below.  When I run this on my local environment
I get a file download dialog that recognizes that format is excel and will
open the file.  However when I deploy it to our ...

I've written the following formula to check if it is the first Monday after
every 29th. It seems work but I don't know it is correct or not, please give
advice, many thanks.
=AND(DAY(G3+7-WEEKDAY(G3-2)-6)>=23,DAY(G3+7-WEEKDAY(G3-2)-6)<=29)

I am trying to get a macro to check column C which is a list of numbers and
letters. If the number is less then 17 then change it to 1.
Example:
Original C             Changed to

I've tried a couple macro's I've seen online, but I can't seem to make a
macro work to hide lines on my worksheet.
I've got a quote worksheet with rows 13:130 available for quoting.
In column A is where the quantity gets filled in automatically from a

New to Excel VBA, old hand at VB, I am having trouble
calling a function from a cell.
What I want to do is update a cell every 2 minutes, where
I plan to use the OnTime method.  So I added a function to

This is my code the part surronded by <<>> is where it errors at.
_________________________________________________________
Private SaveValue
Private Sub Worksheet_Activate()

exel de satıra bilgi girdikten sonra enter yapınca geri al butonu "geri
alınamaz" durumuna düşüyor, yani sanki save etmiş gibi son işlemleri geri
alamıyorum. Ne yapmam gerekiyor, yardımcı olabilir misiniz

I'd like to have a pop-up message that says "Did you remember to mark-up your
quote?", and if they have they click "Yes" and can move on, and if not "No"
forces them to stay on that tab.
There are 8 total tabs, and I simply need it when the go from the tab labled

Hiya,
Can anyone tell me how to do the following
If A1 is Blank and D1 or E1 is greater than 0,
Then a message box to pop up requesting a value (text or number) in A1, the

I have a workbook with 8 sheets, and am trying to copy one of them to
the end of the workbook, using the code below:
Sheets("TR_template").Copy After:=Sheets(nsheets) 'for some reason
after is ignored

Let's say I have a list of 100 districts that cover different areas across
the US.  I have a list of territory managers that manage several districts.  
I have a report that contains 10 columns of data with the district being in
column A.  I want to create a list box with all the ...

Here's my problem, I have a scheduled task set up to run a macro in Excel
every morning, and then post the revised sheet to a server.  Right now,
evertime the program runs, it Excel asks if I want to replace the file that
already exists at the location.  Is there anyway I can get ...

I have following the instructions on creating my pop-up calendars, but
I'm sharing the workbook and some users are having trouble with the
code.  When they open the document and try to click on any cell, the
code window opens and gives them a debug error.  This is only

I have following the instructions on creating my pop-up calendars, but
I'm sharing the workbook and some users are having trouble with the
code.  When they open the document and try to click on any cell, the
code window opens and gives them a debug error.  This is only

I'm trying to the following scenario in Excel2007:
1) Reading binary data for an Excel workbook file and saving these binary
data in Database
2) Reading the binary data from the database and saving it to a file by