Copy/save this as Firstbat.bat then run it.@echo off cls echo Now running Firstbat.bat which will create Secondbat.bat then call it. echo.&echo.;&echo.; ( echo echo This is Secondbat.bat which doesn't do a lot as you didn't say what you echo echo wanted the .bat files to do. )>%temp%\SecoRead more
Copy/save this as Firstbat.bat then run it.
@echo off
cls
echo Now running Firstbat.bat which will create Secondbat.bat then call it.
echo.&echo.;&echo.;
(
echo echo This is Secondbat.bat which doesn't do a lot as you didn't say what you
echo echo wanted the .bat files to do.
)>%temp%\Secondbat.bat
call %temp%\secondbat.bat
echo.&echo.;&echo.;
echo Now returned to Firstbat.bat
del %temp%\secondbat.bat
Did you Google for an answer before asking the question?
Run this and post a few lines of the output. :: ========================================== :: :: bydate.bat Wed 25-05-2011 18:19:47.17 @echo off & setLocal enableDELAYedeXpansioN for /f "tokens=* delims= " %%a in ('dir/b/s/a-d') do ( echo.%%~Ta %%a )
Run this and post a few lines of the output.
:: ==========================================
::
:: bydate.bat Wed 25-05-2011 18:19:47.17
@echo off & setLocal enableDELAYedeXpansioN
for /f “tokens=* delims= ” %%a in (‘dir/b/s/a-d’) do (
echo.%%~Ta %%a
)
I supose that you could do a simple charactor substution there really is not anything built in. have the system take in text and parse it into variables, and then change to a different charactor and send it back into a text file. but its gonna be a long program
I supose that you could do a simple charactor substution
there really is not anything built in.
have the system take in text and parse it into variables, and then change to a different charactor and send it back into a text file. but its gonna be a long program
i did find a working work around and my script seems to be happy but im not there should be a simple solution using the orginal method just modified in some way wmic path win32_videocontroller get deviceid, pnpdeviceid | for /f "tokens=2" %%a in ('find /i "videocontroller1"') do @echo %%a >null sRead more
i did find a working work around and my script seems to be happy but im not there should be a simple solution using the orginal method just modified in some way
wmic path win32_videocontroller get deviceid, pnpdeviceid | for /f “tokens=2” %%a in (‘find /i “videocontroller1″‘) do @echo %%a >null
set /p x= < null
im just echoing the output to a file and then reading it right back in redundent and messy but works
I didn't try to use the script you posted - it was way too confusing for me. I tried from "ground up", and this seems to work with my limited testing: @echo off >mainfile & setlocal enabledelayedexpansion for /f %%z in ('dir /b /x *.csv') do ( echo FILE:%%z set /p test=>mainfile echo %%a gRead more
I didn’t try to use the script you posted – it was way too confusing for me. I tried from “ground up”, and this seems to work with my limited testing:
@echo off >mainfile & setlocal enabledelayedexpansion
for /f %%z in (‘dir /b /x *.csv’) do (
echo FILE:%%z
set /p test=>mainfile echo %%a
goto :eof
:14
echo %1:at fourteen
for /f “skip=1 tokens=1-3,5-8,9* delims=,” %%a in (%1) do >>mainfile echo %%a,%%b,%%c,%%d,%%e,%%f,%%g,%%i
goto :eof
:end
this sets all lines to 12 elements, and of course skips all the header lines (you might need to put the first one back in). No account taken for char.s hazardous to batchscript health and stability in the filestream.
ps: left a lot of debugging turds in the script. filter them out when things are working…
First, a posting tip...Please click on the blue line at the end of this post and read the instructions on how to post VBA code in this forum. As for your question, your code selects E29 and puts the formula in that cell. That's all it's ever going to do since you've hardcoded that range reference. IRead more
First, a posting tip…
Please click on the blue line at the end of this post and read the instructions on how to post VBA code in this forum.
As for your question, your code selects E29 and puts the formula in that cell. That’s all it’s ever going to do since you’ve hardcoded that range reference. It’s going to put the formula in E29 every time you run the macro.
In addition, you do not have to Select a range via VBA to perform an action on it. That’s very inefficient. You can almost always perform the operation directly on the range within VBA.
Try this. It inserts a row above the Named range and then uses the Row property of the Named range to determine where to put the formula. Basically you are letting VBA figure out what row to put the formula in instead of telling it to put the formula in a specific cell.
Sub InsertFormula()
'Insert row above named range
Range("IMP_01").EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
'Put formula in new row
Range("E" & Range("IMP_01").Row - 1).FormulaR1C1 = "=RC[-2]*RC[-1]"
End Sub
When you enter a character in a cell and before you press enter can you see the character in the Formula Bar? I still think it could be your Font Color. Check to make sure there are no rogue Macros running and also check for any Conditional Formatting. Does it occur on all Sheets in the Workbook orRead more
When you enter a character in a cell
and before you press enter
can you see the character in the Formula Bar?
I still think it could be your Font Color.
Check to make sure there are no rogue Macros running
and also check for any Conditional Formatting.
Does it occur on all Sheets in the Workbook
or just one specific sheet?
What version of Excel are you using?
If your on 2007 or newer, try saving the workbook in a different format like .xls
and see if it continues to give the same problem.
How about these:=SUM(D5,H5,L5,-J5,-N5)+INT(SUM(E5,I5,M5,-K5,-O5)/100)=RIGHT(SUM(E5,I5,M5,-K5,-O5),2)*1Basically, I'm doing the "subtraction" within your SUM functions by turning your subtraction values into negative numbers. After that, the rest of your original formulas take over.Click Here BeforeRead more
Basically, I’m doing the “subtraction” within your SUM functions by turning your subtraction values into negative numbers. After that, the rest of your original formulas take over.
I'm not sure if this is what you are looking for, but you could use Named Ranges for your regions and then refer to the individual cells in the range. For example, if you named B47:B49 as Region1, then this formula should give you the total number of instances of all of the values in B47:B49 found iRead more
I’m not sure if this is what you are looking for, but you could use Named Ranges for your regions and then refer to the individual cells in the range. For example, if you named B47:B49 as Region1, then this formula should give you the total number of instances of all of the values in B47:B49 found in E2:E26:
BTW..If you are using SUM, you don’t need the Addition Operator within the parenthesis, you can just use a comma. If you want to use the Addition Operator then you don’t need the SUM function. It is redundant.
Batch File That Creates Another Batch File?
Copy/save this as Firstbat.bat then run it.@echo off cls echo Now running Firstbat.bat which will create Secondbat.bat then call it. echo.&echo.;&echo.; ( echo echo This is Secondbat.bat which doesn't do a lot as you didn't say what you echo echo wanted the .bat files to do. )>%temp%\SecoRead more
Copy/save this as Firstbat.bat then run it.
Did you Google for an answer before asking the question?
Batch File Open Last Modified File
Run this and post a few lines of the output. :: ========================================== :: :: bydate.bat Wed 25-05-2011 18:19:47.17 @echo off & setLocal enableDELAYedeXpansioN for /f "tokens=* delims= " %%a in ('dir/b/s/a-d') do ( echo.%%~Ta %%a )
Run this and post a few lines of the output.
:: ==========================================
::
:: bydate.bat Wed 25-05-2011 18:19:47.17
@echo off & setLocal enableDELAYedeXpansioN
for /f “tokens=* delims= ” %%a in (‘dir/b/s/a-d’) do (
See lessecho.%%~Ta %%a
)
Batch File Decoder
I supose that you could do a simple charactor substution there really is not anything built in. have the system take in text and parse it into variables, and then change to a different charactor and send it back into a text file. but its gonna be a long program
I supose that you could do a simple charactor substution
there really is not anything built in.
have the system take in text and parse it into variables, and then change to a different charactor and send it back into a text file. but its gonna be a long program
See lessBat Script – Parsing A Variable With A For Command
i did find a working work around and my script seems to be happy but im not there should be a simple solution using the orginal method just modified in some way wmic path win32_videocontroller get deviceid, pnpdeviceid | for /f "tokens=2" %%a in ('find /i "videocontroller1"') do @echo %%a >null sRead more
i did find a working work around and my script seems to be happy but im not there should be a simple solution using the orginal method just modified in some way
wmic path win32_videocontroller get deviceid, pnpdeviceid | for /f “tokens=2” %%a in (‘find /i “videocontroller1″‘) do @echo %%a >null
set /p x= < null
im just echoing the output to a file and then reading it right back in redundent and messy but works
See lessA Batch File That Will Combine Multipule .Csv Files Into One
I didn't try to use the script you posted - it was way too confusing for me. I tried from "ground up", and this seems to work with my limited testing: @echo off >mainfile & setlocal enabledelayedexpansion for /f %%z in ('dir /b /x *.csv') do ( echo FILE:%%z set /p test=>mainfile echo %%a gRead more
I didn’t try to use the script you posted – it was way too confusing for me. I tried from “ground up”, and this seems to work with my limited testing:
See less@echo off >mainfile & setlocal enabledelayedexpansion
for /f %%z in (‘dir /b /x *.csv’) do (
echo FILE:%%z
set /p test=>mainfile echo %%a
goto :eof
:14
echo %1:at fourteen
for /f “skip=1 tokens=1-3,5-8,9* delims=,” %%a in (%1) do >>mainfile echo %%a,%%b,%%c,%%d,%%e,%%f,%%g,%%i
goto :eof
:end
this sets all lines to 12 elements, and of course skips all the header lines (you might need to put the first one back in). No account taken for char.s hazardous to batchscript health and stability in the filestream.
ps: left a lot of debugging turds in the script. filter them out when things are working…
Simple Formula Is Not Working In Macro
First, a posting tip...Please click on the blue line at the end of this post and read the instructions on how to post VBA code in this forum. As for your question, your code selects E29 and puts the formula in that cell. That's all it's ever going to do since you've hardcoded that range reference. IRead more
Please click on the blue line at the end of this post and read the instructions on how to post VBA code in this forum.
As for your question, your code selects E29 and puts the formula in that cell. That’s all it’s ever going to do since you’ve hardcoded that range reference. It’s going to put the formula in E29 every time you run the macro.
In addition, you do not have to Select a range via VBA to perform an action on it. That’s very inefficient. You can almost always perform the operation directly on the range within VBA.
Try this. It inserts a row above the Named range and then uses the Row property of the Named range to determine where to put the formula. Basically you are letting VBA figure out what row to put the formula in instead of telling it to put the formula in a specific cell.
Sub InsertFormula() 'Insert row above named range Range("IMP_01").EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove 'Put formula in new row Range("E" & Range("IMP_01").Row - 1).FormulaR1C1 = "=RC[-2]*RC[-1]" End SubClick Here Before Posting Data or VBA Code —> How To Post Data or Code.
Office 2010 Size?
It's probably just the different malware that's included with the cracked versions ;-)
It’s probably just the different malware that’s included with the cracked versions 😉
See lessMy Excel Spreadsheet Won’t Accept New Data
When you enter a character in a cell and before you press enter can you see the character in the Formula Bar? I still think it could be your Font Color. Check to make sure there are no rogue Macros running and also check for any Conditional Formatting. Does it occur on all Sheets in the Workbook orRead more
When you enter a character in a cell
and before you press enter
can you see the character in the Formula Bar?
I still think it could be your Font Color.
Check to make sure there are no rogue Macros running
and also check for any Conditional Formatting.
Does it occur on all Sheets in the Workbook
or just one specific sheet?
What version of Excel are you using?
See lessIf your on 2007 or newer, try saving the workbook in a different format like .xls
and see if it continues to give the same problem.
How To Do This Calculation
How about these:=SUM(D5,H5,L5,-J5,-N5)+INT(SUM(E5,I5,M5,-K5,-O5)/100)=RIGHT(SUM(E5,I5,M5,-K5,-O5),2)*1Basically, I'm doing the "subtraction" within your SUM functions by turning your subtraction values into negative numbers. After that, the rest of your original formulas take over.Click Here BeforeRead more
=SUM(D5,H5,L5,-J5,-N5)+INT(SUM(E5,I5,M5,-K5,-O5)/100)
=RIGHT(SUM(E5,I5,M5,-K5,-O5),2)*1
Basically, I’m doing the “subtraction” within your SUM functions by turning your subtraction values into negative numbers. After that, the rest of your original formulas take over.
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
message edited by DerbyDad03
How To Count Items That Are In A Category In Excel
I'm not sure if this is what you are looking for, but you could use Named Ranges for your regions and then refer to the individual cells in the range. For example, if you named B47:B49 as Region1, then this formula should give you the total number of instances of all of the values in B47:B49 found iRead more
EDIT:
=SUM(COUNTIF($E2:$E26, INDEX(Region1,1):INDEX(Region1,MATCH("*",Region1,-1))))This is an Array formula and must be enter with Ctrl-Shift-Enter every time you edit it.
If you want to put a Region’s name in a cell, such as A1, you could then refer to that Named Range with the INDIRECT function.
e.g. if you put Region1 in A1, this formula would be equivalent to the one above.
=SUM(COUNTIF($E2:$E26, INDEX(INDIRECT(A1),1):INDEX(INDIRECT(A1),MATCH("*",INDIRECT(A1),-1))))This, of course is also an array formula.
BTW..If you are using SUM, you don’t need the Addition Operator within the parenthesis, you can just use a comma. If you want to use the Addition Operator then you don’t need the SUM function. It is redundant.
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
message edited by DerbyDad03