Answer Questions

• HolySmokes Displaying modeless userform while other workbooks are opened and closed

  I tried using the following code to display a modeless userform with a "Please Wait.  Do not Interrupt" message while a set of workbooks are initialized. Private Sub btnInitToolset_Click() Dim Answer As String Answer = MsgBox(prompt:="Are you sure you want to Initialize the Toolset " & vbNewLine & "All data will be lost.", Buttons:=vbYesNo + vbQuestion, Title:="Warning!") If Answer = vbNo Then Exit Sub     InitW ...Show All

• John Ericson174499 Best way to learn VBA for Excel

  Can someone recommend books, websites or any other sources to learn VBA for Excel and Outlook. I am using the help function but surely there must be a more structured way to learn this language. Thanks, Antonio The MSDN library has some good articles on developing with Office. http://msdn.microsoft.com/library/en-us/odc_2003_ta/html/odc_ancoffsol.asp frame=true There are some sample chapters ...Show All

• monyplaba LCS

  My large company is looking at chatting applications, but isn't considering LCS.  Does anyone know if the LCS client is compatible with outside users on windows messanger.  I've used it once in, but i'm not sure if that was not available or just not in use.  I would really rather use LCS, but I think it will be a deal breaker if it won't allow others outside the domain to chat to users in the domain. ...Show All

• Milos Cimfl - MSFT Code erroring out.

  Ok here is the code that is breaking: If Range("useSP").Value = "Y" Then startpoint1 = 1 startpoint2 = 1 Else startpoint1 = 144 startpoint2 = 943 End If 'Inputing formulas and making needed properity changes For x = 0 To 142 With Sheets("Pyramid Evolution").Range(Range("SalaryPointPE").Cells(startpoint1 + x, 1).Value) .Formula = Range("SalaryPointPE").Cells(sta ...Show All

• Sakellariou Dimitris Increase Speed of a Word Macro

  I have written a macro in MS-Word for formatting of documents. It finds the carriage Return character and replaces it with Null. For a 60 page document the macro takes approx 1 hour to complete. I have tried following options 1. Increase Virtual Memory 2. Increase RAM from 512 Mb to 1024 Mb. 3. Turned Off Spell Check and Grammar Check. but nothing has helped. Can anyone please tell me how to increase the speed and decrease the execution time ...Show All

• captainstorm Creating AD user with profile & home directories

  I am using Excel VBA to create AD users from a spreadsheet of names. I can create the users in the correct OU and can add the home drive and profile path to the user object. However, unlike when creating the User from the "AD Users and Computers", the folders themselves and the relevant permissions are not created automatically. Creating the folders themselves will be no problem, but how can I then assign the correct security permissions to the ...Show All

• Manish_Jain Installing Business Scorecard Manager 2005 on a SQL Server 2005 instance.

  I'm trying to install BSM 2005 into a Win/2003 Server running SQL Server 2005 (everything) and the Web Service won't install because it reports the following: Failed Microsoft OLE DB Provider for OLAP Service (MSOLAP) 2000 SP4 (8.00.2039) as well, the Alerts won't install because of the message: Failed Microsoft SQL Server 200 Notification Services 2.0 SP1 Engine Components I understood that this version was compatible with SQL 2005. Any idea ho ...Show All

• Beauzak Word 2000 section page numbering bug? Any workaround?

  Hi, In a Word template macro I need to renumber page numbers of section 1 of the active document. Code is as follows:     With ActiveDocument.Sections(1).Headers(1).PageNumbers         .NumberStyle = wdPageNumberStyleLowercaseRoman         .HeadingLevelForChapter = 0         .IncludeChapterNumber = False    &nbs ...Show All

• Jorge Paulino Help with the application-defined or object defined error

    I am fairly new to programming I have a command button 1 in the spreadsheet however I keep getting an error message application-defined or object defined error.  I am not sure what this error means. What I want to do is set ninterval, rbedradius and xinterval to cell values shown below. I want to use a for loop and apply calculations. Later (not yet coded) want to put a condition on the third column of formulation. How d ...Show All

• kkennedy1008 Shared Addin using Word

  Hello Everybody, i have created a shared addin for word. i succeded with adding an item in the context menu of word (text context menu). The menu which appears during right click of a text. I did that thru adding an control button on "TEXT" commandbar which is for context menu thru addin. The problem now i am getting is the associated event for that command button which newly inserted is not firing. If i try to add the item in some other menus s ...Show All

• Dr. B. How to put text in a listbox heads ?

  Tried to find in help but to no avail. listbox.heads = True listbox.column = 8 but how to put some text in the headers. Thanks..... Using office 2000 on Windows XP Hi Michael, The support engineer found the following... I have setup up a office 2000 machine for this case. And do test on ListBox control. First, ListBox control has a property ColumnHeads, we can set it ...Show All

• mvillatem Problem with RecordCount by CrossTab

  Hi, i'm getting a problem with a CrossTab in Access 97. When I open the query by clicking twice it returns 4 records. Thats OK and correct. The problem is when I open the query with VBA code, it returns 1 record (property recordCont = 1) I'm opening the query this way: Dim DB As Database Dim MyQuery As Recordset Set DB = CurrentDb Set MyQuery = DB.OpenRecordset("CrossTAB_Compras") Anyone can help Thanks, Felipe ...Show All

• Lisa Feigenbaum has anyone done the tests at all?!

  hi, just wondering has anyone done microsoft ISV software tests   i'm a one-person ISV and i'm interested to hear from others who have been through the testing process.  i've been on the ISV empower program for the last 18 months and i'll be taking my tests shortly.  i intend to apply under the "platform" tests, doing the windows client test, and web services + .net framework.  i read the instructions from the testi ...Show All

• Apoorv Bhargava How Can I create an UDF I can use in a cell?

  How can I insert a managed function in a cell For instance I have a created a function Public Function test( ByVal myRange As Excel.Range) As String 'Some code..... test = "testing" End Function If I put in a cell of the wordsheet the formula =test(a1:a2) I get an error. Is there a way to create a UDF as is possible in VBA Daan Compared to VBA and even XL ...Show All

• Thomas Liebald Exit problem

  hi all i have an urgent problem , if any could help me in any way i would be thankful i have a system that uses ms sql server as back end and ms access 2000 as fron end in one of the ms access 2000 form i have created two combo boxes such that the user select the product type and the next combo box will display only those items of the user selected product type in the same form i added a button to exit with docmd.close ...Show All