Passing a variable from access to excel.

[Fuga]

Hi,

I´m trying to pass a variable (integer) from access to excel. I´ve tried both public and global in the declaration sector of a module, but it´s empty.

I´ve tried searching the forum but I couldn´t find it. I suspect it is a fairly common question.

Fuga.

 

[llkhoutx]

One way is to write/read to a scratch file. Another is to export/import a one cell table.