It looks like regardless of results you are putting the same lblResult1.Text = intFinishName1lblResult2.Text = intFinishName2lblResult3.Text = intFinishName3If I understand your program, not being a visual Basic programmer, that means no matter what the time is the same player is first?Otherwise isRead more
It looks like regardless of results you are putting the same
You will have to use VBS or some other means to access the Excel object. Here's a very rudimentary VBS:'---------------- begin vbscript "csv2xls.VBS"Set xl = WScript.CreateObject("Excel.application")xl.Visible = TRUExl.displayalerts=False'paths must be FULLY QUALIFIED, esp. for INPUT files.set book=Read more
You will have to use VBS or some other means to access the Excel object. Here’s a very rudimentary VBS:
‘—————- begin vbscript “csv2xls.VBS” Set xl = WScript.CreateObject(“Excel.application”)
xl.Visible = TRUE xl.displayalerts=False ‘paths must be FULLY QUALIFIED, esp. for INPUT files.
set book=xl.workbooks source=wscript.arguments(0) ‘wscript.echo “trying to convert: [“+source+”]” dest=wscript.arguments(1) ‘wscript.echo “output going to: “+dest+”.xls” set f=book.open (source) f.saveas dest+”.xls”,35 xl.quit ‘====== end vbscript
example call from batch: cscript csv2xls c:\subd1\subd2\any.csv c:\converted\any
my familiarity with the excel object is “slim to none”. You might want to do more research on your own to make things work like you want. Batch not tested, vbscript tested.
@echo off:monthclsset /p month=Type the Month ^<MM^>:if %month% < 1 goto dayif %month% > 12 goto day//this will make sure your entry is 1 - 12goto month:dayclsset /p day=Type the Day ^<DD^>:if %day% < 1 goto dayif %day% > 31 goto day//this will make sure your entry is 1 - 31gRead more
@echo off :month cls set /p month=Type the Month ^<MM^>: if %month% < 1 goto day if %month% > 12 goto day //this will make sure your entry is 1 – 12 goto month
:day cls set /p day=Type the Day ^<DD^>: if %day% < 1 goto day if %day% > 31 goto day //this will make sure your entry is 1 – 31 goto year
:year cls set /p year=Type the Year ^<YYYY^>: if %year% < 1980 goto deyt3 if %year% > 2030 goto deyt3 //this will make sure your entry is 1980 – 2030 //you might want to dhange the year range goto finish
This will let you type in a number then It’ll make sure it’s within a certain range. Then it’ll move on to the next one until the finish room were It’ll display the date.
Hi BjellsSee if this will do what you need. I've changed the output slightly because I believe you had an error in where the results are archived. At the top of the macro I've specified what the outputs cells are. The "button" you press is, I'm assuming, an activex or Form control button. If not pleRead more
Hi Bjells
See if this will do what you need. I’ve changed the output slightly because I believe you had an error in where the results are archived. At the top of the macro I’ve specified what the outputs cells are. The “button” you press is, I’m assuming, an activex or Form control button. If not please let me know what you mean by “button that you press”
Here’s the Macro. Any problems let me know …
Sub Archive()
'Calculator Archive Col
'C10 C
'E10 B
'J10 D
'D14 E
'D18 A
'H27 F
'D27 G
Sheets("Calculator").Activate
LastRow = Sheets("Archive").Range("A" & Rows.Count).End(xlUp).Row + 1 'Sets the last row in the Archives
'Copies the Calculator data to the Archive
Sheets("Archive").Range("C" & LastRow) = Range("C10")
Sheets("Archive").Range("B" & LastRow) = Range("E10")
Sheets("Archive").Range("D" & LastRow) = Range("J10")
Sheets("Archive").Range("E" & LastRow) = Range("D14")
Sheets("Archive").Range("A" & LastRow) = Range("D18")
Sheets("Archive").Range("F" & LastRow) = Range("H27")
Sheets("Archive").Range("G" & LastRow) = Range("D27")
'Date and time of the archiving
Sheets("Archive").Range("H" & LastRow) = Now
'Clears out the input data in the calculator but does not touch the calculated cells in the calculator
Range("C10").ClearContents
Range("E10").ClearContents
Range("J10").ClearContents
Range("D14").ClearContents
Range("D18").ClearContents
End Sub
Thanks for the info.From the sounds of it, the issue is with the VPN setup. I highly recommend you talk to the IT people at work and explain the situation and see if they can't help you resolve it. At least, in my estimation that would be the best place to start troubleshooting this issue.It mattersRead more
Thanks for the info.
From the sounds of it, the issue is with the VPN setup. I highly recommend you talk to the IT people at work and explain the situation and see if they can’t help you resolve it. At least, in my estimation that would be the best place to start troubleshooting this issue.
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.
What are you doing again? The remote access feature is for WAN side access so you can configure the router from any where. You don't need it if you are the LAN side because you simply plug in the address of the router in a browser. You only need remote access if you are a network engineer and want tRead more
What are you doing again? The remote access feature is for WAN side access so you can configure the router from any where. You don’t need it if you are the LAN side because you simply plug in the address of the router in a browser.
You only need remote access if you are a network engineer and want to configure routers from your main office when they are in remote locations. I would turn it off because you are giving access to any on on the Web to try to hack your router unless you have a really secure password.
'CPU' is your processor (your Intel inside)Your burnt smell is more likely the motherboard than your CPU but even more likely your power supply. I see you did not list your make and model on the power supply, this makes me more suspicious of it.Open the case, let it air out for a while and see if yoRead more
‘CPU’ is your processor (your Intel inside) Your burnt smell is more likely the motherboard than your CPU but even more likely your power supply. I see you did not list your make and model on the power supply, this makes me more suspicious of it. Open the case, let it air out for a while and see if you can identify where the smell is coming from. Using a strong light, examine everything in detail (do not open the power supply), burnt, burst, browning, leaking components are the thing you are looking for, especially on the motherboard and graphics card. If the smell is clearly from the power supply, simply replace it. If any component has any visible signs as above, replace the entire board. Now is also the time to tell us if you had overclocked either the CPU or graphics card (or even the memory). While overclocking will not directly burn out the CPU in general, overvolting it definitely can so list your overclock and voltages.
You have to be a little bit crazy to keep you from going insane.
Solved How Can I Start My Windows In Normal Way?
GRUB4DOS 0.0.4 2009-10-11, Memory: 638k / 3069m, MenuEnd: 0x451EChttp://bit.ly/1TMF0Xs
http://bit.ly/1TMF0Xs
Visual Basic Race Results Program
It looks like regardless of results you are putting the same lblResult1.Text = intFinishName1lblResult2.Text = intFinishName2lblResult3.Text = intFinishName3If I understand your program, not being a visual Basic programmer, that means no matter what the time is the same player is first?Otherwise isRead more
lblResult1.Text = intFinishName1
lblResult2.Text = intFinishName2
lblResult3.Text = intFinishName3
If I understand your program, not being a visual Basic programmer, that means no matter what the time is the same player is first?
Otherwise is there another part where it fails?
::mike
Solved Need Batch File To Convert Txt File To Xls
You will have to use VBS or some other means to access the Excel object. Here's a very rudimentary VBS:'---------------- begin vbscript "csv2xls.VBS"Set xl = WScript.CreateObject("Excel.application")xl.Visible = TRUExl.displayalerts=False'paths must be FULLY QUALIFIED, esp. for INPUT files.set book=Read more
‘—————- begin vbscript “csv2xls.VBS”
Set xl = WScript.CreateObject(“Excel.application”)
xl.Visible = TRUE
xl.displayalerts=False
‘paths must be FULLY QUALIFIED, esp. for INPUT files.
set book=xl.workbooks
source=wscript.arguments(0)
‘wscript.echo “trying to convert: [“+source+”]”
dest=wscript.arguments(1)
‘wscript.echo “output going to: “+dest+”.xls”
set f=book.open (source)
f.saveas dest+”.xls”,35
xl.quit
‘====== end vbscript
example call from batch:
cscript csv2xls c:\subd1\subd2\any.csv c:\converted\any
my familiarity with the excel object is “slim to none”. You might want to do more research on your own to make things work like you want.
Batch not tested, vbscript tested.
message edited by nbrane
Inserting a Column Into a CSV File
@echo off > newfile & setLocal enableDELAYedeXpansionfor /f "tokens=* delims= " %%a in (my.csv) do (>> newfile echo.T,%%a)=====================================Helping others achieve escape felicityM2
for /f “tokens=* delims= ” %%a in (my.csv) do (
>> newfile echo.T,%%a
)
=====================================
Helping others achieve escape felicity
M2
Batch File Input Numbers Only
@echo off:monthclsset /p month=Type the Month ^<MM^>:if %month% < 1 goto dayif %month% > 12 goto day//this will make sure your entry is 1 - 12goto month:dayclsset /p day=Type the Day ^<DD^>:if %day% < 1 goto dayif %day% > 31 goto day//this will make sure your entry is 1 - 31gRead more
:month
cls
set /p month=Type the Month ^<MM^>:
if %month% < 1 goto day
if %month% > 12 goto day
//this will make sure your entry is 1 – 12
goto month
:day
cls
set /p day=Type the Day ^<DD^>:
if %day% < 1 goto day
if %day% > 31 goto day
//this will make sure your entry is 1 – 31
goto year
:year
cls
set /p year=Type the Year ^<YYYY^>:
if %year% < 1980 goto deyt3
if %year% > 2030 goto deyt3
//this will make sure your entry is 1980 – 2030
//you might want to dhange the year range
goto finish
:finish
cls
echo %month%/%day%/%year%
pause >nul
exit
This will let you type in a number then It’ll make sure it’s within a certain range. Then it’ll move on to the next one until the finish room were It’ll display the date.
Solved I Need a Macro To Copy Data To An Archive Sheet
Hi BjellsSee if this will do what you need. I've changed the output slightly because I believe you had an error in where the results are archived. At the top of the macro I've specified what the outputs cells are. The "button" you press is, I'm assuming, an activex or Form control button. If not pleRead more
See if this will do what you need. I’ve changed the output slightly because I believe you had an error in where the results are archived. At the top of the macro I’ve specified what the outputs cells are. The “button” you press is, I’m assuming, an activex or Form control button. If not please let me know what you mean by “button that you press”
Here’s the Macro. Any problems let me know …
Sub Archive() 'Calculator Archive Col 'C10 C 'E10 B 'J10 D 'D14 E 'D18 A 'H27 F 'D27 G Sheets("Calculator").Activate LastRow = Sheets("Archive").Range("A" & Rows.Count).End(xlUp).Row + 1 'Sets the last row in the Archives 'Copies the Calculator data to the Archive Sheets("Archive").Range("C" & LastRow) = Range("C10") Sheets("Archive").Range("B" & LastRow) = Range("E10") Sheets("Archive").Range("D" & LastRow) = Range("J10") Sheets("Archive").Range("E" & LastRow) = Range("D14") Sheets("Archive").Range("A" & LastRow) = Range("D18") Sheets("Archive").Range("F" & LastRow) = Range("H27") Sheets("Archive").Range("G" & LastRow) = Range("D27") 'Date and time of the archiving Sheets("Archive").Range("H" & LastRow) = Now 'Clears out the input data in the calculator but does not touch the calculated cells in the calculator Range("C10").ClearContents Range("E10").ClearContents Range("J10").ClearContents Range("D14").ClearContents Range("D18").ClearContents End SubCisco Anyconnect – Can Connect Via LAN, But Not Via Wireless
Thanks for the info.From the sounds of it, the issue is with the VPN setup. I highly recommend you talk to the IT people at work and explain the situation and see if they can't help you resolve it. At least, in my estimation that would be the best place to start troubleshooting this issue.It mattersRead more
From the sounds of it, the issue is with the VPN setup. I highly recommend you talk to the IT people at work and explain the situation and see if they can’t help you resolve it. At least, in my estimation that would be the best place to start troubleshooting this issue.
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***
Can’t Remotely Connect To Router
What are you doing again? The remote access feature is for WAN side access so you can configure the router from any where. You don't need it if you are the LAN side because you simply plug in the address of the router in a browser. You only need remote access if you are a network engineer and want tRead more
You only need remote access if you are a network engineer and want to configure routers from your main office when they are in remote locations. I would turn it off because you are giving access to any on on the Web to try to hack your router unless you have a really secure password.
-Bash: Spawn: Command Not Found
Does the file /usr/bin/expect exist?
Cpu Died, Had Burnt Smell, And Won’t Turn Back On
'CPU' is your processor (your Intel inside)Your burnt smell is more likely the motherboard than your CPU but even more likely your power supply. I see you did not list your make and model on the power supply, this makes me more suspicious of it.Open the case, let it air out for a while and see if yoRead more
Your burnt smell is more likely the motherboard than your CPU but even more likely your power supply. I see you did not list your make and model on the power supply, this makes me more suspicious of it.
Open the case, let it air out for a while and see if you can identify where the smell is coming from. Using a strong light, examine everything in detail (do not open the power supply), burnt, burst, browning, leaking components are the thing you are looking for, especially on the motherboard and graphics card. If the smell is clearly from the power supply, simply replace it. If any component has any visible signs as above, replace the entire board.
Now is also the time to tell us if you had overclocked either the CPU or graphics card (or even the memory). While overclocking will not directly burn out the CPU in general, overvolting it definitely can so list your overclock and voltages.
You have to be a little bit crazy to keep you from going insane.