Answer Questions

• blaflen Word: Normal.dot template menu bar

  I have programmatically modified the Normal.dot menubar (adding more dummy options), and I want to get rid of all of them, permanently, to return to the original state and appearance of Normal. dot.... How can I achieve that, please thanks Hi Brenda I attempted the procedure you listed regarding the re-naming of the normal.dot file : I went to the place you described, C:\Docoments and Settings\username\Application Data\Microsoft ...Show All

• StephenH VBA code in Dutch

  Hello I was trying since few days ago to figure out why some simple Excel vba code is not working for a dutch client. It seems that VBA has been translated to dutch Property like Textbox1.Left may be TextBox1.Links Please help me understand how can I have same runtime vba as my client as I tried everything an d still end up with english version. I installed Dutch office with no luck. Do I need OS in dutch also Thank you very much, Cristian Rus ...Show All

• Mike W in NZ xp style to vba forms

  hi, i would like to apply the xp theme to my msforms in (excel) vba.  i have not been able to find any information on doing this.  i saw this done in a stand alone xla so i know it works.  any help would be greatly appreciated. -b Hi, I believe the above examples only apply to stand alone VB applications - but maybe I am not understanding.  I was asking about getting the intrinsic ...Show All

• Titi des bois 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

• 永清吾心 VBA WORKSHEET

  COMPILE ERROR END IF WITHOUT BLOCK IF Sub EnterDates() Columns().Clear Dim EilDownloadSheet As Worksheet Set EilDownloadSheet = Workbook.Worksheets("Name of worksheet") Dim startDate As String, stopDate As String, startCel As Integer, stopcel As Integer, dateRange As Range On Error Resume Next Do startDate = InputBox("Please enter start Date: format (dd/mm/yy)", "Start Date") If startDate = &q ...Show All

• LFDIII Accessing a drawing through AutoDesk Volo Viewer

  Hi I need to open a drawing using the VoloViewer and print the same The Documents object the Viewer exposes is not working Dim vDrawings As Actrix.Documents Dim vApp As Actrix.Application Dim vDrawing As Object Set vApp = New Actrix.Application Set vDrawings = vApp.Documents Set vDrawing = vDrawings.Open("ANA-4004730_00_001.dxf") The code stops at the line above. I have tried using the AvViewX, but that has to do with the viewing of a drawing i ...Show All

• tomjanssen Serial Port communication from Excel 2003

  I am trying to write a simple VBA macro that reads Text data from a Serial port and puts it into an Excel 2003 spread sheet. The solution needs to work from a standard installation of Office 2003. I cannot use add-in modules since the envrioment has been locked by the SysAdmin. Can I make calls to windows API to communicate with the port from Excel Is there some sample VBA code that shows how to do this ...Show All

• Matthew Robertson Runtime error 1004 when adding a seriescole to a chart

  Hi all, this is a very stubborn problem of VBA and I have had to deal with it for years already: Excel version 2003 Error: Runtime error '1004' Unable to set the name property of the series class the macro creates several graphs with multiple seriescollections. Strangely, the first couple of graphs work perfectly! only after a couple of graphs the macro stops at the line ".Seriescollection(ibatch).name = batchfile(ibatch ...Show All

• kgooding Defining a range according to the number of responses

  Dear all, I'm a new user of Visual Basic (version 6.3) and need to write a Macro for use in Excel. I need the Macro to calculate Rank values for an unpredictable number of scores. The number of scores that need to be Ranked will vary and I don't know how to incorporate this variation into the Visual Basic Macro. In my current spreadsheet there are 11 scores (Sorted in descending order) in column DS (cells DS2:DS12). The Visual Basic cod ...Show All

• Barb M Word 2000 section page numbering bug? Any workaround?

  Hi, In a Word template macro I need to renumber page numbers of section 1 of the active document. Code is as follows:     With ActiveDocument.Sections(1).Headers(1).PageNumbers         .NumberStyle = wdPageNumberStyleLowercaseRoman         .HeadingLevelForChapter = 0         .IncludeChapterNumber = False    &nbs ...Show All

• Raj127799 Loosing Reference to Common Objects (i.s. VBA)

  Even though I have the VBA reference checked in VB I am not able to access the methods therin unless I actually key the VBA object first Anyone know why this may be happening Adding a reference allows you to access the methods but you would still need to fully qualify them Adding the imports statement allows you to avoid having to type in the fully qualified names. So if you dont put the imports VBA a ...Show All

• Mahesh Hegde VBA for Powerpoint

  Hi, I have been asked to modify a powerpoint presentation so that from a series of jpg files, one appears on the screen and then after a specific time period disappears and is replaced by another; this being a continuous loop on one slide only - like a photo tour. I have the following code, but need to get it up and running. Any suggestions: Sub ImportABunch() Dim strTemp As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As S ...Show All

• AZ17 Help with the application-defined or object defined error

    I am fairly new to programming I have a command button 1 in the spreadsheet however I keep getting an error message application-defined or object defined error.  I am not sure what this error means. What I want to do is set ninterval, rbedradius and xinterval to cell values shown below. I want to use a for loop and apply calculations. Later (not yet coded) want to put a condition on the third column of formulation. How d ...Show All

• Algosys Closing a dependent file in Excel97

  I am trying to set up programming for an Excel97 spreadsheet. Because the file (call it Alpha) takes a long time to save, I want to put the code in another file (call it Beta) and call it from Alpha. I have that figured out, and the references set up. The problem is that I want Beta to close automatically when I close Alpha. I tried putting a Close command in the Before_Close subroutine, but then I get an error message telling me that I cannot c ...Show All

• AdrianJansen GroupBox Borders

  I have looked on the online help files and community discussions, but haven't seen this question come up... Is there a way to set the border of a Groupox similar to what Panel does Panel will let you set Border Style to 3D Fixed etc. This property does not come up for GroupBoxes. I have seen VB screens that clearly are using GroupBox since it includes a caption on the top border and have a 3D type of border on them. ...Show All