Search results for query: *

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...

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...

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...

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

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...

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...

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

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...

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

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)...

Hi,

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 =...