quick and messy solution maybe@echo offreg QUERY HKEY_CLASSES_ROOT\http\shell\open\command /ve>info.txtTYPE info.txt |FindStr /R "Internet Explorer">NULIf %ERRORLEVEL% EQU 0 echo Default Browser is Internet ExplorerTYPE info.txt |FindStr /R "Chrome">NULIf %ERRORLEVEL% EQU 0 echo Default BroRead more
quick and messy solution maybe
@echo off reg QUERY HKEY_CLASSES_ROOT\http\shell\open\command /ve>info.txt TYPE info.txt |FindStr /R “Internet Explorer”>NUL If %ERRORLEVEL% EQU 0 echo Default Browser is Internet Explorer TYPE info.txt |FindStr /R “Chrome”>NUL If %ERRORLEVEL% EQU 0 echo Default Browser is Google Chrome
Regrettably, I don't know how your script is doing this. if you want to post your script, or the part that is related, there might be an easier answer. batch would be something like count=count+1 && echo %count%
Regrettably, I don’t know how your script is doing this. if you want to post your script, or the part that is related, there might be an easier answer.
batch would be something like
count=count+1 && echo %count%
"Use Open Office" Or LibreOffice, both are free. Looks like you're using a 10 yr old version of Word. http://www.libreoffice.org/ http://www.openoffice.org/
“Use Open Office”
Or LibreOffice, both are free. Looks like you’re using a 10 yr old version of Word.
8.26 x 11.69 is the size of A4 paper, most commonly used in Europe and Asia. I live in the US and used to be a member of a global team. I used to hate getting documents formatted for A4 paper. It screwed us up here in the US. Try setting the paper size in Nuance to Letter if possible.
8.26 x 11.69 is the size of A4 paper, most commonly used in Europe and Asia.
I live in the US and used to be a member of a global team. I used to hate getting documents formatted for A4 paper. It screwed us up here in the US.
Try setting the paper size in Nuance to Letter if possible.
Not sure this will help, using Excel 2000, on XP. If I open the first instance of Excel I will have only one process running, now if I open a second workbook from within this first Excel workbook, I will still have only one process running. Regardless of how many workbooks I open from within the firRead more
Not sure this will help, using Excel 2000, on XP.
If I open the first instance of Excel I will have only one process running, now if I open a second workbook from within this first Excel workbook, I will still have only one process running. Regardless of how many workbooks I open from within the first instance, I get only one process.
The only way I can get another Excel process to run, is if I then go to the START > Programs > Microsoft Office > Excel and explicitly start another instance.
Having both 2003 & 2007 running at the same time, would probably cause two separate process to run.
Someplace along the line I would guess that a registry entry got flummoxed.
Try running a Detect & Repair, and see if that help.
Use a "Helper Column".Pick an unused column to calculate each win/loss record as a percentage and then use the RANK function in Column G to rank the percentages.If there will be ties, there are workarounds. Do a Google search on breaking ties when using the RANK function. You'll have many options toRead more
Use a “Helper Column”.
Pick an unused column to calculate each win/loss record as a percentage and then use the RANK function in Column G to rank the percentages.
If there will be ties, there are workarounds. Do a Google search on breaking ties when using the RANK function. You’ll have many options to choose from.
You can hide the Helper Column if you wish.
You can also perform the percentage calculation within the RANK function and not use a Helper Column. Your choice.
This code should work, but I suggest you try it in a backup copy of your file in case things go terribly wrong. Obviously I can only test it in a workbook that I think looks like yours since I can't see your workbook from where I'm sitting.Note: if you read this How To, you'll find some troubleshootRead more
This code should work, but I suggest you try it in a backup copy of your file in case things go terribly wrong. Obviously I can only test it in a workbook that I think looks like yours since I can’t see your workbook from where I’m sitting.
Note: if you read this How To, you’ll find some troubleshooting tips that might help you determine what is or isn’t working with the code.
If it doesn’t do what you want, please post an example of your data, after clicking on the blue line at the end of this post and reading the instructions found via that link.
Sub DeleteRows()
'Determine Last Row with data in Column A
lastRw = Range("A" & Rows.Count).End(xlUp).Row
'Loop through Rows in reverse order
For nxtRw = lastRw To 1 Step -1
'If cell contains RUN DATE, save the Row number from the cell above
If Range("A" & nxtRw) Like "*RUN DATE*" Then _
runRw = Range("A" & nxtRw).Row - 1
'If cell contains END OF CSA, save the Row number from the cell below
'and use the Row number variables to delete the Rows between the
'2 text values
If Range("A" & nxtRw) Like "*END OF CSA*" Then
csaRw = Range("A" & nxtRw).Row + 1
Rows(runRw & ":" & csaRw).Delete shift:=xlUp
End If
Next
End Sub
re: "the minutes part of the equation needs to be from 60 to 100 minutes"First, I have never known a "military hour" to have 100 minutes. It has 60 minutes just like any other hour, but is often expressed as a decimal portion of an hour. e.g. 15 minute = .25 of an hour. I don't think I have ever seeRead more
re: “the minutes part of the equation needs to be from 60 to 100 minutes”
First, I have never known a “military hour” to have 100 minutes. It has 60 minutes just like any other hour, but is often expressed as a decimal portion of an hour. e.g. 15 minute = .25 of an hour.
I don’t think I have ever seen military time expressed as 7:86:05. 7.86, Yes, but 7:86, No, at least not in my experience. I think that that format would be very confusing.
If I saw 15:25 (in 24 hour time format) or 1525 (in my experience with military time) I would say that it is 25 minutes after 3 PM, not 15 minutes after 3 PM. Any value that is less than 60 and used in the minutes or seconds portion of the value could be taken 2 different ways.
As far as the math part of your question, this might help.
In Excel, if you multiply a time by 24 and format the cell as a number, you will get the decimal equivalent, but it will not contain the colons. e.g.
Is your router a couple years old? Is your blueray connecting to said router via a wired or wireless?In my experience, SOHO routers can have what I call a "brain fart" and just stop functioning properly. Typically in these cases, recycling the power fixes the issue. Over time, the unit will "stuff uRead more
Is your router a couple years old? Is your blueray connecting to said router via a wired or wireless?
In my experience, SOHO routers can have what I call a “brain fart” and just stop functioning properly. Typically in these cases, recycling the power fixes the issue. Over time, the unit will “stuff up” more and more frequently until it bricks permanently.
Usually this happens with the wireless side of things before it’ll ever happen with the wired. I have a SOHO router that’s about 10 years old and the wireless on it died on me some years back so I disabled it completely and plugged an really good wireless access point into the router. The wired side of things is still working perfectly but as I said, the wireless radio died.
Remember, you’re dealing with SOHO level equipment here and manufacturer’s don’t put the same effort into it as they do enterprise level equipment so it won’t perform as well, or have as long a life.
Also, plugging the ethernet in before powering it up won’t make any difference. The switch ports (be they LAN or the WAN port) are pretty much the last thing to enable after recycling the power. When my older unit’s wireless starting to die, I just pulled the power plug, waited 10 seconds, then plugged it back in to do a quick reset. Unplugging the ethernet cables was/is a waste of time and changes nothing with regard to how the router boots up.
It matters not how straight the gate, How charged with punishments the scroll, I am the master of my fate; I am the captain of my soul.
Copy Specific Line Using Batch File
@echo off > newfile & setLocal enableDELAYedeXpansion for /f "tokens=* delims= " %%a in ('dir/b *.txt') do ( find "domain" > newfile )
@echo off > newfile & setLocal enableDELAYedeXpansion
See lessfor /f “tokens=* delims= ” %%a in (‘dir/b *.txt’) do (
find “domain” > newfile
)
Check Default Internet Browser With Batch File?
quick and messy solution maybe@echo offreg QUERY HKEY_CLASSES_ROOT\http\shell\open\command /ve>info.txtTYPE info.txt |FindStr /R "Internet Explorer">NULIf %ERRORLEVEL% EQU 0 echo Default Browser is Internet ExplorerTYPE info.txt |FindStr /R "Chrome">NULIf %ERRORLEVEL% EQU 0 echo Default BroRead more
@echo off
reg QUERY HKEY_CLASSES_ROOT\http\shell\open\command /ve>info.txt
TYPE info.txt |FindStr /R “Internet Explorer”>NUL
If %ERRORLEVEL% EQU 0 echo Default Browser is Internet Explorer
TYPE info.txt |FindStr /R “Chrome”>NUL
If %ERRORLEVEL% EQU 0 echo Default Browser is Google Chrome
Im sure there is a less lazy way. 🙂
::mike
message edited by mikelinus
Batch File To Count Deleted Files
Regrettably, I don't know how your script is doing this. if you want to post your script, or the part that is related, there might be an easier answer. batch would be something like count=count+1 && echo %count%
Regrettably, I don’t know how your script is doing this. if you want to post your script, or the part that is related, there might be an easier answer.
See lessbatch would be something like
count=count+1 && echo %count%
Word Suddenly Changed Its Format, How To Fix
"Use Open Office" Or LibreOffice, both are free. Looks like you're using a 10 yr old version of Word. http://www.libreoffice.org/ http://www.openoffice.org/
“Use Open Office”
Or LibreOffice, both are free. Looks like you’re using a 10 yr old version of Word.
http://www.libreoffice.org/
http://www.openoffice.org/
See lessNuance Pdf Converter Question
8.26 x 11.69 is the size of A4 paper, most commonly used in Europe and Asia. I live in the US and used to be a member of a global team. I used to hate getting documents formatted for A4 paper. It screwed us up here in the US. Try setting the paper size in Nuance to Letter if possible.
8.26 x 11.69 is the size of A4 paper, most commonly used in Europe and Asia.
I live in the US and used to be a member of a global team. I used to hate getting documents formatted for A4 paper. It screwed us up here in the US.
Try setting the paper size in Nuance to Letter if possible.
See lessMultiple Excel Processes
Not sure this will help, using Excel 2000, on XP. If I open the first instance of Excel I will have only one process running, now if I open a second workbook from within this first Excel workbook, I will still have only one process running. Regardless of how many workbooks I open from within the firRead more
Not sure this will help, using Excel 2000, on XP.
If I open the first instance of Excel I will have only one process running, now if I open a second workbook from within this first Excel workbook, I will still have only one process running. Regardless of how many workbooks I open from within the first instance, I get only one process.
The only way I can get another Excel process to run, is if I then go to the START > Programs > Microsoft Office > Excel and explicitly start another instance.
Having both 2003 & 2007 running at the same time, would probably cause two separate process to run.
Someplace along the line I would guess that a registry entry got flummoxed.
Try running a Detect & Repair, and see if that help.
MIKE
http://www.skeptic.com/
See lessHow To Have Excel Rank Teams Based On Win/Loss Record
Use a "Helper Column".Pick an unused column to calculate each win/loss record as a percentage and then use the RANK function in Column G to rank the percentages.If there will be ties, there are workarounds. Do a Google search on breaking ties when using the RANK function. You'll have many options toRead more
Pick an unused column to calculate each win/loss record as a percentage and then use the RANK function in Column G to rank the percentages.
If there will be ties, there are workarounds. Do a Google search on breaking ties when using the RANK function. You’ll have many options to choose from.
You can hide the Helper Column if you wish.
You can also perform the percentage calculation within the RANK function and not use a Helper Column. Your choice.
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
message edited by DerbyDad03
Delete Rows Between Two Lines Using A Macro
This code should work, but I suggest you try it in a backup copy of your file in case things go terribly wrong. Obviously I can only test it in a workbook that I think looks like yours since I can't see your workbook from where I'm sitting.Note: if you read this How To, you'll find some troubleshootRead more
Note: if you read this How To, you’ll find some troubleshooting tips that might help you determine what is or isn’t working with the code.
http://www.computing.net/howtos/sho…
If it doesn’t do what you want, please post an example of your data, after clicking on the blue line at the end of this post and reading the instructions found via that link.
Sub DeleteRows() 'Determine Last Row with data in Column A lastRw = Range("A" & Rows.Count).End(xlUp).Row 'Loop through Rows in reverse order For nxtRw = lastRw To 1 Step -1 'If cell contains RUN DATE, save the Row number from the cell above If Range("A" & nxtRw) Like "*RUN DATE*" Then _ runRw = Range("A" & nxtRw).Row - 1 'If cell contains END OF CSA, save the Row number from the cell below 'and use the Row number variables to delete the Rows between the '2 text values If Range("A" & nxtRw) Like "*END OF CSA*" Then csaRw = Range("A" & nxtRw).Row + 1 Rows(runRw & ":" & csaRw).Delete shift:=xlUp End If Next End SubClick Here Before Posting Data or VBA Code —> How To Post Data or Code.
Converting Time To Military Minute
re: "the minutes part of the equation needs to be from 60 to 100 minutes"First, I have never known a "military hour" to have 100 minutes. It has 60 minutes just like any other hour, but is often expressed as a decimal portion of an hour. e.g. 15 minute = .25 of an hour. I don't think I have ever seeRead more
First, I have never known a “military hour” to have 100 minutes. It has 60 minutes just like any other hour, but is often expressed as a decimal portion of an hour. e.g. 15 minute = .25 of an hour.
I don’t think I have ever seen military time expressed as 7:86:05. 7.86, Yes, but 7:86, No, at least not in my experience. I think that that format would be very confusing.
If I saw 15:25 (in 24 hour time format) or 1525 (in my experience with military time) I would say that it is 25 minutes after 3 PM, not 15 minutes after 3 PM. Any value that is less than 60 and used in the minutes or seconds portion of the value could be taken 2 different ways.
As far as the math part of your question, this might help.
In Excel, if you multiply a time by 24 and format the cell as a number, you will get the decimal equivalent, but it will not contain the colons. e.g.
7:52:02 * 24 = 7.8675
15:12:11 * 24 = 15.2030555555556
You can then do your math with the decimal values and get:
7.33555555555556
If you wanted to, I guess you could then convert that to a “colon delimited” string, but I wouldn’t.
You might want to see if there is anything here that might help:
http://www.cpearson.com/excel/datet…
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
My Blu-Ray Is Say, System Time Updating. Try Again Later
Is your router a couple years old? Is your blueray connecting to said router via a wired or wireless?In my experience, SOHO routers can have what I call a "brain fart" and just stop functioning properly. Typically in these cases, recycling the power fixes the issue. Over time, the unit will "stuff uRead more
In my experience, SOHO routers can have what I call a “brain fart” and just stop functioning properly. Typically in these cases, recycling the power fixes the issue. Over time, the unit will “stuff up” more and more frequently until it bricks permanently.
Usually this happens with the wireless side of things before it’ll ever happen with the wired. I have a SOHO router that’s about 10 years old and the wireless on it died on me some years back so I disabled it completely and plugged an really good wireless access point into the router. The wired side of things is still working perfectly but as I said, the wireless radio died.
Remember, you’re dealing with SOHO level equipment here and manufacturer’s don’t put the same effort into it as they do enterprise level equipment so it won’t perform as well, or have as long a life.
Also, plugging the ethernet in before powering it up won’t make any difference. The switch ports (be they LAN or the WAN port) are pretty much the last thing to enable after recycling the power. When my older unit’s wireless starting to die, I just pulled the power plug, waited 10 seconds, then plugged it back in to do a quick reset. Unplugging the ethernet cables was/is a waste of time and changes nothing with regard to how the router boots up.
It matters not how straight the gate,
How charged with punishments the scroll,
I am the master of my fate;
I am the captain of my soul.
***William Henley***