WSH & Client Side VBScript

Re:Help with PST copy (59cobalt)

Sat, 04 Feb 2012 15:38:47 GMT

It's an FAQ, too.

Re:Excel Without Excel (59cobalt)

Sat, 04 Feb 2012 15:37:34 GMT

I don't think there's a reasonable way to script creation of (formatted) Excel files without having Excel. I don't have that much experience with (Libre|Neo|Open)Office from an automation PoV, but judging from a quick glance it doesn't look like they int

Re:Scheduled task with ADODB (59cobalt)

Sat, 04 Feb 2012 15:30:29 GMT

You're welcome.

Re:Need script to output difference in folders (ebgreen)

Sat, 04 Feb 2012 13:21:05 GMT

What have you written so far? This question or very similar ones have been asked many many times. Did you search?

Re:My first question (Wakawaka)

Sat, 04 Feb 2012 05:59:41 GMT

Your second test it turning out like that because you are using the Or operation improperly. How you are using it is actually the bitwise operation so it is Or'ing there bit values, which in this case the values = 7 (which would mean it would pr

My first question (stressmathers)

Sat, 04 Feb 2012 03:46:43 GMT

I'm trying to do the legwork and avoid asking questions. Personally I learn a lot more by figuring things out but this one is stumping me. Keep in mind I'm just starting out so I'm experimenting - I know you would never actually write a script this way.

Need script to output difference in folders (chango77747)

Fri, 03 Feb 2012 16:53:20 GMT

Hey everyone, I have two folders (folder1, folder2). Folder2 is a compiled version of a bunch of other folders including folder1. I want to compare folder1 to folder2 to make sure that folder2 contains all of the contents of folder1. If it does not

Re:Help (nexcompac1)

Fri, 03 Feb 2012 15:02:43 GMT

Here is a 3 part possible solution 1) @echo off REM Copy_Files.cmd REM THIS SCRIPT WILL Migrate a select group of Folder directories in the NAS or on a share REM rem it works with Copy_Files_L.CMD (the looper - which MUST BE EDITE

Script failing to run uptime (nexcompac1)

Fri, 03 Feb 2012 09:53:03 GMT

Other Programming/Scripting Languages: http://www.visualbasicscript.com/fb.ashx?m=96118

Re:Help with PST copy (ebgreen)

Fri, 03 Feb 2012 09:52:19 GMT

Search this forum for: Recursive search Recursion

Re:Help with PST copy (timassin)

Fri, 03 Feb 2012 09:42:42 GMT

The only thing with Filesystemobject I can't figure out a way to search for files by extension through the whole c drive.

Re:Excel Without Excel (ebgreen)

Fri, 03 Feb 2012 08:55:39 GMT

Hmmm...I'm pretty sure that Open Office does expose an API, but I've never worked with it.

Re:Excel Without Excel (TaterTot)

Fri, 03 Feb 2012 08:30:53 GMT

If the excel file were for me, I would say that's acceptable. Unfortunately, this will be emailed to my accounting department and they need colors, titles, merged cells, bla, bla, bla. So...it needs to be an xls file with proper formatting.

Re:Excel Without Excel (ebgreen)

Fri, 03 Feb 2012 08:18:22 GMT

Why not use powershell and export whatever you need as a CSV. That's how I do most everything these days.

Re:Help (ebgreen)

Fri, 03 Feb 2012 08:16:34 GMT

"I think EBGREEN or RASIMMER posted an example of this somewhere on this forum a while back." Not me. If you can't do it at the command line, it ain't worth doin'

Excel Without Excel (TaterTot)

Fri, 03 Feb 2012 06:49:52 GMT

Hi All, I was wondering if anyone knew any tricks or could provide me links to creating Excel applications without having Excel on the computer? Basically, I want to have a server compile information, write it to an excel file, and email it t

Re:Scheduled task with ADODB (TaterTot)

Fri, 03 Feb 2012 06:28:53 GMT

Hi 59cobalt, Thanks again for your help. After adding the additional event logging I received this error: Could not find file 'C:\Windows\system32\AssetInventory.mdb'. (0x80004005) When you think about it, it makes sense. Since the "tasks

Re:Help (TaterTot)

Thu, 02 Feb 2012 15:44:16 GMT

@dm_4ever Because using Robocopy feels like your cheating...? Your looking at a pretty hefty script by the time your done but it CAN be done. 2. I can think of 3 options. Each one more difficult than the last. First, write the name of the fol

Re:Beats me - Help needed with folder object and output redirection (59cobalt)

Thu, 02 Feb 2012 12:52:11 GMT

Apparently you do get an error there, so you should add some debugging code to find out what the error is: ' some code On Error Resume Next ' problematic command If Err.Number <> 0 Then WScript.Echo Err.Description & " (0x" & He

Re:Help with PST copy (59cobalt)

Thu, 02 Feb 2012 12:49:26 GMT

Use FileSystemObject instead of WMI and spare yourself a lot of hassle.

Re:Flow control issue resulting in WMI object error... (Niceman)

Thu, 02 Feb 2012 09:22:03 GMT

Hey there, thanks for your reply, looks like I managed to suss it out, I just put the Cancel argument in before the OK stuff happens. :) Now if only I could have that input box inline with the MsgBoxes, it always pops up too high and I added , x300

Re:Beats me - Help needed with folder object and output redirection (sun1010)

Thu, 02 Feb 2012 08:21:43 GMT

Just an update. I added "On Error Resume Next" just inside the For Each, and now it's going forward to the next folder. Although it's printing a few lines of "No", I guess I can debug that.

Re:Beats me - Help needed with folder object and output redirection (sun1010)

Thu, 02 Feb 2012 08:13:18 GMT

Dear 59cobalt, Thanks a ton. A logical error on my part. Thanks for your help. You are a star.. :) I've taken care of that now. However, the very next bump is that, after deleting the empty folder, it's printing that it has deleted the folder

Help with PST copy (timassin)

Thu, 02 Feb 2012 06:39:14 GMT

Hello All, I'm trying to create a script that will search the local machine for all .pst and .ost files then copy them into another folder. Once they are copied over to another folder I can use a robocopy script to copy all the files from that folder t

Re:Beats me - Help needed with folder object and output redirection (59cobalt)

Thu, 02 Feb 2012 06:17:03 GMT

The problem is, whenever it is encountering the very first empty folder, it is deleting it, and then immediately exiting out of the script without printing anything. So basically at the first sign of empty folder the script is simply dying