Answer Questions

• Laura Badinelli Problem with MS Updates on New Dell

  I have a brand new Dell XPS Fully Loaded and Upgraded, but there is one MS security update that will never load. I have Windows XP Media Center Edition 2005. I also have PC-Cillan Micro Trends Antivirus/Firewall Internet Security Protection. Below is the update that I am not able to get as it fails every time. Security Update for Microsoft .NET Framework, Version 1.1 Service Pack 1 (KB886903) Failed to install The other issue I have: ...Show All

• ColtTaylor Distributing a Macro across an organization - how to delete existing .bas files within a .dot file?

  I have been maintaining a large macro within my workplace.  It is basically a find and replace macro that let's the users easily create client documents.  It is housed within the Normal.dot template and contains a "MyName" module and "AcctMgr" module.  I have just completed an upgrade and I simply want to replace the "AcctMgr" module with a new one.  Replacing the whole Normal.dot file just causes too much pain for the person ...Show All

• Fabricio Voznika [MSFT] Collections Class For Each Next

  I have created class modules in my Excel VBA project that each include a private collection object. I am trying to leverage the "house of bricks" model whereby the class will only add and return an instance of a specific object. My problem is that from the code module that creates the instance of the collection class I cannot use For Each...Next iteration to step through the collection. In VB6, I've used NewEnum to return an IUnknown a ...Show All

• Kosmosniks tables

  Hi, I'm trying to write a few procedures in VBA concerning tables - is there any way of accessing the text contained in the tables without actually having to select it in the document akso, is there way through which I can detect where I am in a table, i.e if the cursor is in cell (2,3) is there any way of detecting this same about foot/end notes - Is there any way of finding out which footnote I am editting (for instance, if I should want to ...Show All

• gkochanowsky Linking tables to databases in code

  I have a database designed in Access 2003 for which I used the 'get external data' option to link (not import) data files. However, I would like to save the database 'unlinked' and have the code link the tables when it's run. This is so that when I run it on another machine, I can specify a path for where to find the tables with the database in runtime mode. Can you help Ollie VB Ok this isn't a complete solution but I'll give ...Show All

• Ammarma Setting ASP.NET Configuration in IIS

  hi, im currently working in setup and deployment project using custom installation with System.Configuration.Install; a have already created several custom installation classes, but i have one problem. my deployment includes 2 different versions of .NET which is 1.1 and 2.0. i have created everything including modification of web.config, installation of databases, and Creating Website, Virtual Directory and Application Pool ...Show All

• Tushar Nene Avalon Adaptation

  Scenario Lets say that Avalon is released for XP (and in Longhorn) on time, Holiday season 2006, and that it is accepted as “wonderful” like we all know it will be. Question: How rapidly will it make its way onto the corporate desktop What percentage of corporate desktop machine will have Avalon install one year later, two years Are there any moderately reliable figure that we can use in our sales projections Anything will be helpful Tha ...Show All

• Imperabe WIA: problem shooting picture

  Hi together! The device is recognized. The digicam shoots a picture and saves it on the the memory card. But the returned WIA.item is always 'nothing'. Is anything wrong in the following code Thanks a lot for your help in advance! Armin --- Public Function shootPicture() Dim dev As WIA.Device Dim CommonDialog1 As WIA.CommonDialog Set CommonDialog1 = New CommonDialog Set dev = CommonDialog1.ShowS ...Show All

• angelok Excel 2000 - macro not found

  I developed an Excel 2003 spreadsheet with an embedded worksheet form button with an assigned macro written in VBA. The Excel file is hosted on a web server. User will open the Excel file from a web page via IE browser. Customer's Thailand branch office says it doesn't work. So far we tested with Excel 2003 in Singapore branch and no problems at all. I found out that the Thai branch users are running Excel 2000, but don't know if there a ...Show All

• Bobby Fu tables

  Hi, I'm trying to write a few procedures in VBA concerning tables - is there any way of accessing the text contained in the tables without actually having to select it in the document akso, is there way through which I can detect where I am in a table, i.e if the cursor is in cell (2,3) is there any way of detecting this same about foot/end notes - Is there any way of finding out which footnote I am editting (for instance, if I should want to ...Show All

• gypsy66 your view on product roadmaps

  I'm curious to find out what your views are on product roadmaps... 1. Valuable or not 2. What is more important - being able to see the product integration or the estimated timelines or both 3. If you currently work with a product roadmap, what format do you find most useful - interactive/online, PDF, other Textual display or visual thanks, -brenda (ISV Buddy Team) To answer the question from the standpoint of a ...Show All

• amber1 Summing on varying number of rows in Excel using VBA

  Hi there, I'm trying to do a sum on a varying number of rows in a column. I have to do this for a number of worksheets but I'm focusing on getting the code right for just one of the worksheets right now (the active one). At the moment the starting row for all data in these worksheets is Row 7. Example: Sheet1 row 7 - 2 row 8 - 10 row 9 - 5 Sheet2 row 7 - 8 row 8 - 12 row 9 - 14 row 10 - 20 row 11 - 4 row 12 - 6 The module is ...Show All

• KAL9 Hyperlink to a subroutine

  Is it possible to get an hyperlink to run a subroutine I managed to get the hyperlink to go to the subroutine but it doesn't actually run it. It is possible to hyperlink to code from within MS Excel. Try this::: Open up your VBA editor and locate the "Microsoft Excel Objects" folder. Double click the SHEET object where the hyperlink is located. You should see an empty editor area with the words "Option Explicit ...Show All

• avhavh Runtime Error '1004': Copy of method Worksheet Class Failed

  I have a function designed to create a new worksheet by copying and pasting a template. It works fine for the first many sheets, but beyond a certain number of worksheets, it fails. I am confident that I have ample memory to continue creating new worksheets, however, at a certain point i get Runtime Error '1004': Copy of method Worksheet Class Failed . Here is the function I am calling: Function MakeNewSheet() As String Dim shtcount As Integer ...Show All

• Luc C Control of graphs and organization charts

  Greetings to all! How can one control properties and methods of graphs and organizations charts For example, I am trying to change the background colour of  a graph in a Powerpoint slide through a Macro command, or modify any kind of object in an organization chart. I am guessing I need to create a reference to the graph object and then access its properties through it, but have been unable to do so. Thanks in advance for any help or s ...Show All