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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by andols

  1. andols

    Problem importing text file to Excel

    Hi, I am tring to import a text file to Excel via VBA, I am working in ESRI ArcGIS Desktop. I recorded a macro when I imported a text file in Excel and sligthly manipulated the code and pasted in ArcGIS VBA. It is the code below. When I run it it opens a new Excel Sheet but instead of...
  2. andols

    Hoe to open a new (blank) Excel file.

    Hi I have code that opens a existing excelfile. Se below But how to open a new file, must I have the path to a *,xlt file? //Anders Dim MyXL As Object Dim objConn As OLEDBWorkspaceFactory Set MyXL = GetObject(, "Excel.Application") If Err.Number <> 0 Then ExcelWasNotRunning = True...
  3. andols

    Could not get the Column property. ComboBox

    Hi, You are rigth, I have 3 columns in my comobox. I looks like this Karlsro Karlskron 12312 Karlsro Olofström 34234 Karlstorp Karlshamn 9030 Karlstorp Karlskrona 12313 and so on But when the user print somthing that not corespond to a line in the combobox I get the error...
  4. andols

    Could not get the Column property. ComboBox

    No, I am sorry. I posted in wrong forum. I am working in VBA. Thanx for your response, Anders
  5. andols

    Could not get the Column property. ComboBox

    Hi, I have a problem with a ComboBox, I fill the listbox with data (two cloumns, name and identifier) and the user shall choose one of the post in the Listbox. But if the user print something else and press GO I wold like to be able to pick up that and exit the sub. Some thing like this...
  6. andols

    Could not get the Column property. ComboBox

    Hi, I have a problem with a ComboBox, I fill the listbox with data (two cloumns, name and identifier) and the user shall choose one of the post in the Listbox. But if the user print something else and press GO I wold like to be able to pick up that and exit the sub. Some thing like this If...
  7. andols

    Change font in Word with VBA

    Thanx The font and the underline works but not the table. //Anders
  8. andols

    Change font in Word with VBA

    Hi, I am using VBA to open a new Word document from another aplication. I am allso adding some text, and I want to change font, bold, italic, alignment and so on. I can change the font-name and -size but not if it Bold or the alignemnt. I am also trying to underline a row and add a table, but...
  9. andols

    Passing variable betwwen UserForm

    Mike, I use your tips with the globally declared variable, thanx for that. I guess I did something wrong the Class, I did not get it to work inside an UserForm either, I tried to declare the pEdit as Public in a Mudule but got a Error when trying to instatiet it there . //Anders
  10. andols

    Passing variable betwwen UserForm

    Hi, I press the wrong button as first, sorry for the blank post. Now to my problem, I am trying to send a varible betwen two UserForum. I tried to do this by using a Class, se code 'Class Option Explicit Private mvarvalue As String Public Property Let Edit(ByVal vData As String)...
  11. andols

    Passing variable betwwen UserForm

    Hi,
  12. andols

    Opening an Excel file in Access VBA

    Hi, I guess it dosent help you, but I am using the code below and it works for me. Im writing the code in ESRI ArcGIS, maybe that matters. Dim oExcel As Object Dim excWorkbook As Object Set oExcel = GetObject(, "Excel.Application") If Err.Number <> O Then Set oExcel =...
See more

Part and Inventory Search

Back
Top