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.

On 1 Aug, 13:27, wrote:
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

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