Strongm
Thanks ever so much for the info on Application.Filedialog.
None of us can "Know it All" and I certainly don't. Now I know a little bit more.
This will certainly do the job for me.
Thanks again.
Frederico
It looks like you have not done very much internet searching.
600,00 hits means nothing. None of the 600,000 hits I get have anything to do with what I am looking for.
If you know of anything out there that simply browses a network and returns a selected path, I would greatly...
I need to add children and set the attribute for a node where it is the second instance in a family of nodes.
But I cant seem to find a way to "SelectSingleNode" so that I can add children and set attributes.
This is what I have created so far:
<Markers ObjectID="22"...
I Encounter "The subject is not trusted for the specific action" when attempting to place a data grid on a form (msdatgrd.ocx). The control is not placed.
I enabled the ocx using Active x manager but the condition does not change. I verified that the setting in the registry is set correctly (0...
Hugh,
The application I am using is not Outlook, it is Internet Explorer at a Outlook web page.
The title bar is "my name Outlook web app Microsoft"
It shows a number of e-mails on the page but only one is highlighted. That is the one I need the subject line text.
Mike
I need to capture text in an Outlook web app IE e-mail program.
The text to be captured is the highlighted e-mail (which is yellowish / orange)
I need the VB application to run formless / in the background and return to the calling program the text of the highlighted e-mail.
I see a lot of...
I have the following task for a VBA program to run after opening a word doc attachment in a Microsoft Exchange internet server. eg https://abcdef/exchange.com
1. Obtain information within the doc to determine WHERE to store it locally and the NAME for the file (Which I already wrote and works)...
Heres my task: Open an e-mail attachment that is a word doc from a web -browser based exchange server (eg at www.blabla.com/exchange), run a macro that saves the doc locally, close the IE window and document, and open the same document in WORD.
I open the document so that I can run a word macro...
All,
MY BAD!
I was looking at the wrong copy of a modified csv file.
The test was to a file where the actual name of the field is "First name" not "fname".
Thanks very much for the help.
Mike
Skip,
"fname" is a valid field name as seen in the catalog function of WinSQL and in the first line of the file.
Is there a different way to specify a field?
Mike
I spoke too soon,
I changed the query to "Select * from people2.csv" to ... where fname='bob'" and I get an error "Too few parameters. Expected 1"
Now What??
Mike
keenanbr,
Your example works!
Although I had to make changes:
This:
Public m_adoCsv As New ADODB.Connection
Public m_adoRst As New ADODB.Recordset
To:
Dim m_adoCsv As New ADODB.Connection
Dim m_adoRst As New ADODB.Recordset
This:
m_adoCsv.ConnectionString = "Provider=MSDASQL.1;Persist...
Skip,
I made a reference to "Microsoft Active X Dat Objects 2.8 Library".
Now I get an error on "cnn.Open sConn" My file is C:\Temp\People2.csv. I changed the following to:
sConn = sConn & "Dbq=C:\temp\people2.csv;"
Is this right?
Mike
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.