Macro to open a excel

[Richyog]

Hi,

I want a excel macro that can open a text file and run it accordingly.

To be brief I want a macro so that i can press button and it takes me to the destined location and takes text file from there.

Response will be appreciated.

 

[EXCEL-lence]

So you're after a "navigate to" type of function, to then open the text file from that location?

How do you specify the destined location?

 

[Richyog]

Hi,

I mean If i am having a text file in a folder on desktop & i want that my macro should take that text file from there and run it.

Suppose I am having a macro button on my excel sheet and after pressing it i will be taken to the location where i had put my text file