Initialize an excel datasheet

[aine_canby]

Hi,

I need to read a file when a datasheet is opened, and store the value
read within a global variable (in Sheet1). How do I do this?

Thanks,

Aine.

 

[aidan.heritage]

Hi,

I need to read a file when a datasheet is opened, and store the value
read within a global variable (in Sheet1). How do I do this?

Thanks,

Aine.

It depends on what you mean by read a file - did you want to open it
for input, is it an excel sheet? Something like

open "c:\test.txt" for input as #1

input 1, a
close
range("C1").value=a

 

[gimme_this_gimme_that]

Either save it in the Templates directory or in the StartUp directory.