View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
edfollett[_2_] edfollett[_2_] is offline
external usenet poster
 
Posts: 1
Default Opening EXCEL with additional Parameters


Hey all,

Yet another question from me!

Basically i have an excel spreadsheet that will be distributed an
generated by a bespoke system the company i work for has created.

I have been asked to make a few alterations to the file and am (
believe) a the last hurdle before i am finished. So please help if yo
can:

We want to open the Excel workbook i have created and pass additiona
parameters when opening the book

is there a way of doing somehting like the following:

open(C:\<file location\test.xls <parameter='test')

and then retrieve the parameter values (in this case test) within th
VBA code?


i really hop e that makes sense!

e

--
edfollet
-----------------------------------------------------------------------
edfollett's Profile: http://www.excelforum.com/member.php...fo&userid=3622
View this thread: http://www.excelforum.com/showthread.php?threadid=56016