Microsoft VBScript runtime error '800a01b6' Object doesn't suppor - createobject - order by pertinence

Can I access 64 bit integers through VBS?

I have a COM DLL written in C++, and one of the methods returns a "long long*". When I call this method from a vb script I get the error "Microsoft VBScript runtime error: Variable uses an Automation type not supported in ...

Message posted on the September 25th, 2012 - 5:57 PM ET

File browse quirks

I've used a simple IE window for file browsing for a long time. (More recently I've also been using the HtmlDlgHelper approach. But I have a lot of scripts iusing the IE method.) The basics: Q2 = chr(34) Browse = "" Set IE = ...

Message posted on the September 19th, 2012 - 9:56 AM ET

Blank item in listbox, how to remove

Hi, I am using the following code to populate a listbox from a range. This works great, unless there is only one item in the range. When there is only one item, that item shows in the listbox, but along with a Blank item. Any time there is more ...

Message posted on the January 28th, 2012 - 8:46 AM ET

error on sql when connecting thru vpn

Hi Sir, We have a system which is running thru SQL 2005. I bought a VPN Router so that our branch office can be able to connect thru our system. I have no problem connecting to our VPN and i can access our server. But, when I tried to access our ...

Message posted on the January 25th, 2012 - 1:28 AM ET

Windows Update KB951847 error codes 0x8070663, 0x663

In January of 2012 I did a reinstall of WinXP Pro SP2 from CD and updated to SP3, IE8 and all of the security updates suggested by the Windows UPDATE site. It's very laborious rebooting over and over as directed but everything worked just fine until ...

Message posted on the January 8th, 2012 - 5:26 AM ET

PlaySound error (Chip Pearson site)

At Chip's site the directions say to run this ListWavFiles code, which I did and it did list the sounds as per per instructions. Then per instructions (see below) run the PlayActiveCellSound code with a sound selected on the worksheet. This errors ...

Message posted on the March 11th, 2013 - 1:30 PM ET

Working with Word Documents from within an Excel Macro

Backgroud: The salesmen put workorders in on their iPads and my excel workorder goes out and gets that data and creates each workorder one at a time - placing all the data on the page, getting any maps and adding them to the workorder, etc. So - ...

Message posted on the March 8th, 2013 - 11:58 AM ET

Problem with VBScript

I wrote this code to play hidden music as a computer prank. Every time I try to run it I get an error. The code is: strSoundFile = "C:WINDOWSMedia[1].wav" Set objShell = CreateObject("Wscript.Shell") strCommand = ...

Message posted on the November 29th, 2012 - 10:37 PM ET

Help with command line options on external shell execute

Hi all I am having a problem that i haven't been able to resolve and I hope you can help. I am attempting to launch the following command from my vbscript and the script is erroring with the command line args for atomicparsley Set objShell = ...

Message posted on the November 18th, 2012 - 3:07 AM ET

Range.Find problem

Hello everyone, First time poster here, looking for some help with the following code: Code: Set dupRange = Range("B5:B33000") dupSearch = Cells(r, 2) Set dup = dupRange.Find(dupSearch) If dup Is Nothing Then Resume Next End If ...

Message posted on the November 15th, 2012 - 5:37 AM ET

Merging Macros

I'm an avid Word macro user, but usually stick to things I can record, rather than write. I have a four macros, all the same code with slight tweaks, that open an excel spreadsheet, find the words in column A, replace them with the words in column ...

Message posted on the November 7th, 2012 - 8:18 PM ET

Error message 1004

Hi all, i got macro (see on the bottom ) which supposed to copy chart from each workbook and paste into PowerPoint presentation. But when i run my macro i get error message saying (see below) Run-time error '1004': The specified dimension is not ...

Message posted on the November 5th, 2012 - 11:21 AM ET

Word Object Behaviour

As nobody seems to know how to force the object to work in UK English I thought I'd try a different approach: Again requires the Microsoft Word x.0 Object Library Where x could be anything, but I've tried 9 & 11 - Dim objWord As ...

Message posted on the November 2nd, 2012 - 4:16 AM ET

Nothing

Sub Include(ByVal includefile) Dim fso, s, f Set fso = CreateObject("Scripting.FileSystemObject") If fso.FileExists(includefile) Then Set f = fso.OpenTextFile(includefile, 1, False) s = f.ReadAll f.Close Set f = Nothing ExecuteGlobal s End ...

Message posted on the April 29th, 2012 - 5:08 PM ET