Answer Questions

• jaczura Control Break Trap will not work whilst Userform is displayed

  Hello All, In Excel I have statement Application.OnKey "^{BREAK}", "Sub_Trap_Break" This is okay at all times when there is no Userform being displayed but when there is a form this does not work. Any ideas how to overcome this I am trying to stop users get to the spreadsheet. To stop this I have: 1) Form event Query Close 2) The sheet only becomes visible when macros are enabled otherwise it is xlVeryHidden 3) The cells font and background colours are the same so nothing can be seen ! and it is protected at the appropriate times 4) Menus are disabled But that fact that on control Break (when a form is displayed) the VBE window appears is irritatting, any ideas (No code is displayed as t ...Show All

• code_junkie Storing a Scorecard Manager diagram in a database

  Hi everybody, I want to use Microsoft Office Scorecard Manager for strategy Map but I'm not sure whether it satisfies my requirement. I want to draw a strategy map and store it in a database in a way that its attributes including parent-child relationship and the name of node are save in the database so that I be able to query of these information and connect them to the external attributes. Could you please tell me whether Scorecard Manager is a good candidate for my purpose. I also just found out that in Office 2007, there is a PerformanceServer tool which can de used for this purpose. Any experience is welcome. Thank you for your help, Rasoul Karimi Per the engineer: More i ...Show All

• ykgreene Send Outlook message via VBA Macro in Excel

  I have some macro code in an Excel workbook. It has been working fine for several years under various combinations of Excel 97, Excel 2000, Excel 2002(XP) and Excel 2003 along with Outlook 97, Outlook 2000, Outlook 2002(XP) and Outlook 2003. We have one new computer that has Office 2003 (SP2) that was recently setup and the macro generates the following error: Run-time error '-2147024770(8007007e)': Automation error The specified module could not be found. Here is the VBA code in the Excel Macro.  The error happens when it reaches the line that reads: Set theApp = CreateObject("Outlook.Application") .  I tried to run the macro on two other Office 2003 SP2 computers and they worked OK, which shot my theory that ...Show All

• TobsTec OnChange ?

  I'm looking for the proper way to trigger a sub when the value in a cell changes. Any suggestions Thanks K-2 Hi K-2 Try using the Worksheet change event, checking the target value to see if your cell is in the range that has been changed Private Sub Worksheet_Change(ByVal Target As Range) Dim myR As Range Dim Resp, c Set myR = Worksheets("Sheet1").Range("A3") For Each c In Target If c = myR Then Resp = MsgBox("A3 has been changed", vbOKOnly) End If Next End Sub The code is in a worksheet event. In the VBA project select the relevant sheet e.g. Sheet1, then select Worksheet in the first drop down box on the code ...Show All

• manukahn Count and display in cell

  Ok I have an Excel workbook that contains a schedule (51 worksheets total). Each cell has intials in it and if that person has taken a day off the cell is highlighted a certain color (yellow, rose, or red). What I need to do is have something that goes through and counts what intials have what color and then display in a cell the number. So: If cell contains "initials" and cell color is "color" Then count and display in "cell" Example: If cell contains "JJ" and cell color is "Yellow" Then count and display in "A2" I know it is possible to do this but I'm not sure how. Tiger Thanks again for the help. lol yeah I should ha ...Show All

• Alexandr Vishnyakov Help with a formula

  I need to write a formula for Excel that calculates the amount of fuel that is in a tank. Here is what it is for. We have cylinder tanks that lay horizontaly. Each month we put a dipstick into the tank to measure how many inches of fuel is left in the tank. I need a formula that will take that and calculate it into gallons. Here is the formula I have to work with. / -1 r - h \ V = L * | [ r^2 * cos (--------)] - [sqrt(2rh - h^2) * (r - h)] | \ r / Any Help is appreciated (BTW I am not the best at math so if possible an explination of this formula would be greatly appreciated) I got that to ...Show All

• Angel38 A couple of questions regarding the Windows Error Reporting Program

  Hello, Recently I discovered that the Microsoft Windows Error Reporting program is open to all developers free of charge if two requirements (more or less were met). The first requirement was that upon signing up for the program, the candidate company must send a unique Verisign certificate that represent's their organization's identity (about $100). The second requirement was that the application to be submitted to Microsoft for WER must also have a Microsoft Authenticode signature also provided by Verisign (for about $400). My only question that I have is whether I could go with some other signing authority who participates in the Authenticode code signing program (Thawte for instance), and still participate in the Windows Error Rep ...Show All

• pangitko79 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

• Nilkanth VBA sheet using registered dll functions across a network

  Hi, I've developed a VBA project, using functions in a user-defined dll that I developed in C++, and would like to make the project available to other users in my work network. The VBA project calls the dll via a line like: Public Declare Function MyFunction Lib "P:\MyDLL.dll" (ByVal MyArg1 As Double, ...) As Double where P is my personal drive on the network, same drive that the VBA project is sitting in, and this works fine. What I'd like to do is to save both the VBA project and the dll in the same publicly accessible drive so that all users can use it. The trouble is that users will have different path names for the same drive - different drive letters, different roots etc, so I can't specify a fixed path in th ...Show All

• Baji Prasad VBA Powerpoint - identifying textboxes by type

  Hi everyone, I'm writing an add-in for Powerpoint 2003. I'd like to know how I can identify textboxes by type if such a thing exists. For example, when reading a TextFrame, how do I know if I'm reading the title textbox, the subtitle, or a the big textbox with bulleted points depending on the slide model I've found the Shapes.Title property, but that only gives me the title if it exists, not the value of the subtitle or the default big textbox with bulleted points that you find on a default slide. Is there some property somewhere that I'm missing Thanks a lot, Pete I might not have explained myself very clearly with my first post. What I want is a way to know for sure that I'm reading the big, default t ...Show All

• bengz Observation AND Request

  I have been a member of the forum for a month now and have enjoyed trying to help people with their queries. As with most coding there is always more than one way to solve a problem. I also realise that people may not be clicking the "answer" option anticipating a "better" answer may come, this is fine but please reply to a post to let all concerned know whether the suggestion has worked or not. if it has NOT worked then I will know not to suggest that again! If I have upset anyone with my comment then I apologise in advance. ChasAA Hey ChasAA, Brenda from the ISV team used to take care of this. It never used to be much of a problem but the ISV team no longer support VBA a ...Show All

• Clint_vbBoy Help with interface?

  Hey Just completed my set of macros that i need to fully automate a process i am responsible for in work.  However, i am a bit lost as to the best way to run them i.e. link them to buttons in excel etc.  Is is possible to design some sort of interface in VBA and have it load with the spreadsheet    Normally i will be recieving a spreadsheet containing reams of data which have to be sorted and updated.  This is what my macros will achieve.  But what is the best/most efficient way of loading or applying those macros to a different set of data each month Any help is much appreciated Cheers  EDIT: I have since managed to design a form in visual basic and have all my sub ...Show All

• Mowali Excel user form to select a favourite file

  I am trying to use a custom form for the first time and would like to select an excel file from the normal "File _ Save As..." window and once selected, save the path and filename into cell A1 of a spreadsheet called "My Toobar.xls". This will then allow the user to open this "favourite" file very quickly. Can anyone help me get this Windows "File _ Save As..." browser window embedded into a UserForm. Many thanks, Paul I'm sure Derek meant the GetSaveAsFilename ;) application.GetSaveAsFilename Both these methods just collect a filename and do not actually save or open anything. You would still need to use the .SaveAs method of the workbook. Hi, ...Show All

• Nagaraj K Adding records and incrementing the date

  Hi Newbie here..I have two tables in access, the parent table has a start date and an end date and uniqueID, the child table has one date field and the same uniqueID as the parent is also has other fields that would start out blank. I would like to run some code the create one new record in the child table for each day in the parent records date range. I.E. PARENT RECORD UniqueID001 Parent StartDate = 1/12/2006 (1st of December) Parent EndDate = 5/12/2006Total Days = 5 CHILD RECORDS (5 of them) UniqueID001 - Date = 1/12/2006 UniqueID001 - Date = 2/12/2006 and so on until UniqueID001 - Date = 5/12/2006 Its probably quite simple for a gurue! Thanks for the info, but I have change ...Show All

• Tang Meister Outlook Contacts

  I have a load of contacts in Outlook, however when i go to send a mail none of them come up. Therefore i have to copy and paste them when i am writing a new mail. I have checked that the contacts folder is selected. This is a works email system, the Global address list using Exchange works fine but my personal one doesn't. Can anyone help If you work for a company, you might want to check with your IT department to see if there's a settings issue; this seems like a pretty basic issue. Otherwise, you might want to contact Microsoft Product Support for Outlook and they'll get your problem explained and/or help you fix it. Hope this helps. --ISV Buddy Team I found t ...Show All