Answer Questions

• osamaT subscript out of range

  I am getting an error when running the script Do While (Not (Workbooks(bookmonth).Worksheets("by associate").Cells(4, i) = "dsl") Or Not (Workbooks(bookmonth).Worksheets("by associate").Cells(4, i) = "hsi")) I am uncertain why this is coming up. i is currently set to 1, so it should be starting to search in cell a1. thank you, there was an error in my code and it was not populating bookmonth correctly, however, I am now getting a type mismatch. How do I correct for this Hi, If i is currently 1 then are the other indexes correct What's in the variable bookmonth Is the sheetname really " by associate". Perhaps there is a extra space somewhere. I can not see any ...Show All

• prashant mulay "Bizzare" Sendkey Code in Excel

  Following is my code... Range("A1").Select 'Select cell A1 Application.SendKeys "BIZZARE{ENTER}", True 'Enters BIZZARE in A1 and focus goes to B2 Application.Wait (Now + TimeValue("0:00:02")) Application.SendKeys "{UP}", True 'Again focus on A1 Application.Wait (Now + TimeValue("0:00:02")) 'Range("A1").Select 'Just in case {UP} doesnt work Selection.Copy 'Path 1 Range("B2").Select 'Path 1 ActiveSheet.Paste 'Path 1 Application.SendKeys ("^C") 'Path 2 Range("B2").Select 'Path 2 Application.SendKeys ("^V") 'Path 2 My code wanted ...Show All

• Norbert Thek Automating PowerPoint

  I have a vba procedure within a ppt presentation that creates a new presentation with a set of slides and saves it. This process is repeated until about 30 different presentations are created, but I would like to automatically execute it at a specific time so I don't have to run the code manually everyday. Can you please suggest how I can automically execute my vba code to run thank You! Jenise Hello, Does anyone have any ideas on this It must be possible to do. thanks, Jenise Powerpoint, unlike excel and word, does not have AutoOpen routine unless the file is an addin. See Shyam Pillai's page for more details. AutoEvents Add-in for PowerPoi ...Show All

• Nicolas Humann using dll file

  I have created a dll file using VB.net. And I want to use the function of the dll file in VBA. How can I do it Thank you Hi, I've posted an entry in my blog about this Calling Managed Code From VBA Thank you for your help. Now, it works fine again in my computer by creating a strong key. and I do the same procedure in the other computers. one of them works fine too. however, the others cannot work. the error "runtime error automation error" occurs. I have installed my DLL  the GAC.But there is still the error. BTW, I have built a simple dll to display helloworld. The same error still occurs in those computer. e.g Set h = New HelloWorld I suspect ...Show All

• imran ud din "Bizzare" Sendkey Code in Excel

  Following is my code... Range("A1").Select 'Select cell A1 Application.SendKeys "BIZZARE{ENTER}", True 'Enters BIZZARE in A1 and focus goes to B2 Application.Wait (Now + TimeValue("0:00:02")) Application.SendKeys "{UP}", True 'Again focus on A1 Application.Wait (Now + TimeValue("0:00:02")) 'Range("A1").Select 'Just in case {UP} doesnt work Selection.Copy 'Path 1 Range("B2").Select 'Path 1 ActiveSheet.Paste 'Path 1 Application.SendKeys ("^C") 'Path 2 Range("B2").Select 'Path 2 Application.SendKeys ("^V") 'Path 2 My code wanted ...Show All

• Joe Buys VBA registry interface

  I would like to be able to write to and read from the registry given a specific address in the registry to write to. Ultimately, I want to be able to distribute a ms excel program with the understanding that it is a 2 week trial and I would like to enforce that in some way where it is not easily gotten around. I would also like to put a check so that the customer does not distribute the spreadsheet to other people. If there are other ways of doing this other than interfacing with the registry that would work well, I would be more than open to suggestions. Derek Smyth wrote: I'm going to disagree with duckthing about using the registry. It's fairly easy to add keys to registry without needing to write an installer. You can ...Show All

• Michael Cummings When sending a worksheet to the USB port …

  Hey, When sending a worksheet to the USB port … (memory stick). How do I detect if the memory device is not in the USB port …. and how do I handle the error if its not there Best Regards Cathrine Hey ADG Great thanks for the help! I did some modification to your code so it suits my application… it works fine. Cath Hey Derek Thanks for your reply. I have a workbook that I want to save to a memory stick. How can I write the code so it will detect witch drive letter the USB have Cath Dim fsoObj As Scripting.FileSystemObject Set fsoObj = New Scripting.FileSys ...Show All

