Answer Questions

• AgusPac Trouble creating an Add-in for Excel with vb.net

  I am using VB.net 2003, and I am trying to make a COM object that makes some classes and methods available in Excel (2000). Right now I don't intend for any of them to be GUI driven. Based on the KB articles http://support.microsoft.com/default.aspx scid=kb;EN-US;q302896 and http://support.microsoft.com/default.aspx scid=kb;en-us;256624 , I wrote the code below in VB.net: Imports Microsoft.Office.Core imports Extensibility ...Show All

• Pedro Reis VBA for Powerpoint

  Hi, I have been asked to modify a powerpoint presentation so that from a series of jpg files, one appears on the screen and then after a specific time period disappears and is replaced by another; this being a continuous loop on one slide only - like a photo tour. I have the following code, but need to get it up and running. Any suggestions: Sub ImportABunch() Dim strTemp As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As S ...Show All

• vmadan16 Does the VBA save word as XML???

  Hello! I'm really needing to know if there's any VBA code able to save a Word document as an XML doc. Any sample is appreciate. thanx Marcos Hercules dos Santos Looking at it again, there are a few other methods you could try Search in the help for... ExportXML() and SaveAsXMLData() You'll see something called XmlMaps, I believe this is a Schema mapping that describes what you want to export. Can yo ...Show All

• mgomon Getting Images embedded in Word

  Hi all, I'm finding it very difficult to solve a seemingly simple problem. I have inserted an image in an AutoShape in Word. I am not able to get the control of the image. I need to get the original image that was inserted into the AutoShape. When I open the Fill Picture Dialog in 'Format AutoShapes'. I can see the original image. It is there somewhere, but its acting too elusive for me, or maybe I'm looking in the wrong place ...Show All

• withRajeev email from excel

  The code at the end allows me to send an email with outlook with some fields from an Excel spreadsheet. Note that in the body I copy a table in html format. Is there an easier way to include in the body a range of cells in table format Thanks, Antonio Sub send_email_confirm() Dim objMail As MailItem Set objOL = New Outlook.Application Set objMail = objOL.CreateItem(olMailItem) ' determines if sale or purchase Di ...Show All

• RobinHuan pass parameter to stored procedure

  Hello, Can someone please show me an example of how to pass a parameter to a stored procedure I have a crystal report that uses the stored procudure. I can call the report with this: Set s = CreateObject("InternetExplorer.application") s.Visible = True     s.Navigate " h ttp://exch server/scr reports/Se rvice/Main tenance/ma intenanceI nvoice.rpt " ' prompt0=" & JobStatus.Job & "&prompt1=" & CStr(Now) ...Show All

• AlexanderP VBA runs slowly in Excel 97

  I have a module attached to a button in Excel. The module deletes a number of cells, reads some data stored in a list on a separate sheet and writes some data back to the area deleted, based on criteria in some cells. First time I run it, it runs in seconds. If I run it again it takes minutes. Any ideas I'm thinking it might be due to Excel automatically refreshing or all its calculations on each of the cop ...Show All

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

• José Eloy OUTLOOK: "Edit with Microsoft Word" - Comments in Text

  Hi forum members, I have a problem with Outlook 2003 and VBA: With the VBA function MailItem.Reply I create a new reply mail and display it. When the user inserts comments inside the recipients original text, these comments are automatically highlighted (blue and prefixed with the senders name) - like it should be. However if Outlook is configured to use Word as the email editor, comments are not highlighted. But otherwise when the user click ...Show All

• MikeMinsk project email updates set to not automatic

  Does anyone know how to turn off the email without turning off the ability to request status updates I don't want an email sent out every time I update something on a task to a resource. I would like to be able to control when an email gets sent to someone. Thanks! Per our support engineer: Thanks for using Microsoft ISV Community Forum. As you may know, Project Server leverages the alert functional ...Show All

• WhatIsBigBang Help with using Outlook from Access

  I am openning Outlook by calling createobject, which I expected to open a new instance of the application. However it appears to use the one open on my desktop. This means that my quit statement closes my e-mail. How should I amend the below to leave my original e-mail session open Also I will be replacing the debug.print statement with code to work with the attachment to copy data into my database. I am intending to save the file to a tempor ...Show All

• Amol Puri DLL/OCX Redirection from Word template

  Hi there. I need a Word-based application of mine to use an old version of the Rich Text control, so DLL/COM redirection looked just the thing, but this is described as working for DLLs/OCXs loaded from an application .EXE file. My application is launched from a Word template. That template references a DLL which references another DLL which references a custom OCX which makes use of the Rich Textbox control. Is there any way I can get thi ...Show All

• mhouston23 Needed urgent to download Windows live messenger

  It have been offul to get a Beta Messenger 8.0 Y need this program. Please tell me how ando were can I have it. I know were to download it, www.ideas.live.com dont worry u dont need to thank me, u can get everything beta there. HI PLS HELP NEED TO DWNLOAD WLM 8.0 I need mto join MSN beta 8.1. I need ur help ...Show All

• AnandMVP Partnering with Microsoft?

  I am a partner with Microsoft and a Small Business Specialist.  Our company provides technology solutions for Small Business.  Since we own our hardware that is provided, in the solution, does Microsoft provide a Partner Program for discount Software to be used You might look into the Microsoft ISV Royalty Licensing Program at https://partner.microsoft.com/global/40012214 PS=3 . I hope that I've pointed you in the right ...Show All

• Ratheesh*MCP* Accessing OLE object properties (powerpoint 2020)

  Hello, I am trying to achieve the following in powerpoint 2002: Create a menu button that will add a ShockwaveFlash Object with certain property settings. Not being to familiar yet in using VBA, I would appreciate greatly a helping hand here. The code, shown below, is obtained via a macro and is attached to a menu button "FlashImport". It will show a little square representing the object on the slide. Now, while the object is ...Show All