Answer Questions

• Developers - Dany Acosta Method 'SnapshotPrint' of object 'ISnapshotViewer' failed.

  I have code that is printing a snapshot file. This code works fine on a number of PCs, but on others it does not. On those PCs where it does not work I get the following error: Method 'SnapshotPrint' of object 'ISnapshotViewer' failed. or Method 'SnapshotPrintDirect' of object 'ISnapshotViewer' failed. I found Microsoft article 224002 which says to add "File://" to the beginnig of the SnapshotPath string. I have done that ...Show All

• APSrinu Installing Business Scorecard Manager 2005 on a SQL Server 2005 instance.

  I'm trying to install BSM 2005 into a Win/2003 Server running SQL Server 2005 (everything) and the Web Service won't install because it reports the following: Failed Microsoft OLE DB Provider for OLAP Service (MSOLAP) 2000 SP4 (8.00.2039) as well, the Alerts won't install because of the message: Failed Microsoft SQL Server 200 Notification Services 2.0 SP1 Engine Components I understood that this version was compatible with SQL 2005. Any idea ho ...Show All

• Bishwajit Aich Business Scorecard 2005 Installed - Just cannot connect to Analysis Services database

  Followed the readme for installation step by step. Installed the Server and the Builder on the same machine - db is SQL Server 2005 April CTP.  - Will the Business Scorecard work with the April CTP  - Launched the BS Builder and when trying to connect to a ADOMD.NET datasource, in server specified the <Servername>, the database dropdown always comes blank.....error "could not connect to data source" (Analysis Services is run ...Show All

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

• linkcd Just curious (an Excel VBA question)

  Is it possible to have a userform on an excel workbook add information into the code itself Here is what I am looking at. I have a workbook that has a user form. In this user form is a dropdown combo box that has account numbers in it. What I want to know is is it possible to allow a user to add information into the combo box (such as a new account number that will be used often) and have it so that it is listed the next time the user uses th ...Show All

• James Atkin Excell VBA: displaying values from the sheet in user form

  A simple question probably, but I got stuck on it. I have a user form that allows users to select and run some reports and what I'm trying to do is to put on that form a value from one of the sheets that will show the latest report date used. I tried with the text box and label on the form: Trx_Date = Sheets("Trx_Reg").Range("K1").Value Trx_Reg_Date.Caption = Trx_Date where "Trx_Reg_Date" is the text box ...Show All

• Neil_F Passing arrays as parameters in VBA Excel

  Hello. This is my first post here. I have googled and rtfm'd the following to death to no avail. Excel VBA under WinXP Pro Problem: I have an array of variants declared thus - Dim avarMyArrray() as variant I have a subroutine into which I want to pass the array. I have attempted the suroutine call thus - Call myRoutine(avarMyArray()) Call myRoutine(avarMyArray) I have attempted to receive the call thus - Sub myR ...Show All

• AmyY Help with DDEPoke

  Hello, Again I have two workbooks called Server.xls and Client.xls. Client.xls has a button called SendData which executes the code below. Private Sub cmdSendData_Click() lChannelNum = DDEInitiate("Excel", "[Server.xls]Sheet1") DDEPoke lChannelNum, "R1C1", "Saleem" DDETerminate lChannelNum End Sub The problem is cell(1,1) in Server.xls does not get set to "Saleem". Any ideas ...Show All

• vital Need help with opening and closing recordset objects

  I recently converted my access application to an ADP and am having some errors with a simple procedure im trying to write off a click event. I think the errors have to do with how I am opening and closing the recordset objects. I know that is a bit vague but i wanted to see if anything stands out as incorrect. Please see below...Thanks. Private Sub Add_Record_Click() On Error GoTo Err_Add_Record_Click Dim cn As New ADODB.Connection Dim rs1 As Ne ...Show All

• Masud Moshtaghi Detect Excel Version in VB6 Application

  Hello Everybody I need your help, I have and application in Vb 6 and I need detect what's version and language of Excel have install in the computer. Help me.... thanks Ifgash Ifgash@yahoo.com Look up "language" in the VB Editor's Object Browser. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/ Hello Ifgash OK for the version you can do something l ...Show All

• ChrisBCritter Icons In ListBox

  Hi dears I want to add icon to the items of VB.NET 2005 ListBox , Could i do ... Hi all, Thank you very much Derek Smyth. Hi, Don't use a listbox use a listview instead. You'll need to set the View property to List in order to get the listview to look like a tradition listbox. The listview control contains a collection listview items, and each listviewitem contains a collection of s ...Show All

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

• Shorin Data Monitoring Application...

  I have been developing a windows forms application that monitors and controls industrial processes(ie. temperature, humidity, flow). My app needs to dynamically display data to the user in a graphical format. I thought SVG was my answer. I have spent the last 6 month developing my app around the Adobe SVG active X control. It was perfect, I could directly manipulate the SVG dom, and it would automatically change the graphic on the screen. Well, ...Show All

• ecast VBA for Outlook: How to create a Hyperlink via Macro

  Hi everyone! I am trying to use VBA in MS Outlook to create a Hyperlink via a Macro. Can somebody please help me Please, please, please... Here is what I'm trying to do: The situation is, that I often get emails saying sth like: "Your file is at h:\file collection\marc" Normally I would then mark the path, copy it and paste it into the windows explorer. This works fine but I was thinking about how i can spead this process up with a mac ...Show All

• ashw Function which get range arg.

  Hi all, i wrote a simple function, which get a range variable, and return 1 if the range color is yellow (colorindex = 6) that works fine, but when i change the color of the range, the function does not "refresh" it self. example: 1. i painted cell a1 in yellow. 2. in cell a2 i wrote: "=paintRange(a1)" and the function paintRange goes like that: fuction paintRange (r as Range) If r.Interior.ColorInde ...Show All