You can do two thirds of this request though Group Policy.http://www.chromium.org/administrat...http://technet.microsoft.com/en-us/...Firefox is the holdout, but I guess that's the point of FirefoxADM.How To Ask Questions The Smart Way
for /f "tokens=*" %%a in ('dir C:\Users\user\Desktop\test\folder1\*.txt /b') DO DEL %%aUse a DIR because if the file does not exist it will not show in your loop.
for /f "tokens=*" %%a in ('dir C:\Users\user\Desktop\test\folder1\*.txt /b') DO DEL %%a
Use a DIR because if the file does not exist it will not show in your loop.
Hard to see without the code, but I assume you're doing something like this:FOR /F %%G IN (e:\apps\dw\dump\pending_trn.txt) DO ( stuff set someVar=%%G ) doSomething %someVar%If that's the case, then you're using the variable outside of the loop; of course it'll only have the last value in it.Or you'Read more
Hard to see without the code, but I assume you’re doing something like this:
FOR /F %%G IN (e:\apps\dw\dump\pending_trn.txt) DO (
stuff
set someVar=%%G
)
doSomething %someVar%
If that’s the case, then you’re using the variable outside of the loop; of course it’ll only have the last value in it.
Or you’re doing something like this:
FOR /F %%G IN (e:\apps\dw\dump\pending_trn.txt) DO (
stuff
echo %%G > SomeFile
)
type SomeFile
Perhaps you could use eFax software and "fax" the PDF's to yourself. I think that eFax software adds a date/time stamp, but I'm not 100% sure. Another option would be to see if your printer has an option to add a date/time stamp. Other than that, unless you can edit the PDF's and add the date/time sRead more
Perhaps you could use eFax software and “fax” the PDF’s to yourself. I think that eFax software adds a date/time stamp, but I’m not 100% sure.
Another option would be to see if your printer has an option to add a date/time stamp.
Other than that, unless you can edit the PDF’s and add the date/time stamp yourself, you might be out of luck.
Try downloading and saving the file to your PC. Then navigate to the file, right click > Open with > Choose Program.Click "Select the program from a list" > Click OKIn that list, find Powerpoint. (If it's not there, click browse and find it that way)Click it, and then click the checkbox undRead more
Try downloading and saving the file to your PC. Then navigate to the file, right click > Open with > Choose Program. Click “Select the program from a list” > Click OK In that list, find Powerpoint. (If it’s not there, click browse and find it that way) Click it, and then click the checkbox underneath that says “Always use the selected program to open this kind of file“ Click OK. The file will open in powerpoint. Close that off then try opening a file from IE again. It should work.
PEBMAC – The biggest cause of Computing problems. Damn ID10T Errors.
As far as I know, you haven't been able to open SuperCalc files in Excel since Excel 95. If you have Excel 95 lying around, you could open it, save it as an Excel file and then open it in a newer version of Excel. If you still have a copy of SuperCalc (which I doubt) you could open them and then savRead more
As far as I know, you haven’t been able to open SuperCalc files in Excel since Excel 95. If you have Excel 95 lying around, you could open it, save it as an Excel file and then open it in a newer version of Excel.
If you still have a copy of SuperCalc (which I doubt) you could open them and then save them in a format that Excel can read (e.g., text, CSV, SYLK, etc).
If it’s a really important file, you might want to try a 3rd party conversion company, which you could find via Google
I just re-read my post and feel that I should clarify something.I said:The code creates a randomly sorted list of players for each week. e.g. B, G, D, S, E, A, F, H, etc. It then pairs those players based on that random order e.g. BG, DS, EA, FHIn reality, the code only creates the randomly sorted lRead more
I just re-read my post and feel that I should clarify something.
I said:
The code creates a randomly sorted list of players for each week. e.g.
B, G, D, S, E, A, F, H, etc.
It then pairs those players based on that random order e.g.
BG, DS, EA, FH
In reality, the code only creates the randomly sorted lists of players for each week. It places those lists in C1:L24. It is the formulas in M1:V23 that actually create the pairs. Then the COUNTIF formulas in M25:V47 check for duplicates.
The COUNTIF formula in L26 then determines if there are any duplicates by checking to see if there are any values greater than 1 in the M25:V47 table.
It is the formula in L26 that the code monitors to determine if there needs to be a re-randomization of the current week. If anything other than 0 is in L26 after the current week’s pairings are checked, then there must be at least one duplicate and the week must be rerun.
As I mentioned in my previous post, this process is not as clean as it could be. The worksheet is also not as pretty as it could be. I managed to come up with something that works even if it is a bit clunky. At that point I quit and posted what I had. Once you understand how it works, you should be able to make it look nice. If not, just come on back.
Hi,You can't do it with standard Excel formulas.You can do it with Visual Basic code.Right-click the name Tab of your worksheet and select View code.In the Visual Basic window that opens enter this:Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$1" Then 'disable events ApRead more
Hi,
You can’t do it with standard Excel formulas.
You can do it with Visual Basic code.
Right-click the name Tab of your worksheet and select View code.
In the Visual Basic window that opens enter this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then
'disable events
Application.EnableEvents = False
'add B1 value to A1 and save in A1
Range("A1").Value = Range("A1").Value _
+ Range("B1").Value
End If
'reenable events
Application.EnableEvents = True
Exit Sub
'error handler
ErrHnd:
Err.Clear
'reenable events
Application.EnableEvents = True
End Sub
From the Visual Basic menu bar click File- Save Click Alt+f11 (the Alt key and function key #11 clicked together) to return to the main Excel window.
Now when the value in cell B1 is changed, the value in cell A1 will be updated to its original value plus the new value in cell B1.
This is triggered by Excel’s ‘on change’ event. The code then tests that the changed cell was cell B1 and if it was it does the required addition.
In your OP you said: "...and return the value that is always in column C" so that is what I solved.To pull values from Column F, just expand the array for the INDEX function and change the column_num argument to match the relative position of Column F within the array:=INDEX(Sheet2!$B$1:$F$16,MATCH(Read more
In your OP you said: “…and return the value that is always in column C” so that is what I solved.
To pull values from Column F, just expand the array for the INDEX function and change the column_num argument to match the relative position of Column F within the array:
Note: The row_num and column_num arguments are relative positions within the array, not the actual Row or Column number that Excel uses.
In other words, Column F is in relative position 5 within the array of columns B:F. e.g. B is 1, C is 2, F is 5. The same is true for the MATCH function. It returns a relative position within the lookup_array, not an actual Excel Row or Column number.
If the array starts in Row 1 and/or Column A, then the relative position will be the same as the Row and/or Column number, but if the array starts anywhere else, the numbers won’t match.
Bat/Script File To Set Homepage
You can do two thirds of this request though Group Policy.http://www.chromium.org/administrat...http://technet.microsoft.com/en-us/...Firefox is the holdout, but I guess that's the point of FirefoxADM.How To Ask Questions The Smart Way
http://www.chromium.org/administrat…
http://technet.microsoft.com/en-us/…
Firefox is the holdout, but I guess that’s the point of FirefoxADM.
How To Ask Questions The Smart Way
Batch Help – Check & Delete If Files Exists
for /f "tokens=*" %%a in ('dir C:\Users\user\Desktop\test\folder1\*.txt /b') DO DEL %%aUse a DIR because if the file does not exist it will not show in your loop.
for /f "tokens=*" %%a in ('dir C:\Users\user\Desktop\test\folder1\*.txt /b') DO DEL %%aUse a DIR because if the file does not exist it will not show in your loop.
Batch File For /F Loop Only Doing Last Item
Hard to see without the code, but I assume you're doing something like this:FOR /F %%G IN (e:\apps\dw\dump\pending_trn.txt) DO ( stuff set someVar=%%G ) doSomething %someVar%If that's the case, then you're using the variable outside of the loop; of course it'll only have the last value in it.Or you'Read more
Hard to see without the code, but I assume you’re doing something like this:
If that’s the case, then you’re using the variable outside of the loop; of course it’ll only have the last value in it.
Or you’re doing something like this:
If that’s the case, replace ‘>’ with ‘>>’.
Print Email Date And Time Stamp
Perhaps you could use eFax software and "fax" the PDF's to yourself. I think that eFax software adds a date/time stamp, but I'm not 100% sure. Another option would be to see if your printer has an option to add a date/time stamp. Other than that, unless you can edit the PDF's and add the date/time sRead more
Perhaps you could use eFax software and “fax” the PDF’s to yourself. I think that eFax software adds a date/time stamp, but I’m not 100% sure.
Another option would be to see if your printer has an option to add a date/time stamp.
Other than that, unless you can edit the PDF’s and add the date/time stamp yourself, you might be out of luck.
See lessPowerpoint Documents Open In IE And Not Powerpoint.
Try downloading and saving the file to your PC. Then navigate to the file, right click > Open with > Choose Program.Click "Select the program from a list" > Click OKIn that list, find Powerpoint. (If it's not there, click browse and find it that way)Click it, and then click the checkbox undRead more
Click “Select the program from a list” > Click OK
In that list, find Powerpoint. (If it’s not there, click browse and find it that way)
Click it, and then click the checkbox underneath that says “Always use the selected program to open this kind of file“
Click OK. The file will open in powerpoint. Close that off then try opening a file from IE again.
It should work.
PEBMAC – The biggest cause of Computing problems.
Damn ID10T Errors.
Missing: :-) VideoSoft VsFlex3 Controls In References
Glad you got it back to normal. I see no point in pursuing the matter further if it's fixed (and I've no idea where the smiley face came from anyway).
Glad you got it back to normal. I see no point in pursuing the matter further if it’s fixed (and I’ve no idea where the smiley face came from anyway).
See lessI Need To Open An Old Supercalc File In Excel
As far as I know, you haven't been able to open SuperCalc files in Excel since Excel 95. If you have Excel 95 lying around, you could open it, save it as an Excel file and then open it in a newer version of Excel. If you still have a copy of SuperCalc (which I doubt) you could open them and then savRead more
As far as I know, you haven’t been able to open SuperCalc files in Excel since Excel 95. If you have Excel 95 lying around, you could open it, save it as an Excel file and then open it in a newer version of Excel.
If you still have a copy of SuperCalc (which I doubt) you could open them and then save them in a format that Excel can read (e.g., text, CSV, SYLK, etc).
If it’s a really important file, you might want to try a 3rd party conversion company, which you could find via Google
See lessFinding Matching Pairs In Excel Using Vba
I just re-read my post and feel that I should clarify something.I said:The code creates a randomly sorted list of players for each week. e.g. B, G, D, S, E, A, F, H, etc. It then pairs those players based on that random order e.g. BG, DS, EA, FHIn reality, the code only creates the randomly sorted lRead more
I said:
In reality, the code only creates the randomly sorted lists of players for each week. It places those lists in C1:L24. It is the formulas in M1:V23 that actually create the pairs. Then the COUNTIF formulas in M25:V47 check for duplicates.
The COUNTIF formula in L26 then determines if there are any duplicates by checking to see if there are any values greater than 1 in the M25:V47 table.
It is the formula in L26 that the code monitors to determine if there needs to be a re-randomization of the current week. If anything other than 0 is in L26 after the current week’s pairings are checked, then there must be at least one duplicate and the week must be rerun.
As I mentioned in my previous post, this process is not as clean as it could be. The worksheet is also not as pretty as it could be. I managed to come up with something that works even if it is a bit clunky. At that point I quit and posted what I had. Once you understand how it works, you should be able to make it look nice. If not, just come on back.
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
message edited by DerbyDad03
Excel Formula & Value In Same Cell
Hi,You can't do it with standard Excel formulas.You can do it with Visual Basic code.Right-click the name Tab of your worksheet and select View code.In the Visual Basic window that opens enter this:Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$1" Then 'disable events ApRead more
You can’t do it with standard Excel formulas.
You can do it with Visual Basic code.
Right-click the name Tab of your worksheet and select View code.
In the Visual Basic window that opens enter this:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$1" Then 'disable events Application.EnableEvents = False 'add B1 value to A1 and save in A1 Range("A1").Value = Range("A1").Value _ + Range("B1").Value End If 'reenable events Application.EnableEvents = True Exit Sub 'error handler ErrHnd: Err.Clear 'reenable events Application.EnableEvents = True End SubFrom the Visual Basic menu bar click File- Save
Click Alt+f11 (the Alt key and function key #11 clicked together) to return to the main Excel window.
Now when the value in cell B1 is changed, the value in cell A1 will be updated to its original value plus the new value in cell B1.
This is triggered by Excel’s ‘on change’ event. The code then tests that the changed cell was cell B1 and if it was it does the required addition.
Regards
Excel Formula: Using Current Month To Locate A Value
In your OP you said: "...and return the value that is always in column C" so that is what I solved.To pull values from Column F, just expand the array for the INDEX function and change the column_num argument to match the relative position of Column F within the array:=INDEX(Sheet2!$B$1:$F$16,MATCH(Read more
To pull values from Column F, just expand the array for the INDEX function and change the column_num argument to match the relative position of Column F within the array:
=INDEX(Sheet2!$B$1:$F$16,MATCH(DATE(YEAR(TODAY()),MONTH(TODAY()),1),Sheet2!$B$1:$B$16,0),5)
Note: The row_num and column_num arguments are relative positions within the array, not the actual Row or Column number that Excel uses.
In other words, Column F is in relative position 5 within the array of columns B:F. e.g. B is 1, C is 2, F is 5. The same is true for the MATCH function. It returns a relative position within the lookup_array, not an actual Excel Row or Column number.
If the array starts in Row 1 and/or Column A, then the relative position will be the same as the Row and/or Column number, but if the array starts anywhere else, the numbers won’t match.
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.