Text File using MACRO

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hello,


I will appreciate if someone assist me in order to solve the following
problem.
I want to read an operating system file from EXCEL sheet.
The information in this text file appended each day. That’s why
I want to use Macro to read this text file which is located on
c:\SEDAN\INFO\Mit.log.
What steps should I follow in order to read this text file using
MACRO.
Each time when I run the MACRO it refreshes the information from the
text file and display its information into Excel sheet.
Could you please check that matter and give me its solution?

Regards

David.
 
Start a new workbook.
Record a macro when you open that file manually.
do all your formatting and page layouts (and as much other stuff as you can)
Stop recording the macro

Save the workbook with the macro.

When you need to re-open that text file, just open this macro workbook first,
then
tools|macro|macros...
select your recorded macro and click run.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Word to Excel: Export comments with text and line number 0
Run Macro Automatically When Excel 2003 Opens 2
How do you do the following using VBA macro automatically? 1
Excel 2007: Help creating a macro that will run Solver? 3
Excel Query setup 0
Macros Doubt 1
Help to create a macro 2

Back
Top