Search results for query: *

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

Could you point me to a good one, still searching, not finding anything. Thanks

I have been looking for code to browse a network for files but can find none. Does anybody know of any code to do this?? Thanks

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

Skip, I copied and pasted the query---"Too few parameters. Expected 1" 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...

keenanbr, After making the MS active x ref I now get an error on "m_adoCsv.Open" "Data source not found..." Mike

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

My file is C:\Temp\People2.csv The first row is the field names (as done in a lot of csv files) I need to query this "Table" Mike

Keenanbr, I encounter an error on the line "m_adoCsv.ConnectionString = "Provider=MSDASQL........... "Object required" ????? Mike

Skip, I encounter an error on the second statement (Dim rst As ADODB.Recordset) "user defind type not defined" ??? Mike