Macro Scheduler Forums

JRL

Found an answer HERE VBStart Const xlToRight = -4161 Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True Set objWB = objExcel.Workbooks.Open("I:\dick\TableTabFiles\Router_Lines_Used_Since_2018.xlsx") Set objSheet = objwb.Sheets("Sheet1") objSheet.Columns("D:D").Insert xlToRight ...

JRL

Does anyone have a method to insert a column into an existing Excel worksheet? I am looking to see if VBScript can do this but if someone already has a way I'd appreciate hearing about it. For example: I want to insert a column after C and call it "Area" Before A B C D E Length Width Height Error Ph...

JRL

I don't know. Though in today's world and with Macro Scheduler's capabilities you'd probably be better off putting your efforts into learning Python rather than the antiquated VBScript. I usually search for code snippets that are close to what I want then alter them to try to accomplish my goal. A l...

JRL

Code: Select all

VBEval>WeekdayName(Weekday("2019-10-30",0)),vDayoftheWeek
MDL>vDayoftheWeek

JRL

Perhaps a symbol of anarchy? A dot hidden between the lines of code to remind the proletariat to stay strong? OR, way more likely, a way to provide white space in the code since the (code) (/code) html function removes blank lines.

JRL

Just add another "find". Type "DOS find" into your favorite search engine for more info.

Code: Select all

Let>vPath=%userdocuments_dir%\PDF_Files
.
Let>RP_Wait=1
Let>RP_Windowmode=0
RunProgram>cmd /c dir "%vPath%\*.*" | find /V /I "_x" | find /V /I "_y" | clip
GetClipboard>vData
MDL>vData

JRL

This help?

Code: Select all

Let>vPath=%userdocuments_dir%\PDF_Files
.
Let>RP_Wait=1
Let>RP_Windowmode=0
RunProgram>cmd /c dir "%vPath%\*.*" | find /V /I "_x" | clip
GetClipboard>vData
MDL>vData

JRL

Could just create subroutines for each trig function you want to use. These three usually get me by. You might have to set the function result to a variable then use the variable in your formula similar to the way the result variables are used in the ending message below. input>Angle,Angle in Degree...

JRL

I think there's something weird about "pdinfo.exe". I think the message "The filename, directory name, or volume label syntax is incorrect." is being generated by "pdinfo.exe". To help your sanity, the program is not following the rules. Made me crazy too. In any case I got it to work WITH spaces in...

JRL

My experience with spaces in paths and file names has been that RunProgram> and ExecuteFile> do not need quotes. If you use RunProgram> with a cmd you do need quotes around paths and names with spaces in them.

JRL

Hi Keith,

I'd try a "cmd /k" to be able to see what fails. The "/k" will leave the DOS box open.

RunProgram>cmd /k "c:\temp\pdfinfo.exe" "c:\temp\test.pdf"|find "Pages:" > "c:\temp\numpages.txt"

JRL

Another possible method is the to use the "_WRITE_LOG_FILE" system variable. When it is set to "0" logging is suspended until you reset it back to "1". If the script always fails in the same place or places, those may be the only places that need to be logged. Let>_WRITE_LOG_FILE=0 //Lines of code n...

JRL

I'd try Marcus' Most Used Regex . To parse. Then you use the produced array of data any way you'd like. Let>vData=[{"Landmark_Style":"Customer Site","idLandmark":75705,"idCustomer":153,"idLandmark_Style":8,"Landmark_Category":1,"Created_On":"2019-10-01T20:38:29.357","Created_By":2772, //Use Marcus' ...

JRL

Hi timle, Though its true that UI events can't be performed while your screen is locked, non-UI events can. If you can find a way to print your documents from a command line they can be printed while the screen is locked. To demonstrate, the following script will lock your screen and print a test do...

JRL

I have a script that runs daily and every now and then I need to alter how far back it looks within a group of files. I could just hard code the value and alter the script when I need to but in this case the file is compiled so I'd need to recompile each time I made a change. Could also use the stan...

Search found 3238 matches

Re: Create Column in Excel

Create Column in Excel

Re: GEt day of week from date string

Re: Get day of week from date string

Re: List files with exclusion

Re: List files with exclusion

Re: List files with exclusion

Re: Trigonometric functions

Re: Having issues with RunProgram

Re: Having issues with RunProgram

Re: Having issues with RunProgram

Re: Logging scripts makes it slow. Need an alternative

Re: extracting values from a text file

Re: everyday logon and print

Parameters in the File Name