I don't care what they say about you Marcus.. YOU'RE THE BEST...!!

Hi, Related to this old post.. http://www.mjtnet.com/forum/viewtopic.php?p=21137#21137 Need to send an application a date in this format: 2010-06-30. So, yyyy-mm-dd. Today, I will need to send 2010-06-30, but the vbscript I am using sends 2010-07-00. Very literally today -1.. The code works perfectl...

I like the robotic man. I often think of Macro as a person (worker). Nice to put a face with the name. lol.

SMTP macroscripts. Some email servers will not allow outside domain relay emails - only internal. Even with relay enabled on the server it still wants the email client to ssl authnticate. In this case it's Macro Scheduler, not an actual email client. I looked around a bit and the best option to quic...

Check out this thread...

http://www.mjtnet.com/forum/viewtopic.p ... highlight=

Nice Work. This is fun and very cool.

Ed

Thanks very much. I am not sure why I do not have the leading zeros. This is on XP and Vista..

Why doesn't this work? Maybe a wish for wish for a datesub> command to retain the 0's in front of month and day for date management functions... I am looking to subtract one day from script execution day and the receiving systems require the leading zeros on month and day. I had trouble posting the ...

Thanks Marcus,
This will be perfect for me.

I have been struggling with code for the following and would appreciate any advice. Read thru a specific file folder and read the first line of each file within the folder. All are text files. While doing this I would like to parse the 1st line and write specific fields from the line to another sing...

Many may not be interested, but maybe.. It would be nice to be able to highlight a portion of code, right click and run it from within the advanced editor. Anyone familiar with MS SQL knows this feature and it comes in handy for for expediently building queries. My second one may just be laziness. T...

Hmmm.. Thanks I think.. seem a bit fresh towards the end..lol When DBCONNECT runs its powerful, but the problems with Excel have been killing me. The connection string nuances for the different versions, vbscripting problems, data in cells the "255" char issue, wrapping, etc. I can't be alone out he...

I have another strange problem with Excel. In order to understand the problem use code below and recreate the issue: step 1 - Create a spreadsheet with 10 rows of data (C:\1\book1.xls) step 2 - In column 1 row 6 type hello step 3 - Column 9 type 1 Then run this script and open text file it creates: ...

adCmdStoredProc=4
cmd.CommandText = "uspScreenScrape_Test"
cmd.commandtype=adCmdStoredProc

Brent,
You lost me a bit from your first question/requirement. Can you clarify your total process?