Web Server Logs

  • Thread starter Thread starter Warrick FitzGerald
  • Start date Start date
W

Warrick FitzGerald

Hi All,

Our web server generates a log file wich I open in excel almost every day.
The log file is space seperated and has an extension of .log

Every time I open the file I run through the procedure of telling excel ..
yes this is a space spepated file and no don't treat consecutive spaces as
one ... bla bla bla.

Is there no way to tell excel that these are the default setting for a
..log file or some other faster way that would not force me to go throuhg
this process every time I open one of these files?

Thanks
Warrick
 
Warrick,

Use the macro recorder to record the whole process of opening any of the log
files. When you have finished your recording, go to the VB editor, and in
your macro insert as your first line the following:
LogToOpen = application.GetOpenFilename
then in the Open statement recodred, substitute the log file name with
LogToOpen (without quotes). Save.
Next time you run the macro you will see the familiar Windows' Open File
dialog box. Select your file and you're done!

HTH,
Nikos
 
Back
Top