Passing a value from command line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to pass a value into an excel workbook to populate a cell within
a worksheet. The value is dynamic and will create a worksheet by inserting
the value passed to a data query.
 
M,
AFAIK you cannot read Excel's command line arguments.
That leaves you 3 options:
1. Use automation, open workbook, straight forward process
2. Use ADO, no need to open, but could be tricky depending on your layout
3. Use the older Macro format. Never used it.

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass parameters to Workbook from hyperlink 2
Passing data to an event handler 3
Varioable in SQL statement 4
Needed Macro and Function Help 4
How to open a specific worksheet via code from workbook_open 5
Iterating through a ComboBox's values 6
Pass variables to Worksheet_SelectionChange 3
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0

Back
Top