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...
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...
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,
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 =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.