Answer Questions

• shimshon passing data in multiple rows in a recordset

  I have a recordset that consit of 5 rows 6 columns. each column has a name. i would like to retrieve the second row in the recordset. I can read the first row, but I am lost as to read the second row in the recordset... help!! hi, there are a couple of Move methods that let you navigate the rows of a recordset, MoveFirst, MoveNext, MovePrevious, MoveLast and just Move. You need to be wary though as moving back and forward through a recordset using these methods will depend what kind of cursor the recordset was opened with, for example you can't call MoveFirst or MovePrevious if your recordset is using a forward only cursor. ...Show All

• nature0276 Macro stops running after a certain time, excel limitation???

  Hey guys i have this problem: I have to run a macro for Excel that calculates some values for the entire 2006 year. To do that it has to open 365 daily files check for some circuits and calculate a sum. It opens a file does some checking, writes some values then closes it, opens the next one and so on. For a smaller number of circuits it worked fine and took about 10 minutes. Second time it opened several files and then stopped with after a file is opened. I used a breakpoint for End Sub but it doesn't reach that. Do you know of any limitations in vba or maybe in Excel PS: I turned off autorecovery Thanks Hi Try this may be it will work. Tools ----> options---> calculations tab-----> and ...Show All

• Joymon checkbox value on Workbook_Open

  I have a checkbox on my worksheet, that I would like to check the value of it when the workbook opens. Simple example would be: If the user saved the workbook with the checkbox checked, then when he opens the workbook again, then cell A1 = 1, else A1 = 2. I cannot figure out how to obtain the properties of this control (or any other toolbox control) from the Workbook_Open event. I am using Excel 2002 (10.4302.4219 SP2). Any help will be greatly appreciated. Mike Oh, you can identify the control by name. Just something like: If o.Object.Name="CheckBox1" Then ... How do I indentify a specific control This is what I have: 2 combo boxes that have their ListFillRange popula ...Show All

• SolarWind SendKeys from Excel

  I'm trying to send information to another application using the SendKeys function but it isn't working. The primary code that I'm using is: ActiveWorkbook.FollowHyperlink Address:=" http://www.aasb.com.au/public_docs/aasb_standards_2005/compilations/AASB101_07-04_COMP_11-05.pdf ", _ NewWindow:=True AppActivate "Microsoft Internet Explorer" Application.SendKeys "^F34.~", True. Sometimes I get an error on the AppActivate statement and sometimes the SendKeys function works but not all the time. Does anyone have any suggestions about what I'm doing wrong for it to not work all the time Derek's answer was right on. I wrestled with a similar problem last week, trying to use VBA code to automagical ...Show All

• Paul Hacker Include a user-defined field in task view to contain an image

  Hi all, Is it possible to include a user-defined field in the task view which can contain a .gif file or any image file Thanks, Vasanth. ...Show All

• anukirthi Loop til you drop

  I have a loop in which I am trying to search for a cell with a ceratin textline ("Sec type"). I want to search the entire spreadsheet but if it it possible to search only some used range that is preffered. If I find the cell I am lokking for I want to check to see that it is not on the same row as some other things. These rows are specified by segment.row and secID.row. My problem is that the loop never stops running and I do not know what is wrong with it. I guess it is the Loop-line that is erronous but I do not know how to fix it. Please help me out if can! Thanks! With Range("b1:aa500") Set c = Worksheets("Berakning").Cells.Find("Sec type", LookIn:=xlValues) If Not c Is Nothing Then ...Show All

• TimGL Write text from a list box to a table in MS Access 2003 (VBA)

  Dear Community, I am trying to create an application that will allow the user to view a catalogue of photographs through a Microsoft Access application. Instead of placing each picture into the database as a blob object, I have decided to include the file path (string) indicating where the photos reside on the hard drive (to save space). The app is set up so that when a user clicks a button, a file dialog pops up and allows the user to choose photos (their paths) for upload into the database. Currently, the chosen file paths are displayed in a list box. My question: How do I transfer each individual path name from the list box to its own record in the database table I believe it has something to do with recordsets and the Tra ...Show All

