setting a data type in excel

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ VBscripts
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Copy an image Hi I want to create an Excel instance, copy a picture from my html page and paste it into the Excel instance. Is this possible? Se example below of what I'm trying to do (the copy part doesn't work though): Dim xlApp Dim xlW Dim xlS Set xlApp = CreateObject( "Excel.Application" ) Set xlW = xlApp.Workbooks.Add Set xlS = xlW.Worksheets.Add myPicture.Copy xlS.Paste Regards PO Tag: setting a data type in excel Tag: 171511
  - 2
    - Unlock Is there a way to run a VBS script when someone unlocks there computer? For example, if someone leaves for lunch, they typically will lock their computer screen. Is there a way to run a script when the computer screen becomes unlocked? Tag: setting a data type in excel Tag: 171508
  - 3
    - Identifying a USB drive by letter How can I tell if a drive letter refers to a USB drive? I need to differentiate between the kinds of removable drives (USB memory stick, PCMCIA card, etc.). -- Your email is being returned due to insufficient voltage. Tag: setting a data type in excel Tag: 171506
  - 4
    - VBscript Search and Replace conundrum I have an application where the INI files are "dumb" and always write the path c:\ to a couple of INI files. "vwcmim.ini" and "vwgsmm.ini" in the windows directory. I want to list drives (like xternal), check them for data directory, and if it's found replace c:\ with <drive:\> in the INI files. I've got to the point where it does process the files but instead of putting in the drive letter it just erases the old drive letter c: with a null string. I am wondering what I'm doing wrong, or if anybody's got a better idea for simple file text search/replace. VBscript code follows. It has to run from a command prompt using cscript <scriptname> ' This script finds and replaces the drive C: with the correct drive letter in the ' INI see below (see SubFolder) ' This allows vACBI to run even where the data drive letter is not c: ' Owen Gilmore - owen.gilmore@united.com ' aogilmore@sbcglobal.net ' 7:20 AM 1/10/2005 Option Explicit Dim WshProcessEnvironment Set WshShell = WScript.CreateObject("WScript.Shell") Set WshProcessEnvironment = WshShell.Environment("Process") 'Define Object Variables Dim FSys Dim xFolder Dim xFiles Dim xFile Dim tFile Dim wshShell 'On Error Resume Next Dim strComputer Dim objWMIService Dim colItems Dim objFSO Dim objShell Dim strmsg Dim u_Drv Dim u_MedPath Dim objItem Dim EnvWinDir ' Define Working Variables Dim SubFolder Dim FileText 'Get some necessary environment variables EnvWinDir = WshProcessEnvironment("windir") 'Define Constants CONST U_File1 = "vwcmim.ini" CONST U_File2 = "vwgsmm.ini" Const ForReading = 1 Const ForWriting = 2 Const TristateUseDefault = -2 'On Error Resume Next strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set colItems = objWMIService.ExecQuery("Select * from Win32_LogicalDisk") Set objFSO = CreateObject("Scripting.FileSystemObject") Set objShell = CreateObject("WScript.Shell") u_MedPath = "\United\VWCMI\DATA" For Each objItem in colItems strmsg=strmsg&"DeviceID: " & objItem.DeviceID&vbcrlf If objFSO.FolderExists(objItem.DeviceID & u_MedPath) Then u_Drv = objItem.DeviceID End If SubFolder = EnvWinDir 'Verify that the script runs in console mode If UCase(Right(WScript.FullName, Len(WScript.FullName)-InStrRev(WScript.FullName,"\"))) <> "CSCRIPT.EXE" Then Set wshShell = WScript.CreateObject("WScript.Shell") wshShell.Run "CSCRIPT.EXE " & WScript.ScriptFullName, 1, False Set wshShell = Nothing WScript.Quit End If 'Set Objects Set FSys = WScript.CreateObject("Scripting.FileSystemObject") Set xFolder = FSys.GetFolder(SubFolder) Set xFiles = xFolder.Files WScript.Echo SubFolder WScript.Echo "Directive to process " & xFiles.Count & " files." 'Parse Each file and perform replacements For Each xFile in xFiles if xFile.Name = u_File1 OR xFile.Name = u_File2 Then WScript.Echo " --> " & xFile.Name WScript.Echo " Reading in contents" WScript.Echo u_Drv Set tFile = xFile.OpenAsTextStream(ForReading, TristateUseDefault) FileText = tFile.ReadAll tFile.Close WScript.Echo " Performing Replacement" & FileText & " with " & u_Drv FileText = REPLACE(FileText, "C:", u_Drv) WScript.Echo " Saving new file" Set tFile = xFile.OpenAsTextStream(ForWriting, TristateUseDefault) tFile.Write FileText tFile.Close Else WScript.Echo " --> " & xFile.Name & " NOT APPLICABLE" ' FileText = "" End If Next Next 'Clean Environment and exit On Error Resume Next Set tFile = Nothing Set xFolder = Nothing Set xFiles = Nothing Set xFile = Nothing Set FSys = Nothing -- MSI packaging Scripting Deployments Tag: setting a data type in excel Tag: 171501
  - 5
    - vbscript comit changes to active directory I need to know how to make a change in a field and comit it back into active directory. This is code that I am using. I def NEED to have the userPrincipalName to get the current logon user in the query, and change just his profile path. Any ideas??? Thanks '----------------------------------------------------------------- Option Explicit Const ADS_SCOPE_SUBTREE = 2 'these next 4 strings aren't very necessary but it makes it look cleaner 'towards the end Dim strName Dim strProfile Dim strHomeDrive Dim strHomeDirectory Dim strDistinguishedName Dim strlogon 'strprofile will error on a null value so I am Dim rs Dim cnn Dim cmd Dim objuser Set cnn = CreateObject("ADODB.Connection") Set cmd = CreateObject("ADODB.Command") ' Open the connection. cnn.Provider = "ADsDSOObject" ' This is the ADSI OLE-DB provider name cnn.Open "Active Directory Provider" ' Create a command object for this connection. Set cmd.ActiveConnection = cnn ' Compose a search string and replace DC=YourDomain, DC=COM cmd.CommandText = "select name, distinguishedname, profilepath, homedrive, homedirectory, userPrincipalName" _ & " from 'LDAP:// OU= NY, DC=FFHSJ, DC=COM' WHERE objectCategory='user' And objectCategory='person' and userPrincipalName='wahidta@ffhsj.com'" cmd.Properties("Page Size") = 1000 cmd.Properties("Timeout") = 30 cmd.Properties("Searchscope") = ADS_SCOPE_SUBTREE 'search all containers cmd.Properties("Cache Results") = False Set rs = cmd.Execute '------------------------------------------------------------------------------ Tag: setting a data type in excel Tag: 171499
  - 6
    - Import Access DB Can VBScript be used to import data into MS Access? I have searched the web and have not been able to find anything. If someone could point me in the right direction, I would appreciate it. Thanks Tag: setting a data type in excel Tag: 171498
  - 7
    - vbscript help OK im trying to update the user profile of people that are logged on to the machine. I was hoping to use something like the logon_user = Request.ServerVariables("LOGON_USER") that we can use in .NET but if not thats not a problem I know i can get it from registry. But if anyone knows how can you please give me an example. Now Im using the following code to query a perticular user in active directory. But I need to modify the user profile '--------------------------------------------------------------------------------------- Option Explicit Const ADS_SCOPE_SUBTREE = 2 Dim strName Dim strTSProfile Dim strTSHomeDrive Dim strProfile Dim rs Dim cnn Dim cmd Dim objuser Set cnn = CreateObject("ADODB.Connection") Set cmd = CreateObject("ADODB.Command") ' Open the connection. cnn.Provider = "ADsDSOObject" ' This is the ADSI OLE-DB provider name cnn.Open "Active Directory Provider" ' Create a command object for this connection. Set cmd.ActiveConnection = cnn ' Compose a search string and replace DC=YourDomain, DC=COM cmd.CommandText = "select name, distinguishedname, profilepath, homedrive, homedirectory, userPrincipalName" _ & " from 'LDAP:// OU= NY, DC=FFHSJ, DC=COM' WHERE objectCategory='user' And objectCategory='person' and userPrincipalName='wahidta@ffhsj.com'" cmd.Properties("Page Size") = 1000 cmd.Properties("Timeout") = 30 cmd.Properties("Searchscope") = ADS_SCOPE_SUBTREE 'search all containers cmd.Properties("Cache Results") = False Set rs = cmd.Execute MsgBox "done" '------------------------------------------------------------------------------------- How can I use the recordset to make a change on that field and comit it back to active directory?? Thanks. Tag: setting a data type in excel Tag: 171497
  - 8
    - How to seach for a text inside a file Hi All, I' trying to find an specific word inside a file .I'd like to give my script a wild card(*.txt) and a word or phrase in the file (exactly like what widows dose) and find the files on my computer.Is it possible to do it in vb script? Thanks Tag: setting a data type in excel Tag: 171495
  - 9
    - LDAP query help I'm trying to get the user logon name out with a query from Active Directory. Whats the field name. I cant find it anywhere. I tried logon, logonname, userlogon, login, loginname, etc. cmd.CommandText = "select name, distinguishedname, profilepath, homedrive, homedirectory, xxx" _ & " from 'LDAP:// OU= NY, DC=FFHSJ, DC=COM' WHERE objectCategory='user'" Can someone help me out with what to put in the xxx to get the user logon field from active directory? Thanks. Tag: setting a data type in excel Tag: 171490
  - 10
    - ADO-Security Warnings accessing Datasource Hi, Im writing an asp site using vbscript. It accesses my SQL-Server through an ODBC-Datasource that is defined on the IIS. The code is set Conn = CreateObject("ADODB.Connection") Conn.open "DSN=XXX;UID=YYY;pwd=ZZZ" Set RS = CreateObject("ADODB.Recordset") sql = "SELECT * FROM tblMyTab WHERE Col1='Test'" RS.open sql, conn msgbox RS.fields("Col2") RS.close I'm using this code twice: (1) Once in the main procedure that is executed everytime the page ist displayed and a second time (2) in a sub that is called by an on_click event. In both cases it works correctly, but: Only in case (2) there come up two messages (translated): "ADO-Security Warning: This website uses an dataprovider who is prabably not secure. If you trust the website, click OK, otherwiese click cancel." and thereafter "ADO-Security Warning: This website is using your identity while accessing a datasource. If you trust the website, click OK, otherwiese click cancel." Does anyone know how to prevent this messages? Why do they only come up in (2)? Thank you in advance! Marco Tag: setting a data type in excel Tag: 171486
  - 11
    - Programmatically adding a footer and toc to word document using vbscript Is it possible to programmatically add (using vbscript) a footer & toc to a word document once it has been created and saved? Can anyone give me some example code please? Ta. Tag: setting a data type in excel Tag: 171480
  - 12
    - Digitally signing macros Hi! I've created a couple of macros that I'd like to digitally sign. I just want to issue a certificate myself and use that so the security level can remain at "High". I've used selfcert.exe to create a certificate but when I sign the macro and save my template I get an error: "There was a problem with the digital certificate. The VBA project could not be signed. The signature will be discarded." How can I solve this?? Thanks in advance. Morten Tag: setting a data type in excel Tag: 171474
  - 13
    - Counting Files In A Folder Hi I need to count the number of iles in a folder. I have amended a script I found: This is fine but it will not do subdirectories Please can someone assist? strComputer = "." Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colFiles = objWMIService. _ ExecQuery("Select * from CIM_DataFile where Path = '\\currency\\'") For Each objFile in colFiles 'Wscript.Echo objFile.Name count1 = count1 + 1 'Wscript.Echo count1 Next Wscript.Echo count1 Tag: setting a data type in excel Tag: 171473
  - 14
    - How to close Internet Explorer ? I am running this script (from a .vbs file) to reboot a router using the web interface... Set g_shell = CreateObject("WScript.Shell") g_shell.Run "iexplore http://admin:my_password@123.123.123.123/setup.cgi?todo=reboot" It works, but how do I close IE afterwards ? Thanks, Craig Tag: setting a data type in excel Tag: 171472
  - 15
    - VBscript and Visual Basic I only know a little about both VBscript and Visual Basic. I have written a few vbscripts that i would like to add a gui to. Can any one tell me if i can simply make up a visual basic window (form) and run the script with some text boxes and buttons. thanks in advance *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: setting a data type in excel Tag: 171471
  - 16
    - Exchange Name Change Exchange server name on outlook 2000/2003 Thank you Tag: setting a data type in excel Tag: 171468
  - 17
    - Sound Recording with VBScript Hi there, does anybody know how i can record sound within vbscript? Many thanks to you. Ulrich Tag: setting a data type in excel Tag: 171467
  - 18
    - Wscript.Echo error in VBS Embeded in HTML Hi All: I have a script that I am writing that is basicly an HTML file with embeded VBS Coding. I am basicly designing the script so that it uses a small browser to open and have the user input an User ID & Server name (Via Text Input boxes) and when the click the submitt button the script goes off and verifies that a user folder is not on a share, and then creates it, shares it, permissions and reports to a log any errors. Now here is my problem. All of my VBS code is located in one big sub routine that is called when the user clicks the button in the browser. Now any time that I try to access anything with Wscript (Wscript.sleep or Wscript.echo) If give me an error stating "Object Required: Wscript". Any suggestions on how to avoid this so that I can use the wscript object. Thanks Lost Tag: setting a data type in excel Tag: 171442
  - 19
    - Reading and displaying records from a table in a database with vbscript? Okay I have a script straight from the windows 2000 scripting guide that shows me how to connect to a database. This I have done. What I'm trying to do is connect to an access dbase and read a tables contents and display each record, or at least assign them to variables in vbs so that I can use them to create accounts. So far I have this. ********************************************************************* const adopenstatic=3 Const adlockoptimistic=3 Const aduseclient=3 Set objConnection=CreateObject("ADODB.Connection") Set objRecordset=CreateObject("ADODB.Recordset") objConnection.Open "DSN=testdb;" objRecordset.Cursorlocation=aduseclient objRecordset.Open "SELECT * FROM main" , objConnection, adopenstatic, adlockoptimistic wscript.Echo objrecordset.recordcount objrecordset.close objconnection.close ************************************************************************ I have been all over the web looking for info about this but I must be searching on the wrong things. Can someone help me out or at least point me in the right direction? Thanks Jason Tag: setting a data type in excel Tag: 171434
  - 20
    - Multiple Column Lookup - Dictionary Object? Hello. I'm trying to come up with a solution for a lookup which contains multiple columns. I read somewhere (can't find the article/solution) that a dictionary can contain an array. I was trying the following code but receive the following error: "Subscript out of range" 'myarray'". Any help is appreciated. Also if anyone knows an easier way... ---------------------------------------------------- Dim objDict Set objDict = CreateObject("Scripting.Dictionary") ReDim myarray(2) objDict.add "cat", myarray("a", "b", "c") objDict.add "dog", myarray("d", "e", "f") objDict.add "pig", myarray("g", "h", "i") ---------------------------------------------------- Thanks in advance, -Jim Tag: setting a data type in excel Tag: 171432
  - 21
    - URL limit exceeded Hello! I have exceeded the length of the URL limit. I have a form where I send data using GET method. Now I have to change method of posting data into POST method. But please tell me how to get data after passing them, because when I call request.querystring("field1") it doesn`t work in the post method. Please help, I will be grateful for help Marcin from Poland Tag: setting a data type in excel Tag: 171426
  - 22
    - Error Checking in Logon Scripts I am not new to scripting but I am new to logon scripts. As a rule just how verbose should I let my logon scripts get? Currently I am doing most everything in vbs and a couple are .wsf. I am doing eror trapping and logging, (event logs, logging) now, is there a point where it becomes counter productive? Also is there a general preference for logon and GP scripts vbs or wsf? Tag: setting a data type in excel Tag: 171422
  - 23
    - .vbs vbscript query a sql server database Hi, I need to query a database and get one field out "ie full name". Its a sql server 7.0 (I also have the database housed in an 8.0 (2000) database) Can anyone help with code examples. How to make a connection to a database from a vbscript. Thanks. Tag: setting a data type in excel Tag: 171420
  - 24
    - search engine safe urls Hey, Anyone seen a good solution for Search Engine Safe URLs with Classic ASP? I've been looking for a while and short of using the 404 or installing tool on the server (for URL rewriting) I was hoping there might be something else. In ColdFusion you can do a http://server.com/myfile.cfm/id/410 and it just works ... Thanks, :rob Tag: setting a data type in excel Tag: 171412
  - 25
    - Log file size tempoary event cosumer. Hello, Independent of the log file properties (things like specifying log file size, overwrite events, etc.) I'd like to create a temporary event consumer with vbscript to monitor log file size and send a message box to the user notifying them a given log is filling up. I searched Microsoft's website looking for event ID's related to EventLog. The only event ID I found for which I would monitor is 6000, The %1 log file is full. While this is a good start, I'd like to notify the user BEFORE the log gets too big... To me this is kinda like the oil pressure light in a car. As a warning light, that light is mostly useless because if it goes off for a real reason, chances are engine damage has already occurred. I looked in the Performance monitor for a counter object related to log file size and could find anything either. At any rate, does anyone know if a percentage of log file size can be actively monitored? Thanks!!! Tag: setting a data type in excel Tag: 171408
- Next
  - 1
    - Re: Aaagh! cScript no longer Returning! ?? Sorry, Just again : as you can see, forcing cscript instead of wscript does not have any effect:-- ---------------------------------------- C:\> cscript.exe //H:CScript C:\inetpub\AdminScripts\mkwebdir.vbs -c localhost - w "Default Web Site" -v "adminDir","C:\MyDir" Microsoft (R) Windows Script Host Version 5.1 for Windows Copyright (C) Microsoft Corporation 1996-1999. All rights reserved. 3/10/2005 3:46:16 PM : Accessing root for IIS://localhost/W3svc/1 3/10/2005 3:46:16 PM : Done. --------------------------------------------- Thanks! Tag: setting a data type in excel Tag: 171402
  - 2
    - Re: Aaagh! cScript no longer Returning! ?? Sorry, Just again : as you can see, forcing cscript instead of wscript does not have any effect:-- ---------------------------------------- C:\> cscript.exe //H:CScript C:\inetpub\AdminScripts\mkwebdir.vbs -c localhost - w "Default Web Site" -v "adminDir","C:\MyDir" Microsoft (R) Windows Script Host Version 5.1 for Windows Copyright (C) Microsoft Corporation 1996-1999. All rights reserved. 3/10/2005 3:46:16 PM : Accessing root for IIS://localhost/W3svc/1 3/10/2005 3:46:16 PM : Done. --------------------------------------------- Thanks! Tag: setting a data type in excel Tag: 171400
  - 3
    - Re: Aaagh! cScript no longer Returning! ?? Hi Frank, This does not make any difference. Its very odd. It seems to be XP machines that cause this to hang. The weird thing is that it used to work a treat, and for some reason since the begining of this year it has never ever returned! I was redirecting to a file in terms of cscript.exe <cmdpath> <options> >>c:\install.txt and I thought perhaps it was a write protected c:\ issue. so I removed that. Here's what I am doing - this is straight from a cmd.exe prompt: Interesting: if you look, the first time I tried it I miss-spelled the .vbs script, and cscript did actually return OK. The next time I typed the correct .vbs file, and it never returned; ---------- C:\>cscript.exe C:\inetpub\AdminScripts\mkwebd-ir.vbs -c localhost -w "Default Web Site" -v "adminDir","C:\MyDir" Microsoft (R) Windows Script Host Version 5.1 for Windows Copyright (C) Microsoft Corporation 1996-1999. All rights reserved. Input Error: Can not find script file "C:\inetpub\AdminScripts\mkwebd-ir.vbs". C:\> C:\>cscript.exe C:\inetpub\AdminScripts\mkwebdir.vbs -c localhost -w "Default Web Site" -v "adminDir","C:\MyDir" Microsoft (R) Windows Script Host Version 5.1 for Windows Copyright (C) Microsoft Corporation 1996-1999. All rights reserved. 3/10/2005 3:37:40 PM : Accessing root for IIS://localhost/W3svc/1 3/10/2005 3:37:40 PM : Done. ---------- here you see that the c:\> prompt never comes back. Have Msoft changed their vbs files recently or for XP ??? Please Help! Tag: setting a data type in excel Tag: 171399
  - 4
    - Convert binary file to text file? HI! Is possible convert a binary file to text file? Tag: setting a data type in excel Tag: 171398
  - 5
    - Runtime Error Hi! I use the following lines to open a window in IE and insert the text "Invoice no." into Sp1 (an OWC Spreadsheet component imbedded in KFAKT.htm): Dim wnd Set wnd = window.open("KFAKT.htm", "") wnd.Sp1.Range("B10").Value = "Invoice no." Most of the time the code works but sometimes I get an error message - "Object doesn't support this propery or method: 'wnd.Sp1'". Any ideas? Regards PO Tag: setting a data type in excel Tag: 171397
  - 6
    - Set windows file permissions Hi All I have recently changed to a windows 2003 web server and I previously used the ADsSecurity object to set folder permissions on webs that were created using vbscript. Now, I get a cannot create object error and I assume this is because the ADsSecurity.dll does not exist on windows server 2003. I was wandering if I should register this dll with 2003 and if my code should then work or if there is a new way of doing things with windows server 2003. Any advice would be truly welcomed. Thanx in advance Joe Tag: setting a data type in excel Tag: 171391
  - 7
    - Copy and install I need to copy a folder from the network with a program in it. After it has been copyed to the C: it must run the setup file. I can copy it, but cant find the right command to get it to run. Here is my script: ------------------ Set fs = CreateObject ("Scripting.FileSystemObject") fs.CopyFolder "\\Ask\Programmer\NetscreenKlient", "C:\NetscreenKlient" ws.Run ("C:\NetscreenKlient\Setup\setup.exe") ------------------ The ws.Run command is where the error is. What should i use instead. Or do anyone have another way to do this. Best regards Jesper Denmark Tag: setting a data type in excel Tag: 171389
  - 8
    - Tag Base Dear All, i have used the tag base in the head of my page ; <base href="http://yazeed/123/" /> . and my apllication is on "http://Default/" all the images and swf files worked properly , but the problem is that i have a javasript method "window.open(mypage.html)" but it didn't take the effect of the base ; the page opened is "http://Default/mypage.html" instead of "http://yazeed/123/mypage.html" . Anyone can help ???? -- Yazeed .net Developer(c#) -- Yazeed .net Developer(c#) Tag: setting a data type in excel Tag: 171387
  - 9
    - 2 dimensional array Please can anyone help me!! I want to read the contents of a text file into a 2 dimensional array. Each line will have 6 colums of data separated by a comma. So far I,ve got ............ Do Until objTextFile.AtEndofStream strNextLine = objTextFile.Readline MyArray = Split(strNextLine , ",") Loop ..but this is just a 1 dim array ....any pointers thanks in advance *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: setting a data type in excel Tag: 171386
  - 10
    - Export/Import Registry Across Machines Hello -- I have 5 serves at work that I need to duplicate registry setting on an ongoing basis. Essentially, server 1 will be my master server where my application makes all its changes. I would then like to run a script from server1 that exports the registry and automatically connects and imports the registry on server2, 3, 4, and 5. How can I connect to remote servers from a different server via registry and using .RegRead and .RegWrite from WSH or VB6? Any help or insight would be appreciated. Tag: setting a data type in excel Tag: 171385
  - 11
    - HELP!!!!!!!!!! I'm pulling my hair out here. I have an ASP page which causes an error when loading. The error is... *************************** Error Type: Microsoft VBScript runtime (0x800A01B6) Object doesn't support this property or method /intranet/default.asp, line 66 *************************** The procedure causing the problem in the default.asp page is ****************************************** Sub GetEvents() Dim oApp, clsD, vCls, clsE Dim sEvents Set oApp = Server.CreateObject("Calendar.clsApplication") Set vCls = oApp.GetCalendarMonth(Year(Date()), Month(Date()), vbMonday) For Each clsD In vCls If clsD.TodaysDate = Date Then If clsD.DoesDayHaveEvents Then For Each clsE In clsD %> <li><a href="EventDefault.asp?app=Calendar%20Events"><%=clsE.Title%></a></li> <% Next End If End If Next 'we will always have the last link %> <li><a href="EventDefault.asp?app=Calendar%20Events">Click here to view the calendar</a></li> <% Set clsD = Nothing Set vCls = Nothing Set oApp = Nothing End Sub ****************************************** The actual error line (Line 66) is the line that says:- For Each clsD In vCls This code actually works on our intranet and another developers machine, but does not work on my system (the main development machine) when I run //localhost/intranet/default.asp. When I comment out this routine, it does run. Does anyone have any ideas? Thx Tag: setting a data type in excel Tag: 171382
  - 12
    - Pass a Parameter from VB Script to Crystal All, I can't make my VB Script pass a parameter to Crystal. Have tried many different variations, per my commented out lines, but none work. Could some kind person please let me know what I am missing ...? Option Explicit On Error Resume Next Dim objCRApplication, objCRReport, objCRDatabaseTable Set objCRApplication = CreateObject("CrystalRuntime.Application") Set objCRReport = objCRApplication.OpenReport(myReport, 1) '------------------------------------------------------------------ 'HERE IS MY PROBLEM ....I WANT TO PASS A VALUE OF '123' TO CRYSTAL '------------------------------------------------------------------ 'objCRReport.ParameterFields.Item(1).SetCurrentValue "123" 'objCRReport.ParameterFields(0).AddCurrentValue("123") 'Dim strMyParmValue 'strMyParmValue = "123" 'objCRReport.SetParameterValue("Parameter1", strMyParmValue) '------------------------------------------------------------------ ' END '------------------------------------------------------------------ With objCRReport.ExportOptions .FormatType = 31 .DestinationType = 1 .DiskFileName = myOutputFile End With For Each objCRDatabaseTable in objCRReport.Database.Tables objCRDatabaseTable.ConnectionProperties("user id") = "user" objCRDatabaseTable.ConnectionProperties("Password") = "password" Next objCRReport.DiscardSavedData objCRReport.Export(False) Set objCRReport = Nothing Set objCRApplication = Nothing Set objCRDatabaseTable = Nothing Tag: setting a data type in excel Tag: 171378
  - 13
    - Transfer file from VBS via HTTP Hi! You know how VBS can transfer file via HTTP? Tag: setting a data type in excel Tag: 171377
  - 14
    - get proxyaddresses for all contacts of an OU using vbs & ADO Hello, I'm making a script to compare an export of an OU(csv) with the content of an OU. I saw approaches using ado or ldap. But using ADO i'm only able to connect to Rootdse and get the proxyaddresses attribute of all users. How can i filter down to the OU and afterwards get the contacts or user's proxyaddresses from that specific OU only? thanks Tag: setting a data type in excel Tag: 171375
  - 15
    - Blocking right mouse click to copy items on html internet page Dear, because I want to use some material on the internet site, but I plan to write a book too later, I would like to "secure" (a little) my data on my html pages, by giving a messagebox when the visitor gives a right mouse button click. I want to remove the copy menu and give a message such as "sorry, this material is copyrighted"... Any good idea's please ? Phil webmaster Official site 101st Airborne 463rd Parachute Field Artillery -- http://users.skynet.be/101airborne Tag: setting a data type in excel Tag: 171374
  - 16
    - xml /text-file issue Hi, I create an XML-file with a vb-script containing an AS database. This file I load in the Analysis Services dso/xml console. I create my file with VbS: Set objFSObject = CreateObject ("Scripting.FileSystemObject") Set objFile = objFSObject.CreateTextFile("dso.xml", 8, True) This works great as long as I copy all the content of my textfile into and replace all the content of a generated file from DSO/XML convertion utility. But if I try to use my file direct with the dso/xml console nothing happens. If start "my" XML-file with IE there is an errormessage and no text shows up, but if I replace the content of a generated file it shows up in a coorect and structured way. Is there different types of xml-files ? I thought that any text-file named .xml would work. /Jerome Tag: setting a data type in excel Tag: 171373
  - 17
    - Changing the name of MSI installed software I was wondering if anyone would know if it is possible to change the name of software in the Add/Remove software list. I have tried using set obj.Name = "Change the name" and set obj.Caption = "Change the name" I have a feeling that this is not scriptable. Thanks Tag: setting a data type in excel Tag: 171369
  - 18
    - How to Search C:\ to find a file Hi, I have found several scripts that will search for files as long as a folder name is provided as soon as I change it to C:\ I get permission errors. As I don't know where the file will be I need to search from C:\. Can vbscript do this? Tag: setting a data type in excel Tag: 171363
  - 19
    - Finding out when desktop is available I need to destermine within my vbs script when it is safe to start a function within my login script. It is only safe for me to do that once the users has entered his password and the "desktop" has appeared. If teh function that I have runs before the desktop has appeared it fails. I thought I could check to cul dstart my function once the explorer.exe process is running but that appears to be running before the desktop is up. What process or other identifier can I use to check so I can know it is safe to start my process in teh script ? Placing it in the start, rograms ..startup folde ris not an option for me. Thanks Tag: setting a data type in excel Tag: 171358
  - 20
    - Problem with a class I have created a class cReqPos in a file by itself I include the class file in a page that creates an instance of the class and do some stuff. That instance is in a Session variable: Session("ReqPos")= new cReqPos I submit that page to itself in several ocassions and the instance works fine, but when I submit it to a different page and try to access its properties, it fails: "Object doesn't accept that property or method". What am I doing wrong? Session("ReqPos") is still an object after submission, but somehow it loses the properties and methods. Thanks in advance Tag: setting a data type in excel Tag: 171350
  - 21
    - Customizing Word 2003 menubar I want to customize Word menubar from a macro. I would like to remove options like "Save As", "Open", etc... This because I will invoke Word from another application with the name of the file. I want the users to change the opened document and save it, with no other way of saving it somewhere else... Thanks Jacques Tag: setting a data type in excel Tag: 171348
  - 22
    - Script to see if a user is logged in via RDP I have a script that will tell you if a user is physically logged into a workstation, but if the user RDPs and logs onto the workstation it appears no one is logged in. Is there a way to tell via a script if someone is logged in via RDP to an XP workstation. Here is my script that works for a physical log in. On Error Resume Next Dim name Dim User(20) Dim wks(20) Dim comname(20) Dim strComputer(20) y = 0 For x = 1 to 9 if y < 9 then name = "computername-0" else name = "computername-" end if y = y + 1 comname(x) = name & y Strcomputer(x) = comname(x) Set objWMIService = GetObject("winmgmts:\\" & strComputer(x) & "\root\cimv2") Set colItems = objWMIService.ExecQuery("Select * from Win32_ComputerSystem",,48) For Each objItem in colItems wks(x) = objItem.Name user(x) = objItem.UserName Next Next For r = 1 to 9 if user(r) <> vbempty then Wscript.Echo wks(r) & " is currently in use by " & user(r) else Wscript.Echo wks(r) & " is available for RDP" end if Next Tag: setting a data type in excel Tag: 171345
  - 23
    - How to determine server role Hello, I have many servers in a win2003 domain. I would like to have a ADSI vbscript to determine the system role: like, Domain Controller, member server, further more WINS, DNS, DHCP roles even better. Thanks, Wensi Tag: setting a data type in excel Tag: 171344
  - 24
    - Display a picture in VBScript. Is it possible to display a picture with VBScript? I need a stand-alone script to run when users log onto a network of Windows 2000 clients. I want to display a picture of our usage policy which is longer than the Windows logon banner allows. Any help you can give is greatly appreciated. Tag: setting a data type in excel Tag: 171343
  - 25
    - Send email when password expires I have found the following code at the scripting centre but contine to get the following error when I try it: Line 12 char1 table does not exist. Can someone please help me with this? Set oConfig = CreateObject("CDO.Configuration") Set colFlds = oConfig.Fields colFlds("http://schemas.microsoft.com/cdo/configuration/sendusingmethod") = 2 ' cdoSendUsingPort colFlds("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "server ip address" colFlds("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 2 ' cdoNTLM colFlds.Update Set cnAD = CreateObject("ADODB.Connection") cnAD.Open "Provider=ADsDSOObject;" Set cmdLDAP = CreateObject("ADODB.Command") cmdLDAP.ActiveConnection = cnAD cmdLDAP.CommandText = "<LDAP://dc=netbios domain name>;(objectCategory=User);samAccountName,mail,userAccountControl;subtree" Set rsUsers = cmdLDAP.Execute Do While Not rsUsers.EOF sEmail = rsUsers("mail") If Len(sEmail) = 0 Then ' User has no email address, so no point in checking further Else If rsUsers("userAccountControl") And &h10000 Then ' ADS_UF_DONT_EXPIRE_PASSWD ' User is exempt from password expiration Else sUser = rsUsers("samAccountName") If Not IsNull(sUser) Then Set oUser = GetObject("WinNT://domain name/" & sUser & ",user") If oUser.UserFlags And 2 Then ' Account is disabled, so it doesn't matter Else iDaysLeft = (oUser.Get("MaxPasswordAge") - oUser.Get("PasswordAge")) \ 86400 If iDaysLeft < 14 Then Set oMsg = CreateObject("CDO.Message") Set oMsg.Configuration = oConfig oMsg.From = "mailadmin@ablao.ab.ca" oMsg.To = sEmail oMsg.Subject = "Password Expiration Warning" oMsg.TextBody = "Your password expires in " & iDaysLeft & " days." oMsg.Send End If End If End If End If End If rsUsers.MoveNext Loop rsUsers.Close cnAD.Close Tag: setting a data type in excel Tag: 171342

I am using code to put passwords into excel. I found that if a password
is all numbers that excel will save it as a number instead of as text.
Is there a way to programatically set some property so the cell will be
text instead of a number?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Top

Re: setting a data type in excel by Torgeir

Torgeir
Fri Mar 11 15:46:52 CST 2005

Erik Foreman wrote:

> I am using code to put passwords into excel. I found that if a password
> is all numbers that excel will save it as a number instead of as text.
> Is there a way to programatically set some property so the cell will be
> text instead of a number?
Hi

Add a ' in front of the value.

--
torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway
Administration scripting examples and an ONLINE version of
the 1328 page Scripting Guide:
http://www.microsoft.com/technet/scriptcenter/default.mspx

Top