Answer Questions

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

• KurtGo Opening a Word file from a macro in Excel

  I have some code that will open a Word document from a macro in Excel, but for some reason it won't recognize the Word file if the folders in the filepath have any spaces in their names. Here is the code: Sub MergeToWord() ActiveWorkbook.Names.Add Name:="MyData", RefersTo:="=Sheet1!" _ & Range(Selection, Selection.End(xlDown)).Address Shell "C:\Program Files\Microsoft office\Office11\winword.exe F: ...Show All

• Shawn_H custom toolbar error

  I built a custom tool bar for my applicatoin. It works ok on PC Excel. But I got an error message on a Mac Excel: Run-time error '-2147483640(-7FFFFFF8)': Method 'FaceId' of object 'CommandBarButton' failed If I comment out the        .FaceId = 642 Then the error message becomes Method 'OnAction' of object 'CommandBarButton' failed The original code in VBA look like this: ..............    Private Sub Cr ...Show All

• Reformed Business Scorecard Manager 2005 Webpart problem

  Problem with the Business Scorecard Manager 2005(Maestro) on an Analysis Services cube of SQL Server 2005 Apr CTP While using the Office Report View Webpart (Pivot Table) in WSS, cannot see the Toolbar with the Save option. So if i create a Pivot table with the Dimensions & measures, click another link and come back to this page, the Pivot table gets reset without any fields Any solution I think we are diverting from the query. I ha ...Show All

• Justahobby Open a Word Document

  Hello i need to find out how to open a word document from my access database any one know a good solution. i have an ole object and you can drag and drop the file onto it but i need a way to have it load up in Word so it can be read/written/printed via word 2003. There's a better way to open a word document using the Windows API. Copy this code to the top of your form/module under Option Compare Database... Private Declare F ...Show All

• micropterus_sal InputBox() in MS Word form textbox.

  I would like to insert a InputBox() prompt with the text being entered into protected Word form Textbox. I understand the InputBox() code and that the macro will be going into the ''Run Macro On Entry' dropdown box. Can someone point me in the right direction on how to do this. I am new to VBA. I am creating a MS Word form, like a memo ir fax sheet. I would like to have a popup occur upon opening the form, ask ...Show All

• CharlieDigital XSL applied with VBA

  Hello, everybody, Derek, Brenda Acctually I'm doing a test based in Instructional program evaluation faced with library resources. The goal of these evaluationsis to assess the adequacy of library resources to the needs of courses offered within a program and to determine the ability of the library to support teaching and related research. This methodology of collection evaluation based on the analysis of the content of individua ...Show All

• Eureuka Word Macro Runtime Error

  Hi all, I'm a complete newbie when it comes to VBA but I've been tasked with writing a macro for a Word form. The form will be linked to on a web page and has two buttons at the bottom, Accept or Decline. Basically what the boss wants to happen is that when either button is clicked the form gets attached to an email and automatically sent. At the same time a message box appears telling the applicant "thanks" and after they click ...Show All

• papapet_2000 app_sheetbeforedoubleclick exists?

  Hi, I'd like to capture doubleclicks on cells in all workbooks so I assume I should use a class module. (my app_... procedures work well for other purposes) I'd use the procedure: Private Sub App_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, ByVal Cancel As Boolean) according to the help, but when I try to compile it says: 'Procedure declaration does not match description of event or procedure having the sam ...Show All

• Erik BN What's your experience with the buddy program?

  Started by admin at 03-28-2005 5:11 PM. Topic has 2 replies. 03-28-2005, 5:11 PM admin Joined on 12-16-2004 Posts 14 What's your experience with the buddy program We've already received a couple of posts on buddy experiences (thank you!) and would love to see more of them, so feel free to jump in and reply to this post and share yours! Thanks, Brenda [msdn/isv] ...Show All

• SMRSoftware Excel DDE Server

  Hello, I have an excel spreadsheet that does some computations. I would like to keep this running on a server 24 hours a day. I would like this spreadsheet to act like a DDE server and be able to process custom DDE commands -- these DDE commands will be requests for the results of the computations being performed. The applications the will be sending these requests will be running on different machines. How do I go about setting up s ...Show All

• KentT Outlook experienced a serious error: 'microsoft vba for outlook addin'

  Hi, I wonder if anyone can help me with this problem I have been getting. I wrote a macro in Outlook that strips unwanted text from the Subject line, here it is: Sub CleanDC() Dim OutlookApp As Outlook.Application Dim myNamespace As Outlook.NameSpace Dim myItems As Outlook.Items Dim myItem As Outlook.MailItem Dim dcFolder As Outlook.MAPIFolder Dim s As String Set OutlookApp = CreateObject("Outlook.Application") ...Show All

• sjnaughton VBA XmlMap.loadXML problem - repeating call

  Hi all, I have the following XSD load to XML Source of excel: < xml version="1.0" > <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs=" http://www.w3.org/2001/XMLSchema "> <xs:element name="stock"> <xs:complexType> <xs:sequence> <xs:element maxOccurs="unbounded" name="quote"> <xs:co ...Show All

• Aperion Information Technologies Inserting information from a Userform to a text box

  I have a Word document that asks for the same information several times. What I want to do is create a user form that asks for that info once then when I click add it puts it into the word doc in those specific locations. I thought using text boxes would be the best way to go. But how do I tell it that I want the info to go there Thanks Tiger Hi Tiger, Here's the info I got back from the support ...Show All

• Xavy Future of VBA (and VBScript)?

  We developped a number of tools in VBA or VBScript, sometimes using COM objects, and the large compatibility of VB, VBA and VBScript was certainly nice. We would no mind moving to .NET (the framework API being quite interesting), but it is not clear what is going to be the future for VBA and VBScript. Can we expect a VB.NET"A" and a VB.NET"Script" Hi! I read somewhere that VBA will be raplaced by VB.NET and ...Show All