Answer Questions

• carso 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 Hi Shay, Here's some info from our support engineer: I am sorry for ...Show All

• CSharpDavid Error VB6 when I run application in w2k3 Domain Controller

  HI, I have an application implement in VB6 and when I run in W2k3 Domain Controller give error 713 time execution. please, help me. Any suggestions are very much appreciated. I had the same error on both Server 2003 & XP pro using VB5, when trying to display a Data Bound Grid in the application. The only difference was my runtime error was '9'. CLSID: {00000010-0000-0010-8000-00AA006D2EA4} Found ...Show All

• Morten Felumb Charts in Excel

  I am using defined names to automaticly update my charts. I am using the =OFFSET and =RAND I do have some cells that contain #VALUE! It seems like the chart will update but only part of it. For example it will update but miss the last point. My question is could a non-value cause it to not update correctly Thanks Tiger The first thing to do is check htat your defined names accurately ...Show All

• Rick123 Windows Vista Readiness Labs at TechEd06!!

  Just wanted to pass this on to all you ISV devs... Get in on an unique opportunity to get one-on-one time with our Windows Vista application compatibility experts during the Windows Vista Readiness Applications Compatibility Labs at TechEd 2006. Bring your own Applications to test and troubleshoot and/or try out our self paced labs to test and catch up on the exciting new enhancements and opportunities Windows Vista has to offer – all in ...Show All

• ariu Working with Outlook Public Folders from Excel

  Can anyone point me in the direction of some example code Instead of sending an e-mail which has a large attachment to a distribution group, I want to post it to an existing Outlook folder. The code will be placed inside an excel workbook, which creates the attachment file. Thanks in advance Hi ADG, Can you please provide a more detailed example for the engineer If you want to send a screenshot you can e ...Show All

• enric12879 Selection property

  Please help!  I'm relatively new to VBA programming and I can't figure out how to get, in some form, the range of the current selection in Excel!  I'm trying to get this in order to check to see if the selection is a single cell, or if it is multiple cells (as the macro I recorded crashes if the selection isn't at least a 2x2)  Thanks!! Hi, It's in Applicaiton.Selection object. Just look at ...Show All

• Patricia 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 Well, ...Show All

• Valer BOCAN 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

• antcv How to open Access files and export them to Excel

  I need to open multiple Access files and export several colums to Excel. The problem is that the file extension is not a typical access one and that I need to choose a table from several tables for each file. Then I need to merge into one excel document. Any help would be appreciated, thanks. I'm sorry I've never heard of .alg files before. If you can find a connection string that lets you access the ...Show All

• gmedina Section 1 Footer

  Hi, I have a template whose footer is changed at the run time. The template has a different First Page and I modify the footer based upon certain conditions. I am doing this by using the following code Application.ActiveWindow.ActivePane.View.SeekView = wdSeekFirstPageFooter and Then I modify the code. The problem occurs when a section break occurs in the document.Then the first page footer becomes Section1 Footer, and the above c ...Show All

• bpfh VBA Package And Deployment Wizard

  Hi I am working with Excel 2000 and have to package my files as an executable. I am not having the 'VBA Package And Deployment Wizard' as an add-in. Where can I download it. Thanks Shasur   Hi Shasur, I found the following article that might be helpful, but it looks like this tool was only available in the Office Developer edition and not Premium or Professional. http://msdn.microsoft.com/library/default.asp url ...Show All

• dimadd Help required.....

  Can someone help me please I am trying to create a VBA User form to open up individual Spreadsheets rather than having to have all the sheets open (as with a workspace). I have designed the user form and now need to code the command_buttons. However I am stuck with what code I need to use. If it helps, I need to program 7 buttons, 6 will open spreadsheets and one will open a MS Project file. This is fairly urgent as I have to have ready ...Show All

• TimNeale Excel shape classname in Windows API

  Here's something I've been trying to find for a couple of days without success. I need to know what the classstring is for the excel shape object that you get when you add a pictures from a file... anybody :) The way I've understood it, every object has a classname and so should the shape object, but I can't find it. If I'm mistaken, please let me know! www.allapi.com ...Show All

• MartyW extract office file's title into excel

  hi guys! I have a folder which included many office excel and word files. these files have a file properties as "QMS-DOCUMENT-NO", which is created by myself when I create the file. New file will be add into this folder frequently. two questions: 1. I want to creat a excel file consolides what i have in this folder. it shall shows the file "name", "Title", and "QMS-DOCUMENT-NO". is there an automa ...Show All

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