Answer Questions

• OpticalMan Word 2003 Macros

  where to start My prob is to do with a vb6 app that uses Word as its reporting tool. The reports are created using .dot templates, with text file headers and datasources. Each template, (there's about 30 in total), has their own vba macros - mostly for formatting purposes. The original app was designed for Win 2000 op sys with Word 2000. All worked reasonably well until the client decided to change most - NOT ALL- of their desktops to XP and use ...Show All

• A. Marshall showing userforms in html format

  Hi everyone, I am currently using VBA in excel and I want to display my userforms in a html format, so users can use it. Can anyone help me please Also, is it possible to open my macro without having to open excel and then go to the visual basic editor Please help me!!!!! G.Holmes Hi, Sounds like you need to create a web page. Displaying VBA forms as HTML is a bit impossible. You an run macros without having ...Show All

• Corrupt65805 Problem with VBA script

  Dear all, Can you please help me with the following problem I wrote a script to get the data out from the SQL Server and then format the cells. However, it seems it doesn't run the part B to format the cells. Any idea Thanks. 'Part A : Get the data from the SQL Server sqlstring ="select custid, custname from customer" connstring = "ODBC;UID=uid;PWD=p123;DATABASE=prod;DSN=HK0001" With ActiveSheet.QueryTables.Add( ...Show All

• mcneil_eric VBA Excel Module opening Access DB with Recordset

  Here is the code: Dim cConn As ADODB.Connection Dim rs As ADODB.Recordset Dim sSql As String sSql = "SELECT Table1.Field1,Table1.Field2, Table1.Field3 FROM Table1 WHERE Table1.Field4 = Yes" Set cConn = New ADODB.Connection Set rs = New ADODB.Recordset cConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='\\path\files\folder\database.mdb'" Set rs = New ADODB.Recordset rs.Open sSql, cConn I get the same error on ...Show All

• Christian Jacob Need recommendation on Office/VBA/.NET/C# solution (cross-posting from the VSTO Forum)

  ****** The reason that I am cross-posting this from the VSTO froum is to reach the widest expert base. Thanks. ****** We want to move logic currently in Word XP VBA to C# component(s). What the VBA code basically does is calling Web Services that are implemented in Java, and display the returned data in Word documents. Our requirements are: improved performance easiness to install the components on end-user's PC's ability to be shared the ...Show All

• DMartin New to VB

  I have to do a project in VB Excel. I don't write code and it has been over 10 years since I took any programming classes. I have books on VB but I don't know where to start. I need to have our main invoice spredsheet update automatically when we get new invoices at the end of the month from our printing service. I know what I want to do but not how to code it. I would appreciate any advice. Thanks, Melissa ...Show All

• Yorro Superscripting in PowerPoint

  Does anyone know how to Superscript part of a datalabel in PowerPoint from Excel VBA. The following code works. With oGraph.SeriesCollection(rowX) For colY = 1 To .Points.Count .Points(colY).DataLabel.Caption = .Points(colY).DataLabel.Caption & "ABC" Next End With But I am unable to Superscript the "ABC". Here's some additional info from the engineer: ...Show All

• Ultan VBA in Office 12

  Could anyone show some information about VBA in Office 12 Does Microsoft support VBA in Office 12 Are there have any new features or improvements Thank you in advance!   Thank you for your information. Per earlier in this thread: "I just wanted to clarify some information on my original post. This info is direct from the product team. We are absolutely supporting VBA in O12. " We realize that our c ...Show All

• lastan06 Windows media files have changes to Nero

  Hi just wondering how I change my music files back to windows media player, they changed to nero flies last week after burning a CD. Hate the nero player, but love windows media player. Hope someone can help me Thanks Shihad P.S check out Shihad single    ALIVE   Thank you Sooo much.  WMP | Tools | Options | File Types  works for now. Thanks again.  You're awesome. RF Hi Rich, Here's anot ...Show All

• Nick Hertl 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

• Bernd Kicker EOF or BOF error

  Help! Why am I getting a EOF or BOF error after looping through only a couple of times Do While rst.EOF = False testNo_Rows = rst.RecordCount iPhoneNumber = CStr(Replace(rst("SUBSCRIBER #"), "-", "")) iAmountLoaded = rst("SUBSCRIBER TOTAL") iAmountBilled = iAmountLoaded + acct_Amt_allocate iStampDateTime = Now() rstMobileDevices.Open ("select Phone_Number, User_Id, first(Mobile ...Show All

• Osnimon work localy with database

  hello, i have a database on the network and when i run a function with many queries it works really slow. is there a way to copy the database to the local computer, make the queries and continue working on the database on the network other users also work on the network database so it's important that the file stays linked to that DB. please help... refael The speed problem could be the number of users or the database size ...Show All

• system.windows.forms.form excel vba

  Dim rng As Range Dim rngSelect As Range Set rngSelect = Selection For Each rng In rngSelect.Rows Selection.Offset(2, 0) = rng.EntireRow.Select 'need to add each modified range to selection Next rng I want all modified ranges to be selected in code It's probably easier and quicker to work with range objects, not the selection. Range supports Union and Intersect operators. Note: you will only be able to co ...Show All

• popson Best way to promote a new product?

  Started by Bob Walsh at 03-16-2005 11:31 AM. Topic has 2 replies.  03-16-2005, 11:31 AM Bob Walsh Joined on 03-16-2005 Posts 2 Best way to promote a new product We're a micro-ISV and have just released our first product, MasterList Professional , a task and project management app. We've applied for MS Office Marketplace inclusion, but what other ways can we get in front of potential ...Show All

• Pon_teh_pony Email from MS Excel

  With thanks to another poster I've managed to get the code below opening and sending an email from MS Excel. The only problem I'm having is I want the value from a particular cell in a worksheet to appear in the message body. This value is actually a formula and will change as the source worksheet changes hence it will differ each time an email is sent i.e. the value at time of sending will convey the message I require. My unsuccessful att ...Show All