Answer Questions

• VSCurtis 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, The following is the code that was causing the a ...Show All

• Execbask1 Adding a table column using VBA in Access

  Hello, I was wondering if it were possible at all to add a column to an already existing table using VBA code. It seems like a simple enough procedure, but I can't seem to figure out how to do it. I'm beginning to wonder if it's even possible. Any help would be appreciated, thanks! CJ I've actually solved the problem. It was pretty simple, like I figured it would be. I'll go ahead and post the code in ...Show All

• umler macro for creating chart in excel

  Hi all, I'd like to write a macro in for excel to create automatically a chart, i have no experience in this field. I use the following code: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 8-6-2006 by CTW ' ' Keyboard Shortcut: Ctrl+m ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.ChartArea.Select ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R1C1:R2C1" ActiveChart.SeriesCollection(1).Values ...Show All

• dundask Problems with DAO and SQL Server

  I am trying to return a DAO recordset from SQL Server so that I can use CopyFromRecordSet to populate some data in Excel 97. The below creates the recordset but the CopyFromRecordSet fails with : error -2147467259 (80004005) Operation is not supported for this type of object If I change to another database (SpecData) and change the strSQL to select a table without the owner prefix the code works. The permissions on the two databases are id ...Show All

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

• ewebull How do I do to work with two XML files in VBA

  Hi, I'm doing a simple use of XML and trying to display the results in MS Excel. in the moment I have one XSLT that compares datas between two XML files and I'd like to know how to do to view the final datas from this comparation, in Ms-EXCEL, to be worked by other sheets. By now I don't have any idea how to do it (work with 2 xmls + 1 xslt), I already  do transform using an XML and a XSL file and it works nice, but now Coul ...Show All

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

• Dan1 How to check the TCP/IP checkbox in network connection property window?

  hi, guys In windows, network connection window, in the property of a connection, It has Client for Microsoft networks, File and Printer sharing, Internet Protocol (TCP/IP) three checkboxes, is there any way to check/uncheck these in script Thanks, Here's some additional input from the engineer: Writing a network driver is a lot of work, this may cost ISV a lot. If our ISV is interesting in doing this, ...Show All

• E. Woods worksheet_change

  I try to do a macro that reacts when i change the interior color of a cell. Worksheet_change seems to only react then the cell value is changed. Is there any other way 'Private Sub Worksheet_Change(ByVal Target As Range) ' 'If Target.Interior.ColorIndex = 4 Then ' MsgBox "bla,bla, bla " 'End If ' 'End Sub thanks in advance agron Not sure if this will work OK, it seems to on a simple sheet I created. I ...Show All

• Abhijitkane Business Scorecard Manager 2005 database problem

  Hi, I’m having a problem with my Business Scorecard Manager 2005. It’s installed, but it doesn’t make a connection with the database (SQL 2005 Enterprise). Even with the templates that it already has, the connections that he tries to make are to tables that do not exist. If i try to create a connection string to an existing database, it also gives me an error. How can i solve this Thanks Hi, Actually, your ...Show All

• Manjula Praveen Business Scorecard Manager 2005 Beta 2 Setup

  Hello All, While running setup for the Business Scorecard Manager 2005 Beta 2, when I get to the feature requirements analysis under web parts, I get the message "Failed Microsoft SharePoint Extended Site" and I can't continue with the setup. How do I go about this in order to continue Regards, Sam. Per one of our support engineers: It’s a break/fix problem. Here’s my update: 1.        BSM is base ...Show All

• mmtbb how much

  I don't exactly understand all MSDN offers... trying to figure if it's worth membership costs, and what that cost is. We develop software that integrates with MS MapPoint, and are looking into developing a solution for inventory/accounting/servicetrends/etc, for which our customers would need to buy the Microsoft compents to plug in. How much is each msdn user license Hi, I just wanted to let you kn ...Show All

• lovely Opening Ports

  Im sorry if i posted in the wrong place, but i didnt know where to post. Ok well this may sound like a stupid question but, well i have a server on my computer, and i would like to be able to make it online [DNS or whatever its called] so other people could view it, but the problem is that i have a router and such, so there are some ports i need to open to be able to get my server online. If anyone could help me, please do so, it will be much ap ...Show All

• ClaudiaN Custom button on control bar

  I have a custom contorl bar button and it is connected to an addin. When my addin is first loaded the button is first displayed in the middle of the screen. I then need to drag it to the control bar. Is there any way I can code it so that it goes straight to the control bar and not in the middle Note: I have also asked this question at http://www.ozgrid.com/forum/showthread.php t=51966 Thank you ...Show All

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