automatically open a spreadsheet for the current day's entry
 

Hi

I use a running log in excel. Is there a wayy that I can get excel to open
up the log ready to enter data for the current day's entry?

automatically open a spreadsheet for the current day's entry
 

http://office.microsoft.com/en-us/as...872961033.aspx

There is an excelent tutorial on how to automatically open documents in excel.

"walkontheweb" wrote:

Hi

I use a running log in excel. Is there a wayy that I can get excel to open
up the log ready to enter data for the current day's entry?

automatically open a spreadsheet for the current day's entry
 

Thanks for the suggestion, but unfortunately I could find an answer fro my
query.

"Devin Linnington" wrote:

http://office.microsoft.com/en-us/as...872961033.aspx

There is an excelent tutorial on how to automatically open documents in excel.

"walkontheweb" wrote:

Hi

I use a running log in excel. Is there a wayy that I can get excel to open
up the log ready to enter data for the current day's entry?

automatically open a spreadsheet for the current day's entry
 

Hi,

Do you mean that you have one spreadsheet that you want opened each
time excel opens and then find the right place according to the date?

I assume you know how to save a file to your xlstart directory to open
it every time excel opens. Then you just need to add code to the
workbook open event to find the right place based upon the date, but
this depends on what you how your sheet is formatted etc.

If you require any more help I will need a bit more information.

Cheers,

James