Answer Questions

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

• JoelAraujo Charts.Add method causing error

  I needed a macro to add a chart with a very specific format. I created a macro that usually works, but I am getting an error that I don't understand. Here is a snippet from the macro: Set chartRange = Selection Charts.Add ' This line results in a "Type Mismatch Error" the first time it is run ActiveChart.ChartType = xlXYScatter ActiveChart.SetSourceData Source:=chartRange, PlotBy:=xlColumns '... When I open a new sheet, and put some data in an ...Show All

• Tim Shea Access report using VBA

  Hey All! I have a problem. I am creating a screen that includes persons first_name, last_name, phone_number (this is a fields in access) Now I have created a command button and I want that when user clicks on the command button the information in those fields would go to excel page. Sincerely, Boris Put it behind the command button you want the user to press. Your screen, if it's bound, will have a table or a query be ...Show All

• Manana_Man history of vba

  does anyone have something about vba's history I can't find anything about vba look up Basic, VBA evolved from that. ...Show All

• Marco Retamales Installing BSC on SQL 2005 - SQL Server on the server does not meet requirement of SQL Server 2000 SP4

  I am installing MOBSC on SQL 2005. I have installed the AS/2000 piviot table services (PTSFull) and now the installation program is getting to the point where is it validating the databse server. It is coming back with an error that the "SQL Server on the server does not meet requirement of SQL Server 2000 SP4" Is this happening because I installed the AS/2000 drivers How do i get past this roadblock in the installation ...Show All

• The VB n00b Lack of mouse scroll wheel support in VBA

  Folks The mouse scroll wheel does not work in VBA.   This has always puzzled me as to why this support does not exist since Office 2000. This problem was originally caused by a MS Mouse driver change that I'm told was communicated long in advance to other MS folks. This problem has existed for several versions of Office.  As far as I'm concerned this should've been fixed in the Office SPs. And yes, I'm quite aware of the workaro ...Show All

• sbadams cannot save file as

  I can't save any files on any of my other drives. The message comes up as save file not responding. Also szAppname:WINWORDEXE, szAppver:11.06568.0, szModname:hungapp. Why can't you ever get help from microsoft without a fee After all this is their product. Everytime I click on your link for the hpfix, I get taken to hotmail After spending 3 hours researching this on my own, and finding no help, I calle ...Show All

• JASAILOR 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 ...Show All

• serhio Fastest Processor for Running Excel VBA Macros

  i have written a series of complex VBA macros in excel as part of a system to generate hundreds (even thousands) of data reports from large data sets. on my old desktop (p4 @ 3.2; 3gb ram) some of the macros take hours to execute - i even let them run overnight. i wanted a new computer that could run them in much less time. so we invested 5k in a new desktop (dual core xeon @ 2.8; 4gb ram; twin 15k rpm hard drives). i ran a simple macro ...Show All

• hhampa Embed fonts

  We have created a logo for our Company using Goudy fonts. The problem is that most computers do not have this font. Is there some way to embed these fonts into the document so they can be e-mailed with the document. Or is there another way to pull a text box with Goudy fonts into a document where it will be not changed if pulled onto a computer without the Goudy font Any suggestions are appreciated. LV It&nbs ...Show All

• cais Error after added a formule in cell with VBA

  HI all, I have a problem in a VBA project. I need to put in a cell a formle like "=RC[-2] - Janvier!AH8" (Janvier![AH8] must be dynamic with different sheet name and cell) Here the part of my code I used : absence = MthNamebefore & "!" & Cdecol & J rag2 = col & i & ":" & col & i Range(rag2).Select formul = "=RC[-2]-" & absence ...Show All

• ScottDKoder Application Error

  Hi experts, We have an application written in VBA. The application is failing with the following log entry in the event log. Faulting application: appname.exe Faulting Module: VBE6 Version: 6.4.99.72 Fault Address 0x000dc6f2 Event ID: 1000 The application is running on Windows XP SP2 with Office 2003 SP2. Help would be much appreciated. Thanks Steve Hi, This time the application is failed on a call to ...Show All

• Cezary How do i use an addin in WORD?

  Hi all, i wrote few macros in WORD and put it in a module. I want users to be able to install and uninstall it to their NORMAL.DOT Template. i saved the module in a special template. the module include a commandbar with 2 butoons, which execute macros when are pressed. How do i add in the module Pls advise S Shay Van Creveld wrote: Hi all, i wrote few macros in WORD and ...Show All

• MarkWastie Format Comparison

  My goal is to distguish which format to use if the format is equal to "000.00.00.00" then or is the format equal to "00.00.00" then Public Sub DistinguishFormat() Dim Subject As String If Mid(Subject,4,1)="." Then ... Else ... End If End Sub ...Show All

• Mike Gabriele Sharepoint 2007 Site Template

  Hello, I'm probably just missing it but where/how do you create a site template in beta 2 of sharepoint 2007 I don't see it anywhere in site settings. Is creating a site template even available in the beta Any feedback would be greatly appreciated. Thank you! Hi Mark, The best resource for your question is probably the Office beta newsgroup or one of the main SharePoint newgroups on http://www.microsoft.com/sharepoint/community.msp ...Show All