View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Duncan[_5_] Duncan[_5_] is offline
external usenet poster
 
Posts: 290
Default Opening a xls for append

Hi all,

I am using some code to put data into a sheet that will hold all users
entries, but i want to to move (tab) to the next cell as at the moment
it will only put the whole lot into one cell and the next lot into the
next cell down and so on.

Any suggestions?

Open "path" & "\data.xls" For Append As #1
Print #1, Application.UserName; " Started doing task1 at "; Time()
Close #1

Duncan