RMS mysteriously stops tendering- help!
We're trying to install RMS on some new machines and the tender function
mysteriously stops working not long after it installs. We use Mercury's TPI
software (which continues to work on older installations) and it will work
for the first couple of test transactions, but inevitably fails not long
after. It throws no errors; nothing in RMS, its log, SQL, or even the Event
Viewer. We just click... and nothing. There is no consistency between Windows
versions (XP SP2, SP3, Vista) except for the persistence of the error.
We're desperate! Anyone encountered this before?
did you...Excel settings saved with file
Do Excel settings get saved with a file? If I choose
Tools/Options/Calculations/Manual and save the file, will
anyone else who opens this file automatically receive
this same setting even if they have selected
Tools/Options/Calculations/Automatic? This has been
occuring to a particular file several coworkers use, but
it seems like this setting should be user specific and
not file specific.
The first file that Excel opens on each PC will set this setting.
Regards Ron de Bruin
"j-dawg" <email@example.com> wro...Stopping a Loop
This is a great formum. Hope I don't wear out my welcome.
I have a form which is filled based upon a search of a specific string in a
specific column i.e. 455-203-23. On that form there is a commnad button that
calls an addtional search of the database to see if there are other records
with the same string exist in the database. It works great, however, I can't
get it to stop once its gone through the entire database as it simply goes
back to the first record in the database an starts over. Any suggestions as
to how to break the code once I've reached the last ro...Trouble with creating tab stops
This should be very simple but haven't found the answer in all the posts.
Following the "Create or modify a tab stop" instructions I can't get the
first tab stop to respond to anything but flush left. Center, Decimal, Flush
Right all do not seem to work. I'm sure it is simple and something I should
be able to do. My many searches re-phrasing to advance the search only take
me back to "Create or modify.....".
"Midge" <Midge@discussions.microsoft.com> wrote in message
>...transfer information from a site into excel
How can I take daily information on a website amd link it to an excel
I want this to be instead of cutting and pasting !
One thing you can try is, in the body of the web site, right click and
download to excel. This creates a web query that you can modify.
"joe l" <joe firstname.lastname@example.org> wrote in message
> How can I take daily information on a website amd link it to an excel
> worksheet ?
> I want this to be instead of cutting and p...how do I turn off requesting scan when opening Excel (Office XP)
Whenever I start Excel, it takes awhile as a message appears in the status
line indicating "requesting virus scan". I have three trusted add-ins which I
use which contain macros, and have reduced macro security level to "lowest",
but cannot stop this action from occurring. Any suggestions would be greatly
If you're using Symantec/Norton AntiVirus, try disabling the
Office Plugin that comes with it. See
http://support.microsoft.com/?kbid=329820 "How to use Office
programs with the Norton AntiVirus Office plug-in" for more
ch...Excel update on broadcast
Hello Fellow Excel Developers,
I am using excel sheet from VB. On firing of a particular user drive
event excel sheet is opened with some data (list of exchange trade
As rate of these symbols keep on changing very frequently probably 3 o
4 times in one second. Broadcast events are raised from VB to chang
Worksheet in excel(no VBA coding is done in excel. All coding is in V
Row is found in excel sheet for matching symbol and market parameter
are updated in excel sheet.
The problem is Excel is eating up lot of CPU utilization sometime t
the extent of 70 - 80%.
Can any on...After installing Office XP SP3, Excel ActiveX controls are moved a
using Print Preview.
With Office XP SP2, ActiveX Controls (combo boxes, buttons, etc) stayed in
the correct location after using print Preview from the Excel File menu.
After installing Office XP SP3 and using Print Preview, all controls on the
spreadsheet are moved to the left hand side of the sheet.
I thought it might be becuase the sheet was created in the older version,
but I also see this with ActiveX controls added to sheets created with the
new service pack.
Does anyone know a solution to this problem?
Con...Two workers on the same Excel sheet
Pretend the situation that one worker ( 'person x' ) have made update
in a Excel datasheet and send it to the worker of the administration
'person y' ). When 'person y' recieves the datasheet, he makes so
changes in the datasheet.
Two hours later 'person x' finds out some errors in the last datashee
he sent, updates it again and send it once again to 'person y'.
How can 'person y' import ( after confirming the changes ) the ne
changes made of 'person x' to his datasheet ( the first datasheet h
Message posted fro...Excel Printing Question
I currently have a spreadsheet that has many worksheets on it. Is there a way
that I can print all the content on all of the worksheets with one click of a
button or do I have to click on each individual worksheet and click print?
You can select all the worksheets (click on the first and ctrl-click on
File|Print|Print What (check entire workbook)
> I currently have a spreadsheet that has many worksheets on it. Is there a way
> that I can print all the content on all of the worksheets with one click of a
> button or do I have to...Hyperlinks in Excel 2003
Hi all: Is it possible to download from the internet into Excel 2003, once
saved to remove the ‘Hyperlink’ in one go, at the moment I have to do ‘Remove
Hyperlink’ at one cell at a time. Question how to remove all Hyperlinks’ in
one ‘Select All’ and then away to remove all in one or two clicks. Thanks to
all who can help.
Try this tiny macro:
Gary''s Student - gsnu200847
> Hi all: Is it possible to download from the internet into Excel 2003, once
> saved to remove the ‘Hyperlink’ in one go,...Hot End client [ Excellent Rate]
We have the following requirement from our end Fortune 200 client:
Job description: Team Lead- Siebel product & Pricing.
=B7 3+ years Siebel Order Management experience, min one year
with version 7.8
=B7 Telecoms industry/Siebel eCommunications experience
=B7 Ability to work closely with the onshore team and interpret
Products & Pricing requirements & High Level Designs into the Siebel
detailed solutions (LLDs)
=B7 Deep Siebel Products & Pricing expertise including Product
Configurator and modelling in Telecom industry
=B7 Deep...Adding Attachment in OWA stops Information Store
When users attempt to add an attachment to a new email through OWA,
the information store service shuts down. I get an error in the event
log that reads:
Unexpected error <<0xc1050000 - Network problems are preventing
connection to the Microsoft Exchange Server computer. An unexpected,
unknown error has occurred. Microsoft Exchange Server Information
Store ID no: 80040115-0514-000006bf>> occurred.
If I restart information store service everything seems fine until
some tries to add an attachment again.
I am running W2k3 Server SBS Standard Edition. I tried installing SP1
for E...downloading excel file from email problems
I have an Excel spreadsheet someone emailed me. I am not able to open it for
some reason. I have WinXP. Excel 2002 or 2003. My Temp Internet files are
empty. So are my %TEMP% files. Their version is recent as well.This is the
second time the email has been sent to me. No error messages. The
first time I tried to download it, a screen smaller than my normal screen
seemed to blink quickly then disappear. I checked the Properties of the
file but it said 0 kilobits for all areas. The second email said this
informaiton was not available (Properties info). The second email did not
blink when...Pre Decimal Currency
I want to replicate some historical bookeeping in Excel. The currency I want
to use is pre-decimal Australian Pounds Shilling and Pence where 2 Halfpenny
= 1 Penny, 12 Pence = 1 Shilling and 20 Shillings = 1 Pound.
Does anyone know how this can be done?
It rather depends what you want to do with the answers. Obviously I
would think that you want to get the figures you have into something
that the computer can use, add them up etc. Expressing the results back
as LSD might be a bit more tricky.
I think that the easiest though perhaps not the prettiest way is to
segregate the pound...RE: WATERMARK FOR EXCEL
IS IT POSIBLE TO CREATE WATERMARK IN A EXCEL WORKSHEET
"kEN" <CAMPFIRELB@EARTHLINK.NET> schrieb im Newsbeitrag
> IS IT POSIBLE TO CREATE WATERMARK IN A EXCEL WORKSHEET
"Frank Kabel" <email@example.com> wrote in message
> Frank Kabel
> Frankfurt, German...Alternatives to VBA in Excel
excuse my cross-posting, but I do not know which NG is the appropriate for
I wrote an Excel-Macro in VBA which reads a text file, interprets this file
and then does in Excel what has to be done: format cells, put values to it,
storing files, inserting worksheets etc.
This works well, as designed, but is not very fast.
So I look for a way to increase speed.
I have Visual C++ 6 in Visual Studio. Can I rewrite my macro in Visual C++
so that it gets faster? If yes, where do I find "easy to understand"
descriptions how to do this? What do I need additionally?
Thomas Kr...Stop all macros
I have a button on a form, which should do different things depending on
1. The data contained within the current record;
2. Whether the current record is a 'new record';
3. Whether the current record is the first record in the form.
On click, an embedded macro is initiated. Each step in the embedded macro
has a condition and a corresponding 'RunMacro' action.
All the conditions are mutually exclusive, and each sub-macro has a final
step of 'StopAllMacros'. So the embedded macro should trigger one, and only
However, it appears that what is act...Can I make different colour gridlines in a single chart in Excel?
One particular horizontal gridline in my Excel chart marks a significant
limit. This gridline should be highlighted.
The gridlines above and below this can remain black.
The best bet is to introduce an extra series, with X values at (or beyond)
the min and max limits for your chart, and Y values at your particular
"cambium" <firstname.lastname@example.org> wrote in message
> One particular horizontal gridline in my Excel chart marks a significant
> limit. This gridline shoul...Excel and macro
I have an Excel worksheet and am wanting to make it intereactive so scores
(from a questionaire/assessment) can be entered in by the user and the
results of the assessment displayed.
What I'd like to know is how to write a formula/macro which looks at 4
scores, notes the results of # 1 and# 2 in order, and displays text based on
Is this possible in Excel ?
Many thanks in advance
I'm not sure what you're looking for, but the LARGE function can
return the nth largest number from a range. For example,
will return the largest numb...how to hyperlink to a particular worksheet in Excel 2002
This help on support center Knowledge Base is for Excel
97: KB172503. This shows how to link a particular
worksheet in an Excel Workbook from a href link in a html
page. The worksheet name and cell range should be given
as after the Excel file name:
href = "http://www.server.com/file.xls#sheetname!A1:G100"
This does not work for Excel 2002. Is the method
this should also work for Excel 2000. What is your exact formula /
"Setmadlam" <email@example.com> schrieb im Newsbeitrag
...how do i create reminders in outlook from a date cell in excel?
I need to know how to create reminders in outlook from a date cell in excel?
Try posting in an Outllook forum. Maybe they will be more helpfull.
Greetings from France
"Philhegele" <Philhegele@discussions.microsoft.com> a écrit dans le message
>I need to know how to create reminders in outlook from a date cell in
I need to clear out email that I have synchronized to
offline folders. But I cannot select the "only when
online" option in the Syncronization tab under the
properties. Anyone know how I can unselect the "when
offline or online" and select the "only when online" option???
I'm confused - why can't you just delete the items you wish and synchronize
to the server again to your mailbox?
Or are you saying you want to stop synchronizing certain folders entirely?
What version of Outlook, and which folders?
Bob Keenan wrote:
> I need to clear out email tha...Excel data selection
I have several files with 5-10,000 rows of data. I'd like
an easy way to keep every 5th (or 7th etc) row of data and
delete the rest.
Is there a simple way to do this without manually deleting
the unwanted data?
I'm using Excel 97.
Maybe you could use a helper column with a formula like:
Apply data|filter|autofilter and show the rows you want to keep (even copy them
to a new sheet???)
I'd also convert that formula column to values (copy|pastespecial|values). Just
to make filtering a bit quicker.
> I have several files wi...The DoMenu command was stopped?
I have used the wizard to put a delete record button on my form..
When the button is clicked it says.... Do you want to delete this record etc
It gived to options yes and no. Yes just deletes it and all done, if you
click no then I get an error message of "the domenu" command was stopped.
Does anyone know how to get rid of this?
Message posted via AccessMonster.com
In the code generated by the wizard, put an apostrophe in front of the line
MsgBox Err.Description. However, this will stop other er...