Need help getting files from Exchange Server.
We have a computer that had an account on Outlook
attached to a Microsoft exchange server.
Apparently for the moment, this computer and the
server are inextricably tied together. Outlook cannot
even be started without logging into the server
because information store or whatever is missing.
How do you get the information out of the exchange
server to wean the computer from it?
tom <Spamblocker@ameritech.net> wrote:
> We have a computer that had an account on Outlook
> attached to a Microsoft exchange server.
> Apparently for the moment, this computer and the
> se...when i save a file that i have worked on, excel7 closes down work.
i have recently purchased office pro 2007.
Excel 2007, when i save a filethat i have worked on, excel closes down and
work is lost, done all updates, re installed from disc, please help i have
lost 2 hours of work this moring that i need for a report
a few questions:
1. what happens with save as?
2. what happens in safe mode? (hold shift key while starting excel)
3. do you have add-ins?
4. what operating system? x64?
"rob" <firstname.lastname@example.org> wrote in message
news:0483F09B-3289-42B4-8849-0C0A61380B11@mic...Macros at POS
How far can you take the macro feature?
If for example i want to discount an item by a set amount or by a percentage
for customers who have a voucher, could i set up a macro which would find
and discount an item in a transaction?
or is this asking too much?
Yes, that's too much for a macro. You can do it with a COM add-in ,or
have it done or look into an existing discount or promotion add-in.
Macros can only emulate keystrokes or mouse clicks - there is no way to
include IF..THEN logic.
Tiber Creek Consulting
---------...Just saved file, cannot be found. ?
Even Global search ?
Win 7 ...
if you saved it, it should be in the mru list? what version of excel are you
"Boswell" <Boswell@discussions.microsoft.com> wrote in message
> Even Global search ?
> Win 7 ...
> Whatz up?
one other question, how did you open it, outlook email? if that's the case,
search will never find it. it is probably here:
C:\Users\Your user name\AppData\Local\Microsoft\Windows\Temporary Intern...Please help, I know nothing
I am a very new at this and it is driving me crazy.
For example, I want to add all of column A + column B and I want the answer to go in C. I want this action to always happen automatically. How do I do this...in easy, non-math language??
I understand the basic concept of the formula, but it will only do it in C1, e.g
I also get the error #name? Where do I enter this "name" and what is it referring to
I would appreciate any and all help
your question is a little vague
do you want c1 to add a1 & b1 then c2 to add a2 & b2
If yes then in c1 type in
o...AFX_MANAGE_STATE() macro disturbs the startup position of the ATL dialog
I have a MFC dialog based application and a COM component developed
using ATL with MFC support. The COM component exposes an interface
ISum that has a method called Add(). The Add() method displays an ATL
dialog that accepts numbers from the user on which addition is to be
performed and displays the result as well. The contents of the Add()
method are as given below:
On click of one of its buttons, the MFC dialog application,
instantiates the COM component and invokes the ISu...Help with ActiveX
I am just getting my feet wet using MFC and am having trouble with an
ActiveX control I created. Essentially, I need an ActiveX control that
is a container for local controls. What I have is a set of instruments
with slightly different communications needs. My plan is to have
separate controls for each instrument so that I can use a single exe for
all of them. The exe provides the user interface while the ActiveX
provides instrument feedback. There are no input fields on the ActiveX
but there are several text fields and a progress bar. I am managing the
text fields and progress bar in...Removal of Outlook 2000 from XP home Help
I am attempting to remove an unauthorized version of Office 2K from a Win XP home computer. The Removal went fairly normal except that now when accessing any E-Mail client, the Windows installer is attemtping to install something from the Win 2K premium disk. Is there a Registery entry causing this problem? Is there a way to stop this from happening?
do you know what it's installing and does it fix it if you give it the disk?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Outlook Tips: ht...Help me create sales chart based on state and quantity
We have a production report on excel. It shows the details for our clients.
Part of that data includes the state in which the client lives. We are trying
to create a chart showing the percentages of each state( so we know where the
most deals are closed)
this sounds like a job for a pivot table, using Average as the data
Or, depending on your version of Excel, you can use AVERAGEIFS (in Excel
2007) or calculate an averate with a combination of SUMIF divided by
To be more specific, it would help to s...run Microsoft Publisher 2002 macro in command line
This might look simple but I cannot figure it out.
How can you run a Microsoft Publisher 2002 macro in command line?
(like in Word, you can do winword file.doc /mNAMEOFTHEMACRO )
In a command line I am not sure. Try posting at
Microsoft Publisher MVP
>This might look simple but I cannot figure it out.
>How can you run a Microsoft Publisher 2002 macro in
>(like in Word, you can do winword
file.doc /mNAMEOFTHEMACRO )
...Help with formula #28
I have an excel spread sheet with formulas that work correctly, when I email
them to another person and they open the attachment all looks ok. When they
save the excel file to their PC and open it the formula cells now all have
#Name in them. Anyone know what is causing this???
The error message gives us a clue: Excel can't find something - things to
1. Make sure the receivers all are using the same add-ins as the sender
2. Make sure that personal.xls is the same for the receivers as the sender
3. Make sure all defined names are the same
"Play...need help Combo Box with duplicate entry.
I have a combo box with unique and non-unique entries. (search field)
00010 | john | smith | 12345 | 00002
00196 | jane | doe | 0120 | 00001
00196 | Jone| wood| 0220 | 00005
I would like the following to happen.
1) user types the number needed ( 10 )
2) the combo box zero fills the field (00010)
3) then selects an entry from the combo box. (12345)
if the select is incorrect ( one of the non-unique numbers was selected -
the user will open the combo box and select the correct entry. (jone wood)
add the info will be put on the form.
the following code works if the user ente...How to get the handle of a Help file belonging to other process.
In my application,I want to change the Index of a HTMLHELP
file which belongs to a dialog running in other exe.In order to do this
I need to find whether the Help file is open or not & get the handle of
that to use HH_DISPLAY_INDEX .Is there any way to do this??
Note: I dont want to use FindWindow() as it is giving rise to some
problems in my application..
Thanks in advance
...Help with cells auto formatting
I have posted a similar question before however I never really got this
sorted so sorry for repeating myself.
Basically I use two spreadsheets daily at work all with various information
on and various formats in each Column. My problem is when I close the
spreadsheet and reopen it the cells that are formatted as 'general' or
'number' turn into Euro currencies.
Does anyone know why this happens or how I can stop it? The spreadsheets
aren't stored locally they are stored on a serve that only myself and my boss
can get onto and we both have the same p...Help on adding values to a bar chart
Here is my problem. I currently have a bar chart that has 8 X-axis
bars. I need to add 2 more to the X-axis. The labels for the x-axis
are based on cells within another spreadsheet, but are not consecutive
cells, they are spread apart. So when I go to add the two more cells,
I can only add one. When I click on the second cell to add it to the
list, all of the previous cells get unselected. I have even tried to
manually add these two values in. Is there a limit to how many values
can be on the X-axis? Please Help!!!
To select non-consecutive cells: select first cell, h...Lookup Help
I have a spreadsheet with three tabs.
Tab 1 needs to perform summary calculations
Tab 2 & 3 are ODBC connections with source data from other files.
Tab 2 is a sql query that is a cross tab with columns 1-4 representing row
data and then the remaining columns are employee ids with a productivity
value in their column. Not all columns have the same value as they correspond
to a job/service performed on a specific date.
My problem Tab 1, column 2 contains "completion dates from 1/1-current and
refreshes based on tab 2 each time it opens. I need a lookup formula that
wi...Excel spradsheet automation help
there are 3 sheets in an excel spreadsheet say the names are 1,2 AND3
layouts ar ethere for all 3 sheets.
the first sheet is used as input and based on certain fields/columns in the
first sheet i need to populate entries in the second and 3 rd sheet.
teh main purpose is taht based on the first sheet the 2 and 3 sheet should
be automatically filled. wat kind of formula / macro should i be using ..
im new to this and jsut know to create macro. CAn anybody help
ON either Sheet 2 or Sheet 3, you can put this formula in any cell and it
will return whatever value is in cell A1 on sheet 1.
=Sh...help with Excel Chart, Series name
I am using ORACLE OLE2 package to print a series bar graph in excel. I need
to rename "Series Name" that comes out in as a char in excel. By defual the
series are names as Series1, Series2, Series3,.....SeriesN. How can I access
the handle to "Series Name" which help me change its name. Any help will be
Manally, you do this with Chart - Source data - Series tab. There's a
series name box. Select the series to be edited in the drop-down at the
left first. It may have a cell reference currently in it, or you can...Outlook Express address bk. from Mac to Outlook PC ?? Help
I am trying to export the address bk from my Outlook Express (Mac OS 9.2) to a form that my Outlook PC (Windows XP) can read and use. Any thoughts on what procedure to follow. When I export from the Mac it just saves it as a "Simple text" file - no much good for what I want to do. Any thoughts???
...Help Needed With Write Conflict Error Message.
I have an order form that users open and close on a regular basis. The form
is based on a query. On the form are two fields, "TicketPrinted" and
"RevisedDate". Most of the time the field "Ticket Printed" has a value in
it of "Yes". What I want to be able to do is that if a date is entered into
this "RevisedDate" field, OR if the information is changed in this "Revised
Date" field, that when the user closed the form, an update query runs that
changes the "TicketPrinted" field from the original value of "Yes"...I Need Help #2
For whatever reason when I import certain text files, the
numbers in certain cells come up for example: 24,00 which
excel doesn't recognize. How do I tell the spreadsheet
that any cell that has two digits after a comma to add
another zero at the end?
I am not sure if this helps you, but when you select a
cell (or range of cells) hit ctrl+1 or go to format/cells
the dialog box lets you customize the cell, the first tab
is number and this lets you select the type of cell, like
number/text etc. under number it let's you select the
decimal numbers desired after a comma.
>...saving/moving outlook files
I need to re-format my hard drive and re-install my OS
after being infected with a trojan. How do I download my
Outlook files to a disk and then move them back to my hard
...Macro help #6
I can't figure out how to set up VLOOKUP formula with 2 variabl
After the intial formula runs in the specified cell, I want 2 element
changed: the location of the result and the lookup value.
In the case below that would be B1 and A2.
Range("B1") = Application.WorksheetFunction.VLookup(Range("A2"
Range("data"), 2, False)
I've tried setting it up like this:
Dim i, k As Integer
For i = 1 To 2
For k = 1 To 2
Range("B" & k) = Application.WorksheetFunction.VLookup(Range("a"
i), Range("data"), 2, False)
...Save as JPEG: no margins
Using Visio 2003, I saved a drawing as JPEG.
However, I would like to have margins around the shapes.
How can I achieve this?
Draw a rectangle around everything.
Give it no fill.
Set the line transparency to 100%.
Now export to .jpg. You should get your margins!
Hope this helps,
"Nananana" <email@example.com> wrote in message
> Using Visio 2003, I saved a drawing as JPEG.
> However, I would like to have margins around the shapes.
> How can I achieve this?
...save a resualts calculation in one column
I have one problem for save and record for resualts of calculation on
formula in cells of one column.any time i repeat calculation, th
resualt save in first cell(link cell) and not move to below cell ,i
the other word ,i want for any calculation by formula resualts save i
next cell(without change of last try ).
ras-mir's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1537
View this thread: http://www.excelforum.com/showthread.php?threadid=26994