Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jrice174
  • Content: Threads
  • Order by date
  1. jrice174

    How do I add a grid to a user form

    I'm still using Excel 2000 and I'm trying to use a grid on a user form. From What I've seen online, a flexgrid looks troublesome, so I think the best is to use a spreadsheet control. Whenever I try to add a spreadhseet control I get the error message "the subject is not trusted for the specific...
  2. jrice174

    How do I refer to a control on another form

    I am trying to perform the same function on combo boxes on different forms. I have 2 string variables called ControlName & FormName (i.e. FormName = "frmSchedule", ControlName = "tboDate"). I can use the frmSchedule.tboDate.value and it works fine but I'm trying to assign the form and control...
  3. jrice174

    AutoCAD VBA DWGProps vs SummaryInfo

    I'm trying to gather information on files in a directory without opening the files. I can get the data on Word, Excel and other files with no problem. I can use DWGProps to get some of the AutoCAD data but it doesn't appear to work beyond AutoCAD 2204. Can I use summaryinfo to get the file data...
  4. jrice174

    AutoCAD VBA rubber banding

    In a VBA program when I have the user select an area on the screen, I call the GetUserPoint twice (to get both points) and then call the SelectByPoints sub. Doing this, the user does not have rubber banding as they move the mouse from their first selection point to the second. It seems as if...
  5. jrice174

    multiple lines in a text box

    I've seen what I want in other programs but I'm not sure what it is. It appears to be a textbox with multiple rows and columns. I want to display 2 columns of numbers with as many rows as I need to dislay. A scollbar on the side allows the user to scroll to the position they want and change any...
  6. jrice174

    adding a layout tab per template with VBA

    I'm trying to add a layout tab to a drawing from a template. I've already got it to create the drawing from a template as shown below, but how do I add more layout tabs with the same template? Here is what I have to create the drawing from the template ThisDrawing.SetVariable "SDI", 1 'Single...
  7. jrice174

    How can I get polyline properties with VBA?

    I'm trying to find the length from one point on a polyline to another point on that polyline. The polyline is only made up of lines and arcs. The polyline.coordinates does not give me any arc information. The Autocad LIST command will give me the arc information but I can't figure out how the...
  8. jrice174

    Can I save variables as part of and Excel file

    I'm trying to save some program data so that the next time I run a VBA program the form has some of the controls set as they were the last time it was run in that document. I know I could create a separate worksheet to store it but I'd really like it invisible. In Word I can use...
  9. jrice174

    How do I open an AutoCAD file from Excel?

    From Excel I want to use the GetOpenFilename method to open an Autocad file. Below is what I have but it certainly doesn't work. any ideas? Dim NewFile As String Dim ACAD As Object Dim MyPath As String On Error Resume Next Set ACAD = GetObject(, "ACAD.Application") If Err <> 0 Then...
  10. jrice174

    Can get carriage return to work

    I have an automated Word document that looks to an Excel file where I am saving lines of text. I use strVariable = ExcelSheet.Cells(i, 2) to get the text in the file but it doesn't see the carriage returns. I've tried vbCr and vbLf and Chr$(10) but nothing seems to work. I have "this bit is...
  11. jrice174

    How can I display the selection window in AutoCAD?

    In AutoCAD, if you are going to select a group of objects to move/erase, an expanding selection window is displayed as you move the cursor from the first picked point to the second point to allow the user to visualize the entities that fall within the selected area. How do I get this expanding...
  12. jrice174

    Can I save a spreadsheet without the VBA code?

    I have a small VBA progam in an Excel spreadsheet that helps the user set up the worksheets. Once they save the spreadsheet to a new file there is no use for the program but it still gives the Disable/Enable Macros warning. Is there a way to save the Excel workbook without the VBA program?
  13. jrice174

    is there a Spanish equavalent to vbYesNo

    To define a message box I usally do the following: Style = vbYesNo + vbCritical + vbDefaultButton2 The latest program I'm working on is going to be used by Spanish speaking customers and I need for the buttons to be labeled as Si/No rather than Yes/No. Is there a way to make the msgbox function...
  14. jrice174

    How do I copy a worksheet and change its name?

    I have some template worksheets in a workbook that I want to copy. The templates names start with "zz" to differentiate them from the other worksheets. I want to copy worksheet named "zzThisworksheet" to "Thisworksheet" and leave the "zzThisworksheet" unchanged. The code below does make the copy...
  15. jrice174

    Can I &quot;Send to Back&quot; using VBA?

    In a VBA program, the last item I drew appears on top of an item I drew before that. Is there a way (other than changing the order that I draw them) of sending a LWPolyline to the back?
  16. jrice174

    Can I change some coordinates in LWPolyline with VBA

    Can I change certain coordinates of a LWPolyline using VBA? I'm trying to raise certain Y coordinates by 4". I've written the below code which seems like it should work but it doesn't do anything. For i = LBound(objLWPoly.Coordinates) To UBound(objLWPoly.Coordinates) - 1 Step 2...
  17. jrice174

    Wrong module is displayed when opening program

    When I loaded a VBA program in AutoCAD and hit alt-F11 to view the VBAIDE, the userform was shown and I could just hit the run button to run the program. I have since added a class module to the program. Since adding the class module, when I load the program and enter the VBAIDE, the only thing...
  18. jrice174

    Use VBA in AutoCAD to add layout template

    I can easily add a layout to an AutoCAD drawing with ThisDrawing.Layouts.Add "Sheet1" But what I really need to do is add a Layout From Template. Does anybody have any idea how to do that?
  19. jrice174

    Accessing Ole object data with VBA

    I have an embedded Excel spreadsheet on each layout tab of a drawing. I need to select, open and read the spreadsheet. Is there any way that I can select these OLE objects with VBA?
  20. jrice174

    How can I detect a tab or carriage return in combo box

    On a VBA user form I have some list boxes and combo boxes. As the user enters data and then hits a tab or carriage return to go to the next box I would like to sense the tab or carriage return so I can use that data immediately. Is there an event that I can use or a way to sense the carriage return?

Part and Inventory Search

Back
Top