"Frankly that wouldnt surprise me. Everybody is all out to make money on every single little change to format/software/electronics/ Im sure its easy to overlook something like this and /or package it wrong"Being a business, all they are doing is trying to survive & responding to customer demand,Read more
“Frankly that wouldnt surprise me. Everybody is all out to make money on every single little change to format/software/electronics/ Im sure its easy to overlook something like this and /or package it wrong” Being a business, all they are doing is trying to survive & responding to customer demand, mainly price.
hey, thanks! that saved us BOTH a lot of time and frustration. see response #1: I re-posted it with all corrections made (rather than waste space posting again here...) You prob'ly noticed blank lines are not re-iterated... I also learned a strange and confusing attribute of IF statements, which i cRead more
hey, thanks! that saved us BOTH a lot of time and frustration.
see response #1: I re-posted it with all corrections made (rather than waste space posting again here…)
You prob’ly noticed blank lines are not re-iterated…
I also learned a strange and confusing attribute of IF statements, which i consider to be a true “bug”.
Usually, you can substitute [], @, or any other non-special
char. to enclose a string, but not in a called subroutine. Then you HAVE to use dbl quotes.
the following will NOT work:
for /L %%a in (1 1 3) do (
set xx=”testing”
:: this works here
if [%%a] equ [1] echo first loop
call :testif
)
:testif
:: but not here!
if [%xx%] neq [] echo not null
but this will work:
:testif
if “%xx%” neq “” echo not null
If any other forum-phantoms see this and know why, i would greatly appreciate some enlightenment.
There are numerous reason why it can be so... and equally how to reset it.http://h30434.www3.hp.com/t5/Deskto...and this approach/solution is the one I had in mind:https://productforums.google.com/fo...
There are numerous reason why it can be so… and equally how to reset it.
@echo off & setlocal for /f "tokens=1-3 delims=_" %%a in ('dir /b *.pdf') do echo ren "%%_%%b_%%c.pdf" "%%c_%%b_%%a.pdf" ::--- end i left the safety "on" (echo). If satisfied, just remove the "echo" from the command-string.
@echo off & setlocal
for /f “tokens=1-3 delims=_” %%a in (‘dir /b *.pdf’) do echo ren “%%_%%b_%%c.pdf” “%%c_%%b_%%a.pdf”
::— end
i left the safety “on” (echo). If satisfied, just remove the “echo” from the command-string.
What you are asking for can be done, with various levels of automation.If you place a version of the code shown below in the ThisWorkbook module of the Master workbook, it will perform the following tasks:1 - Delete the current Raw Data sheet from the Master workbook2 - Open the user Raw Data workboRead more
What you are asking for can be done, with various levels of automation.
If you place a version of the code shown below in the ThisWorkbook module of the Master workbook, it will perform the following tasks:
1 – Delete the current Raw Data sheet from the Master workbook 2 – Open the user Raw Data workbook 3 – Copy the Raw Data sheet from the user workbook to the Master workbook as the first worksheet 4 – Close the user workbook
As written, the code will do all of this automatically every time the Master workbook is opened.
If you want more control, you can eliminate the 2 DisplayAlerts lines and you will be warned before the Raw Data sheet in the Master workbook is Deleted. You can choose to have it Deleted or you can keep the original and add a copy of the User version.
If you want even more control, you can run similar code “manually” by not using it as a Workbook_Open event.
Obviously you’ll need to change the workbook names, sheet names and paths to match your environment. I’ve simply provided a generic shell so that you can see what the code could look like.
Private Sub Workbook_Open()
'Disable Alerts
Application.DisplayAlerts = False
'Delete Raw Data sheet In Raw Data Master
Sheets("Raw Data").Delete
'Open user Raw Data workbook
Workbooks.Open Filename:= _
"C:\DerbyDad03\My Documents\Raw Data User.xlsx"
'Copy user Raw Data sheet to Raw Data Master sheet
Workbooks("Raw Data User.xlsx").Sheets("Raw Data").Copy _
Before:=Workbooks("Raw Data Master.xlsm").Sheets(1)
'Close user Raw Data
Workbooks("Raw Data User.xlsx").Close
'Enable Alerts
Application.DisplayAlerts = True
End Sub
This is a shot in the dark, but there was a problem, a while back, where Skype was causing grief with Excel Copy/Paste.It was supposedly fixed.But, if you have an older version of Skype try updating everything Skype and see if that helps.If I remember correctly it was the "Click to Call" function thRead more
This is a shot in the dark, but there was a problem, a while back, where Skype was causing grief with Excel Copy/Paste.
It was supposedly fixed.
But, if you have an older version of Skype try updating everything Skype and see if that helps.
If I remember correctly it was the “Click to Call” function that was the culprit.
Hi, here in the UK, in cheapo stores (Poundshop etc.) one can buy a usb mini Vacuum Cleaner for such tasks.At that price it is a bargain, even if never used! :-)Another way, is hold the keyboard upside down (when powered OFF) and tap blocks of keys randomly while slightly changing angle held.This caRead more
Hi, here in the UK, in cheapo stores (Poundshop etc.) one can buy a usb mini Vacuum Cleaner for such tasks.
At that price it is a bargain, even if never used! 🙂
Another way, is hold the keyboard upside down (when powered OFF) and tap blocks of keys randomly while slightly changing angle held.This can dislodge fluff etc. under the keys.
Try this and see how it works:=IF(AND(W10>=DATE(2016,2,12),W10<=DATE(2016,3,20)),"528/522",IF(AND(W10>=DATE(2016,3,21),W10<=DATE(2016,6,18)),"567/565",))MIKEhttp://www.skeptic.com/
As ijack pointed out the one way to run legacy 16 bit software under a 64 bit operating system is to execute it inside a virtual machine. You need however a copy of DOS as guest system so if you want a no cost solution here the steps to follow:1) Download and install MS Virtual PC from Microsoft sitRead more
As ijack pointed out the one way to run legacy 16 bit software under a 64 bit operating system is to execute it inside a virtual machine. You need however a copy of DOS as guest system so if you want a no cost solution here the steps to follow: 1) Download and install MS Virtual PC from Microsoft site (or the open source VirtualBox). 2) Download and install FreeDOS (see FreeDOS site) the free open source DOS clone fully compatable with MS DOS and even better. 3) Install and run your legacy 16 bit application inside the virtual machine you setup.
Don’t fear, the process is easier than you think and the result is worth to try.
Batch To Ping Host If Present Proceed
set machine=192.168.1.226 ping -n 1 %machine% > nul if errorlevel 1 goto :failure goto :CONNECT :connect echo Connection to %machine% is OK! goto :CONNECT :failure echo Connection to %machine% failed... goto :EOF
set machine=192.168.1.226
See lessping -n 1 %machine% > nul
if errorlevel 1 goto :failure
goto :CONNECT
:connect
echo Connection to %machine% is OK!
goto :CONNECT
:failure
echo Connection to %machine% failed…
goto :EOF
Solved DVD Won’t Play Store Bought DUAL LAYER DVD Movies
"Frankly that wouldnt surprise me. Everybody is all out to make money on every single little change to format/software/electronics/ Im sure its easy to overlook something like this and /or package it wrong"Being a business, all they are doing is trying to survive & responding to customer demand,Read more
Being a business, all they are doing is trying to survive & responding to customer demand, mainly price.
I’m here.
http://www.timeanddate.com/worldclo…
Batch File To Find ‘N Modify Text In Ini File
hey, thanks! that saved us BOTH a lot of time and frustration. see response #1: I re-posted it with all corrections made (rather than waste space posting again here...) You prob'ly noticed blank lines are not re-iterated... I also learned a strange and confusing attribute of IF statements, which i cRead more
hey, thanks! that saved us BOTH a lot of time and frustration.
see response #1: I re-posted it with all corrections made (rather than waste space posting again here…)
You prob’ly noticed blank lines are not re-iterated…
I also learned a strange and confusing attribute of IF statements, which i consider to be a true “bug”.
Usually, you can substitute [], @, or any other non-special
char. to enclose a string, but not in a called subroutine. Then you HAVE to use dbl quotes.
the following will NOT work:
for /L %%a in (1 1 3) do (
set xx=”testing”
:: this works here
if [%%a] equ [1] echo first loop
call :testif
)
:testif
:: but not here!
if [%xx%] neq [] echo not null
but this will work:
:testif
if “%xx%” neq “” echo not null
If any other forum-phantoms see this and know why, i would greatly appreciate some enlightenment.
See lessSolved How Can I Move Laptop Screen To The Left?
There are numerous reason why it can be so... and equally how to reset it.http://h30434.www3.hp.com/t5/Deskto...and this approach/solution is the one I had in mind:https://productforums.google.com/fo...
http://h30434.www3.hp.com/t5/Deskto…
and this approach/solution is the one I had in mind:
https://productforums.google.com/fo…
Batch File Rename (Reorder Filename Parts)
@echo off & setlocal for /f "tokens=1-3 delims=_" %%a in ('dir /b *.pdf') do echo ren "%%_%%b_%%c.pdf" "%%c_%%b_%%a.pdf" ::--- end i left the safety "on" (echo). If satisfied, just remove the "echo" from the command-string.
@echo off & setlocal
See lessfor /f “tokens=1-3 delims=_” %%a in (‘dir /b *.pdf’) do echo ren “%%_%%b_%%c.pdf” “%%c_%%b_%%a.pdf”
::— end
i left the safety “on” (echo). If satisfied, just remove the “echo” from the command-string.
Replace A Worksheet With One From Another Workbook
What you are asking for can be done, with various levels of automation.If you place a version of the code shown below in the ThisWorkbook module of the Master workbook, it will perform the following tasks:1 - Delete the current Raw Data sheet from the Master workbook2 - Open the user Raw Data workboRead more
If you place a version of the code shown below in the ThisWorkbook module of the Master workbook, it will perform the following tasks:
1 – Delete the current Raw Data sheet from the Master workbook
2 – Open the user Raw Data workbook
3 – Copy the Raw Data sheet from the user workbook to the Master workbook as the first worksheet
4 – Close the user workbook
As written, the code will do all of this automatically every time the Master workbook is opened.
If you want more control, you can eliminate the 2 DisplayAlerts lines and you will be warned before the Raw Data sheet in the Master workbook is Deleted. You can choose to have it Deleted or you can keep the original and add a copy of the User version.
If you want even more control, you can run similar code “manually” by not using it as a Workbook_Open event.
Obviously you’ll need to change the workbook names, sheet names and paths to match your environment. I’ve simply provided a generic shell so that you can see what the code could look like.
Private Sub Workbook_Open() 'Disable Alerts Application.DisplayAlerts = False 'Delete Raw Data sheet In Raw Data Master Sheets("Raw Data").Delete 'Open user Raw Data workbook Workbooks.Open Filename:= _ "C:\DerbyDad03\My Documents\Raw Data User.xlsx" 'Copy user Raw Data sheet to Raw Data Master sheet Workbooks("Raw Data User.xlsx").Sheets("Raw Data").Copy _ Before:=Workbooks("Raw Data Master.xlsm").Sheets(1) 'Close user Raw Data Workbooks("Raw Data User.xlsx").Close 'Enable Alerts Application.DisplayAlerts = True End SubClick Here Before Posting Data or VBA Code —> How To Post Data or Code.
Office Clipboard Is Not Working Right
This is a shot in the dark, but there was a problem, a while back, where Skype was causing grief with Excel Copy/Paste.It was supposedly fixed.But, if you have an older version of Skype try updating everything Skype and see if that helps.If I remember correctly it was the "Click to Call" function thRead more
where Skype was causing grief with Excel Copy/Paste.
It was supposedly fixed.
But, if you have an older version of Skype try updating everything Skype and see if that helps.
If I remember correctly it was the “Click to Call” function that was the culprit.
If you Google it you should get a lot of hits.
MIKE
http://www.skeptic.com/
Solved HP Laptop Arrow Keys & Delete Button Not Working Properly
Hi, here in the UK, in cheapo stores (Poundshop etc.) one can buy a usb mini Vacuum Cleaner for such tasks.At that price it is a bargain, even if never used! :-)Another way, is hold the keyboard upside down (when powered OFF) and tap blocks of keys randomly while slightly changing angle held.This caRead more
At that price it is a bargain, even if never used! 🙂
Another way, is hold the keyboard upside down (when powered OFF) and tap blocks of keys randomly while slightly changing angle held.This can dislodge fluff etc. under the keys.
Good Luck – Keep us posted.
message edited by Mike Newcomb
Help Writing An IF Statement Using Date Ranges
Try this and see how it works:=IF(AND(W10>=DATE(2016,2,12),W10<=DATE(2016,3,20)),"528/522",IF(AND(W10>=DATE(2016,3,21),W10<=DATE(2016,6,18)),"567/565",))MIKEhttp://www.skeptic.com/
=IF(AND(W10>=DATE(2016,2,12),W10<=DATE(2016,3,20)),”528/522″,IF(AND(W10>=DATE(2016,3,21),W10<=DATE(2016,6,18)),”567/565″,))
MIKE
http://www.skeptic.com/
Foxpro On Windows 8 64 Bit
As ijack pointed out the one way to run legacy 16 bit software under a 64 bit operating system is to execute it inside a virtual machine. You need however a copy of DOS as guest system so if you want a no cost solution here the steps to follow:1) Download and install MS Virtual PC from Microsoft sitRead more
1) Download and install MS Virtual PC from Microsoft site (or the open source VirtualBox).
2) Download and install FreeDOS (see FreeDOS site) the free open source DOS clone fully compatable with MS DOS and even better.
3) Install and run your legacy 16 bit application inside the virtual machine you setup.
Don’t fear, the process is easier than you think and the result is worth to try.