How can I disable connectivity to a windows server for 60 seconds? In linux this is done with: ifconfig eth0 down ; sleep 60 ; ifconfig eth0 up
How can I disable connectivity to a windows server for 60 seconds?
In linux this is done with: ifconfig eth0 down ; sleep 60 ; ifconfig eth0
On 09/04/2010 02:23, DR wrote:
> How can I disable connectivity to a windows server for 60 seconds?
> In linux this is done with: ifconfig eth0 down ; sleep 60 ; ifconfig
> eth0 up
set interface name="Local Area Connection" admin=DISABLED
set interface name="Local Area Connection" admin=ENABLED
As for the 60-second pause in between, as far as I know there's no sleep
command ...How to stop excel replaceing numbers with the date?
One way is to precede the entry with an apostrophe (').
If it is fractions, try preceding with 0 and then a space before the
"Jamescowles" <Jamescowles@discussions.microsoft.com> wrote in message
Hi all, im having trouble with my assignment, and wondering if anyon
here could help me out..Heres the assignment question-
"If OCCUPANCY is grater than 71% it is considered to be high. In th
RESERVATION section use a function to calculate whether the OCCUPANC
for MON is high. If the BOOKINGS for MON are grater than the result o
the named cell ROOMS (B8) multiplied by 71% then HIGH should b
displayed in the cell, otherwise it should be left empty. Replicat
this formula for the other cells"
I think i need an "IF" statment. But i dont know how to create th
formula- Heres a...Help with Links
I want to link cells of number of worksheet with a single worksheet which
will be the summary of all the worksheet.
Right now I am linking the sheets with one cell at a time .
Is there a simple way to link all sheets at one go?
Kindly guide me in the matter.
Perhaps this will help:
"newbie" <email@example.com> wrote in message
> I want to link cells of number of worksh...Help with writing a macro to create a list
I've been trying to create a macro for a while but I'm not having much
success. Hopefully you guys can help!
I have a list of all the orders placed for our product on one tab called
"Orders", with a customer number in column B.
On a second tab "Clients", you'll be amazed to find out that I have a list
of clients (customer number in column B also).
I want to write a macro which will create a list containing information on
which customers havent ordered anything yet. This list should be on a tab
called "Order missing".
Basically, I...Disable Microsoft Office File Validation
As per http://support.microsoft.com/kb/2501584
"Known issues with Office File Validation
* Files that were created in Microsoft Excel 2.0, Microsoft Excel
3.0, or Microsoft Excel 4.0 will fail validation when you use Office
File Validation in Office 2003.
* Solver.xla will fail validation when you use Office File
Validation in Office 2003.
* When you paste lots of charts or points of data into an Office
2003 document, the paste function may take a long time to complete
while Office File Validation tries to validate the new data.
* Opening files from a network share that ...Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
California Los Angeles San Diego
Any help is greatly appreci...Global Replace
Is there a quick way to change/add a category to a group of Contact records
based on Contact field?
i want to add a category to a group of records based on User Field 2. Can
anyone tell me how to do this?
Many thanks in advance.
Sort by Category and then drag and drop the items in the Category to add
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Properly back-up and restore your Outlook data
-Creating a Permanent New Mail Desktop Alert in Outlook 2003
"rayswchiu" <firstname.lastname@example.org> wrote in messa...Re-install Outlook 2002
I am trying to re-install Outlook 2002 for my palm pilot
after a crash. The installation will run until I get the
message - "another version is already installed and must
be uninstalled". The previous version was corrupt and I
was unable to uninstall it. Now when I go into the control
panel to add/remove the uninstall is no longer in the
...Disable OMA per default
with the parameter msExchOmaAdminWirelessEnable = 7 the OMA parameters for
useres could be disable but every new generated user is OMA enabled. How
could I disable OMA per default on every new generated Exchange user.
I was going to suggest using a template user account within ADUC to create
new users (with OMA disabled on the template account, obviously). But that
doesn't appear to work.
I guess if you create a script to create new user accounts, use the value
you mention below in the script. That's all I can think of right now.
Exchange...Re-Enable CRM User
I am trying to enable a disabled CRM user and I received the following error
message. Any thoughts or suggestions would be greatly appreciated.
String UserId) +0
Microsoft.Crm.Application.Platform.SystemUser.Activate(String id) +38
sender, DataEventArgs e) +127
eventId, FormState state, User user, String objectId,...Formula help required
I have 3 conditions
score divided into 3 parts 50, 75 and 100 %
If score in cell = > 27 then -3
If score in cell = >26<36 = -2
If score in cell = >18<27 = -1
If score in cell is > 27 shows false
Your conditions are a bit ambigous, shouldn't the first criteria be >=37 ?
Conditions for the formula below:
F48 >=37 result -3
F48 between 26 and 36 result -2
F48 between 18 and 25 result -...Help settiing up Out of Office reply in outlook 2K7
When I try to set up Out of Office response in Outlook2K7 I get a screen
that is different from the Out Of Office dialog box that has option for "I
am in the office", and "I am out of the office"
You also get a box to put you auto reply message in.
This is not the screen that I see in the Office help to set up Out of Office
Could someone assit me in setting the auto reply up?
The settings I put in so far do not generate an auto reply when I test mail
Thanks for any ideas
> When I try to set up Out of Office response in Outlook2K...Publisher Help
I made a webpage with publisher,I uploaded to godaddy then decided to make
some changes but now when i do File and Webpage preview and click on the tabs
the links are dead here is the url i get when i click the tab ( about us ,
C:\Documents and Settings\user\Temporary Internet
how do i get this to its orginal self that
Like it used to be
C:\Documents and Settings\pinto\Temporary Internet
or have the Tab links active agian...RE:Excel will not open from a web link
When opening a link on a web page that has an Excel
Spreadsheet embedded in it, the spreadsheet will not open
up Excel but opens within another browser as an Excel
file. Programming on webpage is correct, opens up on
other machines just fine.
...If Function help #2
I have what should be a simple IF then formula, which is copied below,
where both criteria must be met: Z9 must be true and S9 must = COS.
Any assistance why this isn't working would be greatly appreciated.
What is contained in Z9?
Maybe you need
<email@example.com> wrote in message
>I have what should be a simple IF then formula, which is copied below,
> where b...Re: exmerge error
I am getting the following error when trying to use exmerg
can anyone please help
Microsoft Exchange Mailbox Merge Program, v4.00.02
Start Logging:February 27, 2004 20:04:3
[20:04:31] Logging Level: Non
[20:04:31] Reading settings from file 'C:\Program Files\Exchsrvr\BIN\EXMERGE.INI'
[20:04:32] Error 8007203a opening an LDAP connection. ('LDAP://EXCHANGE/rootDSE') (CADRoutines::GetNamingContextData
[20:04:32] Accessing Domain Controller 'PROFI...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...query help plz
hey i have been given a set of data which i have set my relationships and
everything is going well,but (now this is when it gets tricky) i have been
given two name fields one for forename and one for lastname,but i havebeen
asked to display the members first intial,but havent been given seperate data
for it (its too go on a labels in reports)how would i go about searching for
jus the first letter of theri first name ? for loadz of entries??? cheers
Use the Left function in the query. It would look something like this in the
Jerry Whittle...is it possible to Restrict Find & Replace to 1 column
I need to Find and Replace values in a Column
Same data also exists in other columns - so I would like to restrict the
Find and Replace to
a specified column
I need to do this in a Macro ie. popup a text box
Just select the column before doing the F&R.
In article <e8o0hdwYFHA.3712@TK2MSFTNGP09.phx.gbl>,
"Simon" <Simon@microsoftforums.com> wrote:
> I need to Find and Replace values in a Column
> Same data also exists in other columns - so I would like to restrict the
> Find and Replace to
> a specified column
> I need to do this in a ...Ron Bovey re: "Trim Selection" in ExcelUtilities
Cells in my Excel spreadsheet appear to be empty. However, when I use
Edit/Go To/Special/Blanks, I get "No cells were found".
In the past, Ron Bovey suggested going to the WWW.APPROS.COM website,
download ExcelUtilities and then use the "Trim Selection" utility to
remove the characters that are making the cells not empty.
Since then, I've gone to the WWW.APPROS.COM website and downloaded the
ASAP Utilities. However, I can seem to find the "Trim Selection" nor
any utility that will do the same thing.
Try going to Rob (not Ron) Bovey's site:
...money replacement 03-26-10
OK, so I've learned that Microsoft no longer offers a "Money" product. Can
anyone recommend a comparable replacement for my stand-alone MS Money 2007
software? Office Accounting Express looks powerful but I thing it is too
complicated for my personal finance needs. What about an online offering
(though I'm not really keen on the idea).
Thanks for any suggestions.
In microsoft.public.money, Domenick wrote:
>OK, so I've learned that Microsoft no longer offers a "Money" product. Can
>anyone recommend a comparable replacement for my stand-alo...HELP... Macro challenge (not coding)
I'm working on a big project file for our whole department to use. I set up
a macro that will make some steps easier for my teammates. But then i just
realized (when i was testing something on one of their machines) that the
macro is tied to the software on my machine, not on the Project file itself.
Is there a way to associate the macro to the file show it shows up on any
department computer? I've looked through a couple of books and can't find
anything. The thought of rebuilding the macro on everyone's machine makes me
a bit nauseous.
In ...disable cell #2
I'm sure this is possible but I can't figure it out. How can I disable a
cell based on input in another cell. Example:
If an "X" is placed in A3, I want A4 disabled (locked).
not completely save but
- select cell A4
- goto 'Data - Validation -. custom
- enter the formula
Note: This does not prevent copying data to this cell. If you need more
security you have to use VBA (an event procedure)
> I'm sure this...Transfer Spreadsheet method Not replacing Sheet Name
I have this line of code which Transfers one record of a query and make
a Worksheet named A_EXPORT. This worked fine until I started havin
some linked references in the workbook to this newly created shee
Now instead of replacing the sheet every time I transfer data fro
Access to Excel it is adding a sheet named A_EXPORT1 etc
How can I get this to replace the sheet or can I copy the recordset t
row 2 of A_EXPORT instead?
DoCmd.TransferSpreadsheet acExport, 8, "A_EXPORT", str, True, ""
Message posted from http://ww...