Answer Questions

• sendi Please help me to print the label for this condition

    Can anyone  plz provide me the Code for the following condition table structure: workorder      Maximum Serialno     StartingSerialno 101                       20                              1 102            &nbs ...Show All

• Jurgen Wondzinski vba in excel

  a dumb question, how do i incorporate the line below into my code nEndRowIndex = .Range("A2").End(-4121).Row Sorry for not understanding, been a long time since programming. Thanks John Hi John The for next loop does the scroll through and the new file names, I meant to change the 2 to 30 in the code I posted, also something went wrong with my paste as three extra lines were at the top. HTH ...Show All

• ccdev Compatability of VBA 6.3 and Visual Studio/Visual Basic 2005 Express

  To Whom It May Concern: I am about to study Visual Basic for Applications and I entered the article "Visual Basic for Applications 6.3 Features" ( http://msdn.microsoft.com/isv/technology/vba/features/default.aspx ), and apparently VBA 6.3 is on "parity with Visual Basic 6.0". Since I am studying the efficacy and effectiveness of Visual Basic 2005 Express, as well as beginning the exploration of Visual Basic for Applicatio ...Show All

• Sunil_pachunde Dialogsheets vs Userforms

  Hi all What are the disadvantages (or advantages ) of using dialogsheets rather than a UserForm in Excel 2002. Thanks Shasur Thanks Brenda Shasur Hi Shasur, Here's some information from our support engineer: For the diffrence between Dialogsheets and Userforms. They are for different use. Dialogsheet is a light weight simply form, for example, when you just need a win form but not want to build ...Show All

• cheeso VBA excel - problem with having clause in sql with adodb.connection/recordset

  Hi i am getting error in VBA excel when i am using having clause in the sql. i used adodb.connection and adodb.recordset. my problem is, i need to check duplicates in the oracle table. so i used the sql statement as follows select count(*) from table-1 having count(*) > 1 group by field-1,field-2,field-3. and string the count in a variable. var-1 = rs.fields(0). when i execute that i am getting error as runtime error : 3021 an ...Show All

• frank stone Strange Error

  I have an Access 2002 SP3 DB and on occasion it seems to corrupt and all forms are no longer accessable any 1 else had this problem i am unsure to what causes it so cant fix it. i open it and it reports a corrupt error offten after a change to some code has been made and saved i always test before before closing so i know it works fine then on next load it corrupts and the MDB file is reduced to only half its original size. any help or adv ...Show All

• wvbotha Reading From excel spreadsheet cell

  Hi all, i know this is off the topic but have been looking everywhere for an answer my code is as follows Dim xl As New Excel.Application Dim xlsheet As Excel.Worksheet Dim xlwbook As Excel.Workbook Private Sub Command1_Click() Text1.Text = xlsheet.Cells(16, 6) Text2.Text = xlsheet.Cells(2, 3) xl.ActiveWorkbook.Close False, "c:\book1.xls" xl.Quit End Sub Private Sub Form_Load() Text1 = "" Set xlwbook = xl.Wo ...Show All

• lildiapaz Runtime Error #13 Type mismatch

  Ok I have a speadsheet with a userform that adds data into the spreadsheet when the add button is clicked. This has worked fine and all of a sudden today it decided to give me a runtime error. Here is the code it seems to have a problem with. Do While Not Cells(row, col).row = Range("InsertRow").row frmDate = frmMonthlyExpenses.txtDate rowDate = Cells(row, col) row = row + 1 Loop I don't understand what is ...Show All

• JerPC Opening a Word Document from an Excel VBA Module

  As part of a complex Excel VBA module I want to open a Word Document (that contains a AutoOpen Macro)... I can open Word using "Application.ActivateMicrosoftApp xlMicrosoftWord", but I can work out how to open a specific document... I'm glad that it was helpful... I've forwarded your comment to the support engineer. -brenda (ISV Buddy Team) Brenda, Thank you very much. A succinct answer, and PRECISELY w ...Show All

• Duncan Hornby Excel Solver VBA Problem

  I have a problem with programming Excel solver using vba. I have the following micro in a workbook named "Book2.xls": Sub Macro1() ' ' Macro1 Macro ' Macro recorded 11/8/2005'     SolverOk SetCell:="$H$10", MaxMinVal:=2, ValueOf:="0", ByChange:="$G$10"     SolverAdd CellRef:="$G$10", Relation:=3, FormulaText:="$G$11"     SolverOk SetCell:="$H$10", MaxMinVal:=2, ValueOf:="0", ByChange:="$G$10"  &n ...Show All

• _Andrew MS Vista partnership/marketing program

  Does anybody know if there is a partnership/marketing program for ISV and specifically for game developers who are writing MS Vista "ready" sw If so where do I get more info cheers ADO Hi Ado, I just wanted to let you know that I am looking into this for you and will post what I find as soon as possible. -brenda (ISV Buddy Team) OK, here's a pointer to the current draft info on ...Show All

• Evan Hennis Business Scorecard Manager 2005 Webpart problem

  Problem with the Business Scorecard Manager 2005(Maestro) on an Analysis Services cube of SQL Server 2005 Apr CTP While using the Office Report View Webpart (Pivot Table) in WSS, cannot see the Toolbar with the Save option. So if i create a Pivot table with the Dimensions & measures, click another link and come back to this page, the Pivot table gets reset without any fields Any solution I think we are diverting from the query. I ha ...Show All

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

• Michael Nemtsev Vba commands used to connect to sql

  Thnx Derek... I tried the commands but an error message appear "ActiveX component can't create object" and i don't know how to solve this problem. Thats a bit odd... try the Open statement instead. Here's an example: Dim I, FileName For I = 1 To 3 ' Loop 3 times. FileName = "TEST" & I ' Create file name. Open FileName For Output As #I ' Open file. Print #I, "This is a test." ' Write string to f ...Show All

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