• Jutsin Leung Vlookup from various files

  Hi, I have the below macro that pull data from different files based on the dates stated in Column A. This assumes that the data can always be found from cell B2. However, I will like to have a macro that will do a vlookup from the open files. Pls advise. Sub Macro1() ' ' Macro1 Macro ' Macro recorded 15/08/2006 by User Dim filedate As String Dim times As Integer Dim filefound As String Dim thisfile As String For times = 1 To ActiveSheet.UsedRange.Rows.Count filedate = Range("A" & times).Value thisfile = "C:\Documents and Settings\Simon\Desktop\VBA\VBE\" & filedate & ".xls" filefound = Dir(thisfile) If filefound <> "" Then Workbooks.Open Filename:= _ "C:\D ...Show All

• Spoofer How to automate a dialog? [The message filter indicated that the application is busy error.]

  Hello. When an automated Office application throws some dialog box, the server refuses any subsequent RPC call returning an error "The message filter indicated that the application is busy." Is there still any possibility to noninteractively press some button of the thrown dialog through the VBA (or by other means) to go on Thank you, P. ...Show All

• BobRS LCS complience with IMS / SIP standards ?

  1. It seems, to register to Live Communication server from a SIP client, NTLS or Kerbaros authentication is a must. How to register from a SIP client which doesn't support NTLS or Kerbaros Is there any configuration required on LCS to acheive the same 2. If LCS doesn't support HTTP Digest Authentication then its not interoperable with SIP standard rfc 3261 and IMS Please correct me if I am wrong Please revert back !!! Best Regards, Deepak K Bramhapuriya You can license the protocol specs from MS. For information, go here: http://www.microsoft.com/about/legal/intellectualproperty/protocols/mcpp.mspx There are specs for the MS extensions to SIP as well as NTLM Authentication. ...Show All

• Chris Honcoop Can any1 arrange the ADO connection logic for this VBA code-block ?

  Hi all VB developers ! Pls. refer to the following code-block. Can any1 arrange the ADO connection logic for this VBA code-block Set mdxRec = New ADODB.Recordset If dbh = "" Then ' MsgBox ("Faild") End If 'dbh.ConnectionTimeout = 360000 Set mdxRec.ActiveConnection = dbh mdxRec.Source = strMDX On Error GoTo errHand mdxRec.Open dbh.ConnectionTimeout = 360000 ' ADDED RECENTLY ''If dbh.Close = False Then If dbh.State = 1 Then dbh.Close End If On Error GoTo errHand Set wbBook = ThisWorkbook Set wkSheet = wbBook.Worksheets(1) 'Read in values from the record set wkSheet.Cells(9, 1).CopyFromRecordset mdxRec SubTotalsIns 9, 2, 3, 4, 8, 9, St ...Show All

• WaaZ MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. Hello, I have the opposite problem. I have users who have had the icon for the Office Document Image Writer deleted under Printers and Faxes. You mention above that it is easy to reinstall the virtual printer. Could you point me to the directions for reinstallation plea ...Show All

• MAwais Newbie in VBA Drag and Drop..

  Hi, Do not know if this is possible drag and drop effect of items in dropdown control inside a word application The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done Thanks in advanced. den2005 Hi Derek,     Sorry for late reply, busy here, interested on how the drag and drop will be done, the drag and drop will be like there is a combobox or dropdown control where the items can be drag and drop on any location on word document. Can you provide some ideas or links or even better some ...Show All

• kjsteuer Office2003 VBA 6.3 Help files not working correctly.

  When I open the Help window (under any Office2003 application) in the VBA editor, there is a Search bar and a Table of contents. After doing a search for any keyword, a large number of items in the resulting list do nothing when I click on them. How can I fix this Is this the correct forum for this question Where can I find information about fixing this problem Thank you for your time and consideration. Same problem here, Fresh install of office won't solve the problem. Any suggestions would be more than welcome. ...Show All

• jwadew My mini Utility_Move class, please have some suggestions.

  Hello guys, I made a class called Utility_Move. Please give me some suggestions. If there is a better, cleaner, more performance way than mine, please tell me, thank you. 'Motive: Sometimes it is eaiser to debug when you use ActiveCell as current data record or parameter. '   When the macro stopped by exception or stop sign, you can determine the running progress by ActiveCell. '   And it is easier to say Up(5) instead of offset the row index, for me at least. 'Summary: The Utility_Move class introduce 3 sets of functions. 'First set, Up-Down-Right-Left simulate the key stroke of arrow keys. '   Additionally, Steps parameter allows you to repeat number of seps to that direction. '   Negative st ...Show All