Open File within a macro

Tech-Archive recommends: Fix windows errors by optimizing your registry

I would like to know the code (to put within some other code), which will
run the Open file dialogue, & pointing to the desktop, so that a text file
can be selected.
(Then, I need that selected text file opened so that the macro will do some
action on that file and revert back to the workbook for mor action.)
I found something in help, which opens the dialogue box, but it does not
open the file, just brings up a message box that tells me the file I've
selected.

Furthermore, is there a way for that code to point to any desktop no matter
where it is located in the Windows Explorer tree? (As I plan to use the
workbook on various machines.)

Rob


.

Relevant Pages

  • Opening a Word Document
    ... Brand new, XP Pro, Office XP Pro, all the latest patches, ... but whenever you use the open file dialogue box it takes ... >I am having trouble opening word documents on my ... If word opens, I need to double click on my ...
    (microsoft.public.word.docmanagement)
  • RE: Opening a Word Document
    ... I tried loading the XP Service Packs, but I get an error that says "The expected version of the product was not found on your system" ... > but whenever you use the open file dialogue box it takes ... >>I am having trouble opening word documents on my ... If word opens, I need to double click on my ...
    (microsoft.public.word.docmanagement)
  • Re: Open File within a macro
    ... the Help offering will give me whatt I need. ... run the Open file dialogue, & pointing to the desktop, so that a text ... some action on that file and revert back to the workbook for mor action.) ... I found something in help, which opens the dialogue box, but it does not ...
    (microsoft.public.excel.misc)
  • Re: Open File within a macro
    ... Dim FileToOpen As String ... run the Open file dialogue, & pointing to the desktop, so that a text file ... some action on that file and revert back to the workbook for mor action.) ... I found something in help, which opens the dialogue box, but it does not ...
    (microsoft.public.excel.misc)
  • Re: Opening a Word Document
    ... >>but whenever you use the open file dialogue box it takes ... >>responding. ... If word opens, I need to double click on my ...
    (microsoft.public.word.docmanagement)