Is it possible
I would like to know is it possible to make million dollar in the internet, if you have any suggestions, write on my forumhttp://isitpossible.truemillion.comMark...Personal Folders in OWA
I have just enabled OWA on our Exchange 2003 SP2
through ISA Server 2004. Is there any way to
access personal folders in OWA?
Thanks in advance.
If by personal folders you mean .pst files, the answer is NO! Sorry.
C C wrote:
> I have just enabled OWA on our Exchange 2003 SP2
> through ISA Server 2004. Is there any way to
> access personal folders in OWA?
> Thanks in advance.
"C C" <email@example.com> wrote:
>I have just enabled OWA on our Exchange 2003 SP2
>through ISA Server 2004. Is there any way...Changing items in cells that are filled using Data Validation List
Please let me know if there is any way to use formulas to modify cells that
are populated with drop down boxes from the Data Validation menu. One of our
users now wants to change all cells in a range to N/A if the First cell in
the range contains the value "No".
Thanks for all the help!!
You can do that in 2007 but not in 2003. Well in 2003 you probably could
write code to do it, but in 2007 you can use conditional formatting.
Let me know if you want VBA code or if you are using 2007.
> Plea...Copying last cell's datal in one column to first cell in next column?
I have several columns of data. For instance:
Col B Col C Col D Col E Col F Col G
Row 1 250 125 89
Row 2 125 217 144
Row 3 166 144 105
Row 4 122 110
Row 5 155
What I need is to be able to copy the last item in Col B (166 in Row 3) into
C1 and the last item from Column D (155 in Row 5) into E1 etc. I have three
colums I need to ...cell input on certian dates!!
Ok, heres my question.
on sheet2 i have a list of items in col A that i inventory daily, in
col B i enter those qtys.
On Sheet1 in col A i have the dates for the month
i need sheet1 col b to lookup and input the number from sheet 2 col b
on the spacific date that i am entering it but i need that number to
stay there when i change the number the next day.
i know its kind of vauge but i am new at excel and could really use the
...Downloading Statements Directly Not Possible
I have Money 2002 installed on an Win XP Pro SP1 machine. Something
happened and I probably did it, that causes the statement downloads not to
go directly to the account. Rather they want to be saved in a file and then
opened into Money. I then have to delete the download.
I have tried several things in order to fix this:
1. I verified the file associations of OFC, OFX were correct. They were.
2. Lowered all my security settings in IE. Even put banks into Trusted site
zone. No go.
3. Made new accounts. Didn't help.
4. My IE cache is large (500MB) and regularly cleaned out.
5. I made s...finding a cell address
I am still working on a vlookup table to return more All values for
given lookup value. I have found a way but need a little help.
my first value is easy it just looks at the range of the whole databas
lookup range= a:d
The second value is tricky, what I need is a formula that will give th
me address of the 1st match+1 cell down
what will give me lookup range = a2:d3
The third would be the value of the 1st match +2 cell down
My data is sorted by col. A in ascending order -- thats why once i
finds the 1st one if there are any more it will be in the next row.
I have an example if needed
...is this possible? reload a form that is based on a query with new query that is defined in the form.
I have a basic form.
The form is based on a query, so when I open the form, a pop comes up
where I enter in what I want to query.
So instead of 30,0000 records, I get 1-10 records.
on the form, I have a text box. I want to be able to enter in what I
want to query next and afterupdate have the recordset/form reload with
that query instead of my original qeury.
I figure this has to be done with VB. I am just starting to learn some
VB but I am lost.
Any info would be great, thank you.
You need to apply the new query or table name, or the sql string to
the forms recordsource, then...Possible to detect changes to an XmlDocument object?
If I instantiate an XmlDocument object, the load a file through the Load
method, is there a way, later on in execution, to easily determine if the
XmlDocument object has changed from the original version loaded?
I'd like to be able to check a condition to see if the document in memory
has been editted (i.e., nodes added, attributes changed, etc.) so that my
user can decide whether or not to commit changes to the disk file before
moving to another file.
Will I have to resort to re-loading the file, and comparing OuterXml
Gabe Covert wrote:
> I'd like t...Is it possible to compare a string and a field name
I have the following tables: Membership, Subscriptions, OfficeUseOnly. The
Office Table contains a Year, Year To and From [financial year] and the other
fields are the 5 membership types (regular, student etc) and these 5 fields
contain the different amount each type of member has to pay.
I want to create a form whereby on entering the financial year and the
membership type the correct amount is automatically inserted into the
FinancialYear - in current form = OfficeUseOnly SubsFinYear
and then if MemberType = 'Student' find Student field ...selecting like cells in a column
First time poster...wish I would have found this place a long time ago!
I need to select 'like' cells (i.e. same value) from a column (for use
in a macro so I can't just point and click). The like cells are
actually grouped together. Sounds easy enough but I can't find a
shortcut key to do it and am trying to avoid writing vb for this part
of the task.
Message posted from http://www.ExcelForum.com/
-- View and post Excel related usenet messages directly from http://www.ExcelForum.com
-- Hundreds of free MS ...Excel 2002 SP3 CSV Format Cell 'Special' Leading Zero
Excel 2002 SP3, CSV File, Format Cell 'Special' for Zip
Code Leading Zero does not work.
Is there any way to maintain the Zip Code Leading Zero
(New England States) in a CSV File? I have tried
Format 'Special' and 'Text' and have found the only
solution to be to place a leading ' with each zip code.
This is not a very practical solution.
Is this a configuration problem, a bug, or a limitation of
the CSV file?
you may use an adjacent cell with a formula for this. e.g. enter in B1
or something similar according...pictures in various shapes
Is it possible to insert a picture and make it into a circle or an oval or
various other shapes than just squares and rectangles? Thank you ahead of
with a graphics editor
Microsoft MVP - FrontPage
"Stephanie" <Stephanie@discussions.microsoft.com> wrote in message
| Is it possible to insert a picture and make it into a circle or an oval or
| various other shapes than just squares and rectangles? Thank you ahead of
> Is it possible to insert a pict...Is this possible
I want to make a list of the files in several different
folders. Is it possible to somehow "Copy and paste" just
the filenames into a list, in either Word or Excel or
Wordperfect. I am just trying to sort the files in
several different folders to weed out duplicates. There
has got to be an easier way then typing them all or screen
printing the lists and manually weeding them out. Any
Here is some code that will start in a directory and list all files in that
and any sub directories. It uses recursion to go through all the subs.
Just ch...using the cells property for use with Application.WorksheetFunction.Sum
Has anyone had any success with using the Cells Propery when using the
Application.WorksheetFunction.Sum function? My code is below:
Sub AddDataMorningMil(mon As String, Day As String, yr As String,
intDOW As Integer) 'DOW = Day of Week
Dim x As Integer, row As Integer, colStart As Integer, colEnd As
Integer, varSum As Variant
' -- Friday column & starting row
colEnd = 6
row = 15
' -- Get the start column & row
Select Case intDOW
Case 2 'Monday
colStart = 2
Case 3 'TuesDay
colStart = 3
...Is this Possible ?
Have a newsletter document with text boxes that have no outlines but
internal gradient colour fills.
Is it possible that a macro could remove all colour fills in one hit just
leaving the text in place ?
Dim oShape As Shape
For Each oShape In ActiveDocument.Shapes
If oShape.Type = msoTextBox Then
If oShape.Line.Visible = msoFalse Then
oShape.Fill.Visible = msoFalse
should clear the fill from text boxes that are filled and have no border.
<>>< ><<> ><&l...Is Batch Marking Possible?
I am doing a mass mailing from Outlook. I will print 50 address labels per
day. Is there a way for me to batch-mark the contacts for which I print a
...Entering Mutliple times in a cell #2
So with the 2 replies I have so far, I gather that I can't put the 3
times in one cell and Excel is able to calculate it??
gary66's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16060
View this thread: http://www.excelforum.com/showthread.php?threadid=275186
Yes .. you'll get #VALUE!
Please respond in thread
"gary66" <firstname.lastname@example.org> wrote in message
news:gary66.1f...extracting comments in a cell and making these part of the Chart .
I would like to extract comments in a which I have added in a cell and
making these comments part of the Chart Title
Click once on the title of the chart. Next, go to the formula bar and type
"=". Finally, click on the cell reference that you want to show in the title
and hit the Enter key.
> I would like to extract comments in a which I have added in a cell and
> making these comments part of the Chart Title
Thank you for your help. It did work!
...in access, round up to nearest fraction(.5)
In MS-Access, How do I round a formula result up to the nearest fraction
(Specifically the nearest half). Example: 1.3 rounds to 1.5, while 1.7
rounds up to 2
Multiply the value by two, then round to no decimal places, then divide by
> In MS-Access, How do I round a formula result up to the nearest fraction
> (Specifically the nearest half). Example: 1.3 rounds to 1.5, while 1.7
> rounds up to 2
I NEED TO HAVE A DROP DOWN WINDOW IN CELL A1 TO POPULATE A LIST TO B1, B2,B3
Please drop the CAPS and describe what you mean by "populate a list"
What type of choices would you have in the A1 dropdown and how would that
determine what goes into B1:B4
Where does(do) the B1:B4 list(s) originate?
Gord Dibben MS Excel MVP
On Fri, 15 Feb 2008 20:02:01 -0800, ELBERT <ELBERT@discussions.microsoft.com>
>I NEED TO HAVE A DROP DOWN WINDOW IN CELL A1 TO POPULATE A LIST TO B1, B2,B3
First, name the cells B1 to B4 :
by selecting B1 to B4 and g...Cell References #3
I have 2 separate work sheets. I want to copy the values of cells in work
sheet A to cells in Work sheet B. The values in A are separated by at least
4 rows. Cells in B where I want those values are separated by 1 row.
How can I copy the values without having to enter each cell reference
indivudually in B?
Is there a formula to add columns or rows such as cell A1+3 = cell D1 or
cell A1 + 3 = cell A4
> I have 2 separate work sheets. I want to copy the values of cells i
> sheet A to cells in Work sheet B. The values in A are separated by a
> 4...Is it possible to make cmd window to flash?
I have an existing VC2003 windows console program. Now I want to add a alarm
feature to it, the simpliest way is to make the cmd window to flash. Can
this be implemented?
>I have an existing VC2003 windows console program. Now I want to add a alarm
>feature to it, the simpliest way is to make the cmd window to flash. Can
>this be implemented?
If the console is running in a window, I presume you can use the
FlashWindow(Ex) API. In newer OS's you can find the console window
handle using the GetConsoleWindow API. For older OS's here's...Defining cell with only through 1
I want to define all the cells where the integer only goes to 32.
Meaning when I enter in A1 167.700.25 and A2 152.30 and I want to subtract
A1-A2 = 7.70 where the inetger goes to 100.
I my case I want it to go only to 32.(1/32)
Meaning if A1 110.15(.15 should be formated as actually .15*32= 0.048) so
instead of 110.15 I want the cell formated so I can input 110.15 and it
writes as 110.048. OR it even if it lets me input 110.048 is fine which ever
The reason I want it done is because I am dealing with interger which are
expressed in 32nds. thats is 1/32, 2/...Multiplication of multiple cells
I am trying to put my school dinner register on excel.
I need to be able to work out how much money is due by adding the number of
meals ordered (involving more than one cell) and then multiplying that number
by the cost of the meal e.g. £1.60
How can I do this?
where a1 through a17 represents the number of dinners and 1.60 is the price
you are mentioning...
"Littlecharmer" <Littlecharmer@discussions.microsoft.com> wrote in message
>I am trying to put my school dinner regi...