Search found 50 matches

by snapper1969
Thu Feb 03, 2011 8:08 am
Forum: Beginners
Topic: WriteLn
Replies: 2
Views: 4753

WriteLn

Let>CF_OVERWRITE=1 CopyFile>C:\Program Files\Putty\OrgFile\config.scr,C:\Program Files\Putty\config.scr GetFileList>Z:\IQXReports\IDriveBackup\*.*,files Separate>files,;,file_names Let>k=0 Repeat>k Let>k=k+1 WriteLn>c:\program files\putty\config.scr,result,file_names_%k% Until>k,file_names_count Whe...
by snapper1969
Tue Feb 01, 2011 10:33 am
Forum: General Discussion
Topic: file rename
Replies: 3
Views: 8347

mtettmar wrote:Year>yyyy
Month>mm
Day>dd
Let>new_file=c:\somewhere\myzip_%yyyy%%mm%%dd%.zip
RenameFile>source_file,new_file
Thanks Marcus...this works except for the month, I'm not getting 02, it started at 44 and goes up by one each time I run the macro. Any ideas?.

Regards,

John
by snapper1969
Tue Feb 01, 2011 9:32 am
Forum: General Discussion
Topic: file rename
Replies: 3
Views: 8347

file rename

Hi,

I have a script that zips up some file, what I would like to do is add the current date and time to the end of the file and move it, any tips?.

Regards,

John
by snapper1969
Sun Apr 26, 2009 12:40 pm
Forum: General Discussion
Topic: Not MS related
Replies: 1
Views: 3212

Not MS related

Hi, This query isn't MS related but as there are programmers on here I thought I might try and get a reply: My son has asked if there is any software he could use whereby he has 2 laptops connected, on each there is a drawing of a house and if you press a key on one laptop a section of the house on ...
by snapper1969
Thu Oct 23, 2008 3:46 pm
Forum: Technical / Scripting
Topic: Protected sheets in excel
Replies: 3
Views: 4008

Thx Marcus...It is also hidden..Can I do WorkBookObj.Unhide and do I need to ??

Thx,

John
by snapper1969
Thu Oct 23, 2008 3:23 pm
Forum: Technical / Scripting
Topic: Protected sheets in excel
Replies: 3
Views: 4008

Protected sheets in excel

Hi, I have an excel worksheet that has 12 dates in various cells, this worksheet is protected. Would it be possible to use MS to create an app that asked the user for 12 dates that would populate the relevant cells in the protected worksheet?. Can you unprotect the worksheet via MS and re-protect at...
by snapper1969
Wed Sep 03, 2008 4:20 pm
Forum: Technical / Scripting
Topic: Outlook
Replies: 1
Views: 2714

Outlook

Hi,

I have a MS macro that zips up specific files into 4 different zip files. I also have an Outlook macro that creates 4 different emails and attaches the zip files created. Is there anyway that MS can run the outlook macro as it would make the whole process seamless?.

Thx,

John
by snapper1969
Mon Aug 25, 2008 4:01 pm
Forum: Technical / Scripting
Topic: File Dates
Replies: 5
Views: 5629

I've changed the following but with no success: Let>z=1 Label>files ReadIniFile>c:\wg09.ini,%archive%,parm%z%,filename If>filenamefiles Day>the_day Month>the_month Year>the_year Let>thisday=%the_year%%the_month%%the_day% FileDate>%source%%filename%,fdate if>fdate=thisday,zipfile,zipcounter Label>zip...
by snapper1969
Mon Aug 25, 2008 3:36 pm
Forum: Technical / Scripting
Topic: File Dates
Replies: 5
Views: 5629

Use IfFileExists before doing ZIP_Add? marcus, I put: IfFileExists>%source%%filename%,,files before the ZIP_Add but it is still adding old files to the zip. I thought this would have been enough: Day>the_day Month>the_month Year>the_year Let>thisday=%the_year%%the_month%%the_day% FileDate>%source%%...
by snapper1969
Mon Aug 25, 2008 3:00 pm
Forum: Technical / Scripting
Topic: File Dates
Replies: 5
Views: 5629

File Dates

Hi, I have the following script: I'm trying to zip up the file wildcards that are created on the same day as the script is run. The script works fine except it zips up the filnames even if they have not been created that day, can anybody advise?. Thx, John Dialog>MyDialog Caption=GL Packaging Left=3...
by snapper1969
Sun Aug 24, 2008 9:40 pm
Forum: Beginners
Topic: Read Variable from Text File?
Replies: 5
Views: 9058

Thx, this was very helpful.

John
by snapper1969
Sun Aug 24, 2008 2:20 pm
Forum: Beginners
Topic: Read Variable from Text File?
Replies: 5
Views: 9058

You could set up an INI file then use the ReadIniFile> function. the Ini file might look something like: [recipients] recip1=bob@mail.com recip2=jen@mail.com recip3=tom@mail.com recip4=stop You would loop through looking at the recips until you run into the one labeled stop. JRL...How would I loop ...
by snapper1969
Sun Aug 24, 2008 1:09 pm
Forum: Technical / Scripting
Topic: readinifile
Replies: 1
Views: 2742

readinifile

Hi, I have the following portion in an ini file: [MAPPING] PTEMPLATE=C:\TEST\TEAM1\GL Zip Templates\ PCOMPLETED=C:\TEST\TEAM1\GL Completed Zips\ SOURCEFILES=C:\TEST\TEAM1\ [ZIPTEMPLATES] PARM1=TEAM1 FILE1 PARM2=TEAM1 FILE4 PARM3=TEAM1 COST PARM5=TEAM1 FILE6 PARM4=TEAM1 PSPERS PARM6=TEAM1 GL PARM8=ST...
by snapper1969
Thu Aug 14, 2008 6:50 am
Forum: Technical / Scripting
Topic: Winzip Encrypt
Replies: 1
Views: 3562

Winzip Encrypt

Hi,

Is there a way to encrypt a winzip file, the command line util is not allowed / available here.

Thx,

John
by snapper1969
Mon Aug 11, 2008 1:32 pm
Forum: Beginners
Topic: EXE Compiles
Replies: 1
Views: 3367

EXE Compiles

Hi,

Does the zip pluging dll's etc get included in a compiled script?.

thx,

john
cron
Sign up to our newsletter for free automation tips, tricks & discounts