LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
dq dq is offline
external usenet poster
 
Posts: 46
Default Reading command line parameters in a VBA program

Hallo everybody,

I have an Excel VBA macro that I run several times per day to generate
certain reports. To have this done fully automatic I need to be able
to launch the program with a commandline that looks like
....\ReportGenerator.xls /List=1000 /Date=Today
How can I read the parameter(s) '/List=1000 /Date=Today' in my
program. I find no property that returns this string.

Thanks to anybody who can help me because I've been looking for a
solution for quite some time now.

DQ

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Are there command line parameters for Excel? Michael Excel Discussion (Misc queries) 9 August 5th 07 06:29 PM
Complete list of Excel Command line switches/parameters NHRunner[_2_] Excel Programming 1 July 11th 06 05:22 AM
Command line parameters to Excel Tom Walker Excel Programming 3 May 23rd 04 06:08 AM
passing parameters from command line Albrecht Hesmert Excel Programming 5 February 11th 04 03:20 PM
Command line parameters into a macro Donemowe Excel Programming 3 August 6th 03 09:12 AM


All times are GMT +1. The time now is 05:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"