Search results for query: *

Need some help to determine if an excel spreadsheet is open. If you attempt to open a spreadsheet (outside of a script) you'll receive a notice that the spreadsheet is open and have a choice to open a read only copy. I would like to offer the similar functionality in a vbscript. Basically, the...

I need a little help in a vb script to determine if a specific excel file is already open. Thanks

Need help adding sheets to a workbook after the last sheet. I can get a new sheet added but it is not the last sheet and the name I need. The code I'm using is below. What do I need to get this to work? Thanks Dim objXL,objBook,blnSiteFound blnSiteFound = False strFile =...

I need a little help in accessing different sheets in Excel. I have scripts to open and retrieve cell contexts located on the first sheet. How do I move to the next sheet?

Using script snippit below I need a way to determine if the grp parameter is a user or a group. Does anyone have a suggestion? Thanks Sub EnumGroupMembers(server,grp) Dim Group Dim Member On Error Resume Next 'Bind to a group object. Set Group = GetObject("WinNT://"+server+"/"+grp) If Err...

I can open wmimgmt.msc, go to Properties, then security and expose all the namespaces. After selecting a namespace I can select security and see the group/user names and permissions. What I am trying to accomplish is using a list of server names to audit WMI and enumerate the namespace...

I have a PC with XP Professional and VB.Net (standard) installed. After installing VB6 (Enterprise Edition) and rebooting I have a blank screen, no desktop icons and no access to the Start key. I'm back up an running, thanks to my ghost image. The question, can both applications run on the same...

I have a PC upgraded from Win 2000 Pro to Win XP Professional. Win 2000 was installed in "C:\Winnt" and Win XP has been installed in "C:\Windows". Can I safely delete the "C:\Winnt" directory"? Should the registry be cleaned of Winnt references and if so how...

While reviewing some sample code I noticed the use of ":" in the script. Once in the first DIM statement and then again in the "Set products" statement. I can not find any documentation on the use of ":". See Code below. And ideas? ' Connect to Windows Installer...

After modifying some code and during testing I was receiving errors in parts of the program uneffected by the code changes which should not have occured. The code changes were minor and have no effect on the operating system. I decided not to save the changes and rebooted. After rebooting, when...

When I click on the "Start" key (in Windows 2000 Pro), the key stays depressed and the menu does not appear. There is no problem using desktop icons or starting programs from task manager. I checked the event log and there are no errors. I have not installed any new applications or...

I am having a terrible time converting my VBScript to VB. The VB program basically consists of an input box (for server Name) and listboxs and a module for registry functions. The VBScript (see below) connects to a remote server and enumerates a key and returns values for two subkeys. I can...

I am using a listbox with checkboxes. I'm looking for a way to have the checkbox change its state (unchecked to checked or checked to unchecked) if a user clicks on an item. Silly of me to assume a checkbox and the item are treated as one object. Any help would be greatly appreciated.

I'm using InterDev 6 (sp5) on a W2K 2000 PC and I am getting an error "Library Not Registered" when setting up "Add Data Connection". I tried using Jet 3.51, ODBC and SQL Server with the same results. I created a new ODBC DNS file an used it successfully in Visual Basic...