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!

  • Congratulations strongm 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: *

  1. paulpayne

    Excel Macro -- Open specific file?

    If you put a debug.print line in after the strFilename line, this will give you the text of the file you are trying to find, maybe the text is not quite right. i.e. c:\datarefresh.txt instead of c:\data\refresh.txt
  2. paulpayne

    Oracle connection module

    Thanks for all the replies, I am will get this working in the module first, then I will add it to either a class or an add-in. Thanks for your help. PP
  3. paulpayne

    Excel Macro -- Open specific file?

    I think you could use this. sub currentdirectory() dim strCD as string dim strFilename strCD = ActiveWorkbook.Path strFilename = strCD & "\Refresh.txt" ....rest of code here.... end sub
  4. paulpayne

    Oracle connection module

    Thanks for the replies, Skip the code you posted works, but it only returns one field, I need to return a recordset of data from different tables i.e one call could be to the client table and another could be to suppliers table. I am not sure how to return a recordset??? Thanks Paul
  5. paulpayne

    Oracle connection module

    Thanks Geoff, I could look at putting this in an add-in, but I need to first find out how to get the recordset returned from the called module???
  6. paulpayne

    Oracle connection module

    Hi, I am trying to create a generic module to take an SQL statement as an argument and connects to an oracle db, which then returns the resulting recordset back to the calling module for processing. I have managed to create the connection to retrieve a recordset, but I have to repeat the code...

Part and Inventory Search

Back
Top