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

Search results for query: *

  • Users: andols
  • Content: Threads
  • Order by date
  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, 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...
  4. 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...
  5. 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...
  6. andols

    Passing variable betwwen UserForm

    Hi,

Part and Inventory Search

Back
Top