Answer Questions

• BilalShouman A vector of vectors

  Hi... I need to create a vector of vectors (or a vectors container) using VBA for Excel. How can i do this Thanks.. I'm not clear on just what you're trying to do here. Are you looking to build a Collection of vectors If so, you can do something like this in the general code area of one of your modules: Type Vector Direction as Single Magnitude as Single End Type Private MyVectors As Collection And then code like this could be used to initialize and access the members of the Collection. Private Sub InitMyVectors() Dim tvector as Vector tvector.Direction = 0.50 tvector.Magnitude = 2.50 MyVectors.Add tvector, "Vector1" MsgBox &quo ...Show All

• ChaCh Check if an Excel workbook is opened and in use by somebody else

  Hi, I need to check if a workbook is opened and in use by someone else. workbooks.open does not return a trappable error Excellent, thank you, the second worked very well. Now the second problem is to find out who that "somebody else"-person on the network using the workbook is. I know this is returned in an errormessage when I try to open the workbook directly from Excel, but I cannot find out who the person is when opening from a VBA routine. Hi, Have at a look at these 2 options for checking a file. http://www.xldynamic.com/source/xld.FileOpen.html How about the WriteReservedBy property of the workbook. May not work in networked situations. In which case may using some like this t ...Show All

• deji101 opc

  I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it You can use vb.net or c# with rslinx's COM dll. You just add the reference to RsiOPCAuto.dll to your project and use its classes. To pass an array to a OPC method, just dim the array to n+1 and fill it starting at index 1. The method will return object arrays that you will read starting at index 1. You have to cast to the specific types to get the values. Excuse me for my bad grammar. I hope this helps. I was looking for some help deve ...Show All

• Carlos.Camargo Accessing Visual FoxPro data using VBA (Excel)

  I am trying to query some records from a FoxPro database in Excel using VBA. I am able to grab all the data I want, based on my criteria, except for the dates. I cannot query by dates. Could you please educate me as to how to query records from a FoxPro database file by date/time in VBA Thanks in advance. MPG. Thanks for replying. I have tried these formats to query the dates and have had no luck. I can pull the information using the literals (#) in MS Query, but cannot in VBA (using XLODBC) and SQL Statements. Thanks again. Mike. The guys here might have your solution... http://www.dbforums.com/printthread.php t=437921 Hi, Have you tried wrapping the dates in # symbols, for example, WHERE [StartDat ...Show All

• Suman Ghosh Track changes in Excel

  Hello, I want to write a macro which track changes in the worksheet. Suppose the value in the cell has been changed, then it will mark the cell as yellow in color. But if after making a change it reverts back to the same value as previous, then the cell will again become white in color. For tracking changes I want to compare sheet1 and sheet2. Note that in sheet2 user may insert or delete rows, which i need to take care while comparing. Kindly help ...Show All

• PDWLC error creating Excel application object

  Hello World, I am using VBA from an application call MicroStation to open a document in Excel and am having problems creating the Excel Application object. The line: Set xlApp = GetObject(, "Excel.Application") results in the message Run-time Error '429': ActiveX component can't create object. The documentation indicates a number of possible problems, but none of them seem likely causes. Excel is installed on this machine with a valid license and I'm able to run it. It's registered, and isn't already opened. Any ideas what I'm missing Thanks, Stephanie Hi, The code example you posted is correct and works for me. But I can generate the error if I mis-spell the class descript ...Show All

• TvB History of field's value in CRM

  Hello, I am trying to solve following issue: I need to put one variable in customer's form (rating of the customer). It is updated every week. How can I make CRM to remember history of this rating and than do some report with it Like history graph of customer's rating. Thanks a lot for answer, I am just starting with CRM... ...Show All

• Jebasingh how to make Icons in LISTBOX and not in list view

  hey can anyone help me on this C# help ...Show All

• Abhishek bhadouria Can you use VBA to access a spread sheet embedded in a word doc?

  I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated. Hi Jon, When I test that it leaves the object active and selected. Unless I step through the code in the VBE in which case it does indeed quit it and select the range in the active document. All in all using automation on OLE objects within word is not a fun experience! Hi, Something along these lines. Sub WriteToSS() Dim objSS As InlineS ...Show All

• Moonshadow 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 Here is the basic principle of doing what you w ...Show All

• anisk open a workbook with events turned off

  Is there a way to open a workbook with the events disabled   In other words, I would like to open a workbook so that links can be updated, but without executing the workbook_open or workbook_activate event procedures. Aparrently, you can do it by disabling events just before opening the other workbook and reenabling the events just after closing it. This only works if you do not execute an enableevents in the other workbook while processing in it. Nice one Joe, just encase anyone else needs to know here is an example: Application. EnableEvents = False ActiveWorkbook.Save Application. EnableEvents = True Joe, I'm not sure if you can do what your asking. ...Show All

• anubisascends Doing a date out(radio button)twice where i want the 2nd time to not allowed unless item was dated in again

  Firstly, my date in and out was created using radio buttons. i wanted the systems to be able to detect such that when the item is date in, it is not allowed to do date in again unless the item was being dated out. And if the item was dated out, it should not be able to dated out again if the item wasn't dated in after being dated out. Right now, i can only date in and date out successfully once. Here's my coding for above: [code] If (RtnIn.Value = True ) Then TempDateIn = Date With Worksheets("Board_Movement") .Activate .Range("A1").Select If TypeName(.Cells.Find(equidID, lookat:=xlWhole, _ MatchCase:= False )) = "Range" Then MsgBox ("Equipment ID already in use, ...Show All

• Madhu Gandhi Log in with Active X

  Hi! Every night I have a macro that is supposed to run and open and login to a program (the Bloomberg professional) and download some data. My problem is the log in process from my macro. Now I use SendKeys but that seems VERY unreliable. Does anyone have any links with code that shows how to use some better techniques e.g. Active X to log in to a program Any help appreciated! Thanks a lot in advance! Hello ChasAA! Sorry but it is not a website (although there is a Bloomberg website) but a program that provides financial data. However to me it seems like the login process should be the almost the same regardless of what you are trying to log in to. I mean you enter a user name and a passwor ...Show All

• gooon Get Call Status

  Hi i m Rajat, simply i want ot get state of call whome i m calling on mobile. is she/he On line is she/he switched off his phone. etc. do it man. Rajat Hi I need to know the various states of call in progress to the target number. Let me explain the exact problem. I have developed a windows mobile 5 application which is initiating a voice call from with in the program. Let us suppose to a predefined number +123 or whatever. Now I need to know various states of call in progress. For example – dialing, ringing/busy, pick up, disconnect etc. When programming with native code there are some TAPI functions like “linegetcallstatus” which serves the purpose but unfortunately I am not very good with native language programming and need th ...Show All

• Clark Wilson Word Macro and Template File

  I created a template file that handles the Open/New event and run various macros/functions when triggered. Now I want to create documents from that template. The problem is that the new document does not fire the template file's Open/New event. Instead, if I open Visual Basic Editor, I see 3 projects: Normal, Document, Template. The Document project has a reference to the Template project but none of the events in the template are firing. ...Show All