View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
arno arno is offline
external usenet poster
 
Posts: 184
Default passing parameters from command line

Hi Albrecht,

Still: When I use Auto_Open, how do I get the parameter (e.g. the

filename,
that changes every day)?


That's a different story. There _must_ be a rule to find out the filename.
If you create the filename, then I would use the same name every day. If
this is not possible the you have to know what the name is, eg. it has
always todays date. Then you can have a macro like this:

myFile = "testFile"
myExtension = ".txt"
myDate = format(today(), "DDMMYYYY")

myFiletoOpen = myFile & myDate & myExtension

then you can do with myFiletoOpen whatever you like (it will be
"testFile11022004.txt" for today).

regards

arno