• tkroll Error on Archive Acivation

  Hello, i tried to install LCS 2005 Standard on my Virtual Server (VMWare ;o) Sorry) and i have an error during the activation of the archiving service. I'm on a Windows 2003 Server Standard, all updates installed. There's only this server, it have all rules et AD is installed. I follow the instructions in LCS_2005_Deploy_SE.doc, i made this: 1) Installation of LCS files 2) Activation without MSMQ (MSSQL ) 3) Installation of MSSDE, i can see in Services MSSQL$RTC started 4) I never find MS03-031 patch 5) Activation of archiving service :: Error 0xC3EC783D I restarted the server but same error. So i decided to make different: 1) Installation of LCS files 2) Installation of MSSDE, i can see in Services MSSQL$RTC started 3) MS03-031 patch in ...Show All

• zeroguitar Disable Shift Key Before Startup

  I was wondering if there was a procedure or function call before the startup for Access 2003. Reason: I would like to disable the shift key if the current user that is logged into windows is not in a table that has windows usernames stored in it. Is this possible to do or must I lead in a different direction. I have been looking everywhere for an answer and nothing like this has arised. Note: I cannot just have two copies (one for me and one for users). Goto Tools > Startup and then uncheck the "special key" checkbox. Please explain your answer. I am unsure what that has to do with my question. ...Show All

• Haroonm Unable to infopath form in browser

  ERROR: The form cannot be displayed in the browser because the use of session cookies has been disabled in the current browser settings. In order to load the form, session cookies must be allowed. Any pointers would be appreciated I experience exactly the same problem. Funny but it worked with Firefox! It didnt work with IE6 and IE7. Tried both. The Privacy and Security settings were set correctly. I checked this a couple of times. I have the exact same error when trying to connect to some Sharepoint 2007 infopath pages which are in the Local Intranet Zone. Path: WrkTaskIP.aspx ID=2&List=87365a5d-e84f-42fb-9244-28abe8dfbee9&_InfoPath_Sentin ...Show All

• Tyrone Fay Get Current Slide Number And Insert a New Slide

  I've recorded a macro to perform certain formating to slides in a ppt 2003 show. I would like to enhance it by having it insert a new slide after the current slide (as the standard action with CTRL+M) When I record the macro, however, the slide number being inserted is hardcoded - I want the macro to insert after the now current slide. When I record inserting after slide #2, the applicable macro line reads: ActivePresentation.Slides.Add(Index:=3, Layout:=ppLayoutText).Select How can I get the macro to determine the "current" slide # and change that index:=3 to the apprpriate numebr (or variable containing that number TIA Have a look at this page, which includes ...Show All

• Antioch Efficent Way to manage multiple textboxes (maybe a loop?)

  This might be really easy, or maybe it's really hard I'm pretty new to VBA I'm using the VBA editor in Excel 2003 to automate some data entry into a spreadsheet. I have several userforms all with various numbers of textboxes, the largest having 34. What I am trying to do is use some sort of loop to clear the value out of each textbox when the user creates a new record. I want to do this mostly because I’m lazy, but also because I foresee the need to be able to expand this later. I’m trying to avoid the following situation: With userform1 .TextBox1.value = "" .TextBox2.value = "" .TextBox3.value = "" [etc…] End With I’ve ...Show All

• esb Is There a VBA Documenter

  Wondering if anyone knew of any FREE Documenting software out there for vba. Other than the one in Access. I don't like Access Documenter because it doesn't show methods I am looking for a documenter similar to this style: ClassModuleName: Public FunctionName () as VarType Private MethodName () Public MethodName2 () ClassModuleName2: Public FunctionName () as VarType Private MethodName () Hi, I don't think there is one, or at least I haven't came across one. You can create your own though fairly easily using the code example at this link... http://www.cpearson.com/excel/vbe.htm Try Rob Bovey's Code Documentor. http://www.appspro.com/Utilities/Documentor.h ...Show All

• Jimbooooooooo Visio VBA Macro to detect connector endpoints

  Hi guys, My question is this, in visio vba how do you determine what shapes the connectors are pointing to I want to know the shape that is the starting point for a connector and the shape that lies at the end point of the connector. I see that in the shapesheet you can obtain X,Y location information. However, if you were to connect at different points on a shape, that information would change and this would not be a possible solution for determine which shapes connectors are connected to. I can output the shape names like below, however I cannot determine which shapes dynamic.connector.14 (or any connectors for that matter) is connected to. I dont see any fields in the shapesheet that indicate this type of relationship between shapes an ...Show All

• ronlahav Audio/Video streams encryption in Office Communicator Version 1.0

  Hi, I have some questions about Audio/Video encryption in Office Communicator Version 1.0 and hope that someone can give me some idea. For two OC, if we want to encrypt the audio/video RTP traffic, the encryption key is sent over the SIP signaling channel. If encryption is required for audio/video streams, something like: k=base64:PlUeTaTiRmnMNdXkxwpSkjy4UvQkUwZGUxqLLrdK60I a=encryption:required will appear in the media description part of the SDP in the SIP message. It is said that OC version 1.0 uses DES CBC at 56bits. The k= field contains an auto-generated pass phrase. The real key is generated by following the string to key mapping algorithm specified in RFC1890. Now here comes my questions: 1, Is this a RTP sending key or a receivin ...Show All