Search results for query: *

It's possible that feeding the enter code via parameter happens too quickly. I.E., the parameter is read immediately upon program load rather than when the program is looking for it. Usually, there are speedy replies here ... Maybe the pro's are chuckling to themselves while we're trying to...

I just couldn't completely give up. Try this: set /a FIELD4=\x0D Also, check to see if there are options available with programs requiring Enter. I.E., I have used some that had parameter options for automated use. Something like: C:\path\someprog.exe /a where the /a indicated to the...

I didn't test enough ... The idea came from: http://justgeeks.blogspot.com/2008/07/save-output-of-dos-command-to-variable.html But, it doesn't work with non-printing characters. I give up. HTH, Bob [morning]

Cretin, Didn't seem like it should be so difficult ... And you may not like it - I surely don't. But the cost is free ... I wonder if you weren't given this task as a test or challenge. 1. Create a text file using a hex editor. I used HxD. If you need one, it's at...

If the only entry in FIELD4 and FIELD 5 is to be a Carriage Return, then you can try: set FIELD4=chr(13) HTH, Bob [morning]

There must be more to your question than shown ... If not, assuming the columns look like A B C D E F DATE In CASH In CHEQUE Out CASH Out CHEQUE TOTAL 1 02/28/12 10.00 15.00 5.00 8.00...

Normally I mind my own business, but ... This thread is Rad, Totally Awesome, Way Cool, or even ... Neat! My apologies to Nighteyes and the moderators as I couldn't keep from ranting. Lesson: When problem code is posted, post all of it, because surprises can occur. Combo cannot possibly...

Hello, What is the definition of "extra software"? PDF's by design are not changeable without specialized software. If the end user is expected to have Word, then you could change your document to a Word form and accomplish the task. See...

NICE! I saw that no one had posted, so I was playing with it. Had come to the conclusion that you might have to take the workbook offline to make the change. Regarding the possibility of double commas, you could just run a SUBSTITUTE first. Something like the following in another column...

Sounds like a candidate for a pivot table. Using your sample data, a basic one returns: Count of NAME SERVICE NAME Cable Internet Phone blank) Grand Total Jane Smith 1 1 2 John Doe 1 1 1 3 (blank) Grand Total...

I wanted to automate determining when holidays occur. Looked on the internet and found an example for Labor Day posted on www.chandoo.org illustrating a good use for the CHOOSE instruction. Following are formulas that work for the holidays indicated Enter the year of interest in cell D3 of a...

Thank you both for posting! I am wirelessly operational. No offense, but your answers were pretty basic so I chose not to award any stars. I could not find the original CD that came with my kit and could not find the software to download. I considered buying additional Microsoft hardware on...

I have this PC (the one I'm entering this message with) connected to a Motorola cable modem. The modem should be current - it's used by Time Warner to provide All in One - internet, cable TV and phone service. At the moment, this is the only operational PC and I don't want to keep it in the...

I've already been assisted with most of my automation project, but ... When I "Save As" to create a tab-delimited text file to be imported into G/L, the end of the file is often after the last actual data. That causes a problem with the G/L program when imported, so now I have to manually...

Uh, one problem, John ... The month HAS to be uppercase. Custom format doesn't do it and UPPER requires text. Couldn't make tsh73's suggestion work ... Maybe he has an add-in that does dayIfWeek Thanks everyone for assisting! Bob

Borrowing from Staples ... "That was easy" Thanks and stars to both! Finally usage is: =UPPER(TEXT(TODAY()-WEEKDAY(TODAY())+1,"MMM-DD-YYYY"))

I CAN figure this out ... I think ... but maybe someone has a clean and easy way. Our pay periods (multiple locations) end on Sundays. Accounting staff presently post G/L entries related to payrolls by manually typing from a payroll report. I've developed a spreadsheet with a bit of VBA that...

tizwaz, Roy said "MichaelRed has done lot of that work for you" He did not say that ALL of the work was done. You need logic that initializes a loop counter "counter", saves the number of days "nbrdays". LOOP advance a day, check for weekend/holiday - if so advance to next date without...

Hello, Thread thread707-1169212 got me started in the right direction, but ... The worksheet is used to tally survey results. It's working well and I want to make it better. Each row corresponds to a question number. In use, the code locks cursor positioning into B and the User types the number...