View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mliungman mliungman is offline
external usenet poster
 
Posts: 1
Default Passing variables between workbooks


Hi!

I'm using a "Create signature" macro in a file on our server, to create
individual signatures in various excel workbooks.

Let's say I'm in a workbook that needs a signature. I want to select a
cell where the signature is to be inserted, and then call the macro in
the "Create signature" workbook. My problem is that I don't know how to
make the "Create signature" macro know which workbook is waiting for a
signature. Creating a global variable won't work, and I'm not familiar
with passing variables between workbooks.

Please advice!

Martin


--
mliungman
------------------------------------------------------------------------
mliungman's Profile: http://www.excelforum.com/member.php...o&userid=30397
View this thread: http://www.excelforum.com/showthread...hreadid=500670