Below is a script which is a slight rehash of work appearing in the Rob Van Der Woude stable. See http://www.robvanderwoude.com/datet... where all due credits appear.The script is untested and depends upon your Date format being dd/mm/yyyy@echo off cls setlocal enabledelayedexpansion FOR %%a in (c:\Read more
Below is a script which is a slight rehash of work appearing in the Rob Van Der Woude stable. See http://www.robvanderwoude.com/datet… where all due credits appear.
The script is untested and depends upon your Date format being dd/mm/yyyy
@echo off
cls
setlocal enabledelayedexpansion
FOR %%a in (c:\DB\inventory.txt) DO SET filedate=%%~ta
set yy=%filedate:~7,4%
set mm=%filedate:~4,2%
set dd=%filedate:~0,2%
IF %mm% lss 10 SET mm=%mm:~1%
IF %dd% lss 10 SET dd=%dd:~1%
SET /A mm1 = ( %mm% - 14 ) / 12
SET /A yy1 = %yy% + 4800
SET /A juldate = 1461 * ( %yy1% + %mm1% ) / 4 + 367 * ( %mm% - 2 -12 * %mm1% ) / 12 - ( 3 * ( ( %yy1% + %mm1% + 100 ) / 100 ) ) / 4 + %dd% - 32075
SET weekday.0=Monday
SET weekday.1=Tuesday
SET weekday.2=Wednesday
SET weekday.3=Thursday
SET weekday.4=Friday
SET weekday.5=Saturday
SET weekday.6=Sunday
SET /A wd = %juldate% %% 7
SET weekday=!weekday.%wd%!
msg * File last modified on %weekday%, %fileDate:~0,10%
This code will build the Sheet Name by using the date stored in the cell.BTW...you don't have to Select the ActiveSheet, it's already "selected" since it's Active.In addition, you rarely have to Select an object to perform a VBA Action on it.ActiveSheet.Name = "My Sheet Name"orSheets(1).Name = "My SRead more
This code will build the Sheet Name by using the date stored in the cell.
BTW…you don’t have to Select the ActiveSheet, it’s already “selected” since it’s Active.
In addition, you rarely have to Select an object to perform a VBA Action on it.
ActiveSheet.Name = “My Sheet Name”
or
Sheets(1).Name = “My Sheet Name”
is more efficient.
The same goes for cell ranges, text boxes, whatever.
"But when I install it, the PC does not start and Mobo starts beeping continuously"The beeping is an indication that the RAM isn't fully seated in the slots. Make sure it locks in on both ends.And if you have no plans to overclock the CPU, you should be running the RAM as DDR3-1066 @ 533MHz frequencRead more
“But when I install it, the PC does not start and Mobo starts beeping continuously“
The beeping is an indication that the RAM isn’t fully seated in the slots. Make sure it locks in on both ends.
And if you have no plans to overclock the CPU, you should be running the RAM as DDR3-1066 @ 533MHz frequency. Running DDR3-1333 @ 667MHz without overclocking the CPU to 333MHz frequency will throw off the ideal CPU:DRAM frequency ratio of 1:2. Instead, it will be 2:5 & you’ll take a performance hit.
"both tower and monitor new"As Nigel pointed out, Venom AVP VE10 is the name of the tower/case. We need to know the specs of the hardware inside the tower. Who built the computer? Did it ever work properly? http://www.eclipsecomputers.com/pro..."the tower seems to be coming on and firing up OK so thRead more
“both tower and monitor new”
As Nigel pointed out, Venom AVP VE10 is the name of the tower/case. We need to know the specs of the hardware inside the tower. Who built the computer? Did it ever work properly?
If everything is working properly, yes, it should spin up as soon as power is applied. Make sure you have any jumpers set correctly. Most require the drive seat as Master
If everything is working properly, yes, it should spin up as soon as power is applied.
Make sure you have any jumpers set correctly. Most require the drive seat as Master
Read the manual or go here to download a manual if you don't have one. There are 2 listed - http://us.gateway.com/gw/en/US/cont...message edited by Pappy
Here's one way to transfer files without guest additions. It works with Virtualbox, and QEMU images. I learned this by searching on the internet.First, make sure the guest VM that you want to copy files from isn't running.You will also have to have a driver for NTFS filesystem in your case.If you haRead more
Here’s one way to transfer files without guest additions. It works with Virtualbox, and QEMU images. I learned this by searching on the internet. First, make sure the guest VM that you want to copy files from isn’t running. You will also have to have a driver for NTFS filesystem in your case. If you have QEMU-utils installed, you can use:
sudo qemu-nbd -c /dev/nbd0 <path to your VBox hdimage.vdi> #binds your hdimage to network block device, which can then be mounted as a normal filesystem.
and lastly…
sudo mount /dev/nbd0p1 /mnt #or wherever you’d like to mount it.
When you’re done transferring files you’ll need to unmount the filesystem and…
sudo qemu-nbd -d /dev/nbd0 #unbind hdimage from network block device.
That’s it. I’ve used it several times, and it works very well.
Is the LCD surface clean? Get another LCD or CRT monitor attached to your system to test the video quality on that monitor - then compare it to your Dell LCD. If it's new, take it back. Make sure you scream at the Dell ppl too, they like that.
Is the LCD surface clean?
Get another LCD or CRT monitor attached to your system to test the video quality on that monitor – then compare it to your Dell LCD.
If it’s new, take it back. Make sure you scream at the Dell ppl too, they like that.
In that case I think this drive is faulty. How that happens? Who knows but the most common cause is the failure to use the Safety Remove Hardware routine before pulling out the device, Below is a list of LED behaviors which are all NORMAL (courtesy of ScanDisk).1. LED is a solid light and blinks onlRead more
In that case I think this drive is faulty. How that happens? Who knows but the most common cause is the failure to use the Safety Remove Hardware routine before pulling out the device,
Below is a list of LED behaviors which are all NORMAL (courtesy of ScanDisk). 1. LED is a solid light and blinks only when transferring files to the device. 2. LED blinks rapidly during initialization then turns off. LED then only blinks when data is being transferred. 3. LED breaths (slowly fades in and out) when device is not being used and blinks rapidly when data is being transferred.
A drive with no LED activity, or red LED or solid or constantly blinking LED can be cosidered faulty or corrupted (remember this is just MY BEST OPINION and I am not the authority on this thing 🙂
a SMART event error would suggest that your drive is not functioning to be potential, in other words it is failing. i would recommend that you back all your data up and change the drive. however if you have warrenty on your Dell then you can have them do this for you.
a SMART event error would suggest that your drive is not functioning to be potential, in other words it is failing.
i would recommend that you back all your data up and change the drive.
however if you have warrenty on your Dell then you can have them do this for you.
Extract Day Of The Week In a Dos Batch File
Below is a script which is a slight rehash of work appearing in the Rob Van Der Woude stable. See http://www.robvanderwoude.com/datet... where all due credits appear.The script is untested and depends upon your Date format being dd/mm/yyyy@echo off cls setlocal enabledelayedexpansion FOR %%a in (c:\Read more
The script is untested and depends upon your Date format being dd/mm/yyyy
@echo off cls setlocal enabledelayedexpansion FOR %%a in (c:\DB\inventory.txt) DO SET filedate=%%~ta set yy=%filedate:~7,4% set mm=%filedate:~4,2% set dd=%filedate:~0,2% IF %mm% lss 10 SET mm=%mm:~1% IF %dd% lss 10 SET dd=%dd:~1% SET /A mm1 = ( %mm% - 14 ) / 12 SET /A yy1 = %yy% + 4800 SET /A juldate = 1461 * ( %yy1% + %mm1% ) / 4 + 367 * ( %mm% - 2 -12 * %mm1% ) / 12 - ( 3 * ( ( %yy1% + %mm1% + 100 ) / 100 ) ) / 4 + %dd% - 32075 SET weekday.0=Monday SET weekday.1=Tuesday SET weekday.2=Wednesday SET weekday.3=Thursday SET weekday.4=Friday SET weekday.5=Saturday SET weekday.6=Sunday SET /A wd = %juldate% %% 7 SET weekday=!weekday.%wd%! msg * File last modified on %weekday%, %fileDate:~0,10%Renaming Sheet Tab With a Date From Cell
This code will build the Sheet Name by using the date stored in the cell.BTW...you don't have to Select the ActiveSheet, it's already "selected" since it's Active.In addition, you rarely have to Select an object to perform a VBA Action on it.ActiveSheet.Name = "My Sheet Name"orSheets(1).Name = "My SRead more
BTW…you don’t have to Select the ActiveSheet, it’s already “selected” since it’s Active.
In addition, you rarely have to Select an object to perform a VBA Action on it.
ActiveSheet.Name = “My Sheet Name”
or
Sheets(1).Name = “My Sheet Name”
is more efficient.
The same goes for cell ranges, text boxes, whatever.
Instead of:
Range(“A1:A100”).Select
Selection.Interior.ColorIndex = 3
use
Range(“A1:A100”).Interior.ColorIndex = 3
Option Explicit Sub NameDateSheet() Dim myShtName myShtName = Month(Range("A47")) _ & "-" & Day(Range("A47")) _ & "-" & Year(Range("A47")) ActiveSheet.Name = myShtName End SubHow To Make DDR3 1333 Mhz Ram Work On Gigabyte Combo Mobo?
"But when I install it, the PC does not start and Mobo starts beeping continuously"The beeping is an indication that the RAM isn't fully seated in the slots. Make sure it locks in on both ends.And if you have no plans to overclock the CPU, you should be running the RAM as DDR3-1066 @ 533MHz frequencRead more
The beeping is an indication that the RAM isn’t fully seated in the slots. Make sure it locks in on both ends.
And if you have no plans to overclock the CPU, you should be running the RAM as DDR3-1066 @ 533MHz frequency. Running DDR3-1333 @ 667MHz without overclocking the CPU to 333MHz frequency will throw off the ideal CPU:DRAM frequency ratio of 1:2. Instead, it will be 2:5 & you’ll take a performance hit.
How Come New Monitor Work With Laptop But Not Venom Desktop?
"both tower and monitor new"As Nigel pointed out, Venom AVP VE10 is the name of the tower/case. We need to know the specs of the hardware inside the tower. Who built the computer? Did it ever work properly? http://www.eclipsecomputers.com/pro..."the tower seems to be coming on and firing up OK so thRead more
As Nigel pointed out, Venom AVP VE10 is the name of the tower/case. We need to know the specs of the hardware inside the tower. Who built the computer? Did it ever work properly?
http://www.eclipsecomputers.com/pro…
“the tower seems to be coming on and firing up OK so think its working”
If you can’t get a display on the monitor, it’s obviously not working.
Hard Drive Does Not Spin Up When Power Is Applied…
If everything is working properly, yes, it should spin up as soon as power is applied. Make sure you have any jumpers set correctly. Most require the drive seat as Master
If everything is working properly, yes, it should spin up as soon as power is applied.
See lessMake sure you have any jumpers set correctly. Most require the drive seat as Master
Gateway NE56R31u Laptop External Monitor
Read the manual or go here to download a manual if you don't have one. There are 2 listed - http://us.gateway.com/gw/en/US/cont...message edited by Pappy
message edited by Pappy
Solved How To Copy Files From a Guest OS To Host OS?
Here's one way to transfer files without guest additions. It works with Virtualbox, and QEMU images. I learned this by searching on the internet.First, make sure the guest VM that you want to copy files from isn't running.You will also have to have a driver for NTFS filesystem in your case.If you haRead more
First, make sure the guest VM that you want to copy files from isn’t running.
You will also have to have a driver for NTFS filesystem in your case.
If you have QEMU-utils installed, you can use:
sudo modprobe nbd max_part=16 #this loads network block device driver into kernel
then…
sudo qemu-nbd -c /dev/nbd0 <path to your VBox hdimage.vdi> #binds your hdimage to network block device, which can then be mounted as a normal filesystem.
and lastly…
sudo mount /dev/nbd0p1 /mnt #or wherever you’d like to mount it.
When you’re done transferring files you’ll need to unmount the filesystem and…
sudo qemu-nbd -d /dev/nbd0 #unbind hdimage from network block device.
That’s it.
I’ve used it several times, and it works very well.
message edited by pbznmg18
Fixing Monitor Color Streaking
Is the LCD surface clean? Get another LCD or CRT monitor attached to your system to test the video quality on that monitor - then compare it to your Dell LCD. If it's new, take it back. Make sure you scream at the Dell ppl too, they like that.
Is the LCD surface clean?
Get another LCD or CRT monitor attached to your system to test the video quality on that monitor – then compare it to your Dell LCD.
If it’s new, take it back. Make sure you scream at the Dell ppl too, they like that.
See lessUSB Jump Drive LED Don’t Blink When Plugged In
In that case I think this drive is faulty. How that happens? Who knows but the most common cause is the failure to use the Safety Remove Hardware routine before pulling out the device, Below is a list of LED behaviors which are all NORMAL (courtesy of ScanDisk).1. LED is a solid light and blinks onlRead more
Below is a list of LED behaviors which are all NORMAL (courtesy of ScanDisk).
1. LED is a solid light and blinks only when transferring files to the device.
2. LED blinks rapidly during initialization then turns off. LED then only blinks when data is being transferred.
3. LED breaths (slowly fades in and out) when device is not being used and blinks rapidly when data is being transferred.
A drive with no LED activity, or red LED or solid or constantly blinking LED can be cosidered faulty or corrupted (remember this is just MY BEST OPINION and I am not the authority on this thing 🙂
i_Xp/Vista/W7User
Solved Solve The Smart Event Error In Dell Hard Disk
a SMART event error would suggest that your drive is not functioning to be potential, in other words it is failing. i would recommend that you back all your data up and change the drive. however if you have warrenty on your Dell then you can have them do this for you.
i would recommend that you back all your data up and change the drive.
however if you have warrenty on your Dell then you can have them do this for you.