command line

  1. Foo_Man_Chu

    Persisting Command Line Arguments

    I'm opening a spreadsheet two different ways: first by clicking on the icon for the spreadsheet and second via the command line so I can use command line arguments. My problem is this: when i open it via the command line it works as expected. When I open it by clicking on the icon it opens as if...
  2. T

    Winzip using VBA - add file to zip subfolder

    Hi all This is really a DOS/Command Line/Shell question but it's being run out of VBA and I know this forum better than any other. I need to add a file to a zip file. I have working code that does this using SHELL() the below: "C:\Program Files\Winzip\winzip32" -min -a...
  3. N

    Running a command line through excel

    Hi Everyone, I am trying to run a command line through excel to transfer the file to another location. I am very new to excel and was wondering if anyone can help me with this? I already have a save function I am using so after the save is invoked I want to run the command like to transfer the...
  4. A

    How do I pass a parameter from the command line?

    Guys, How do I pass a parameter into Excel from the command line: Something like start excel test.xls(Workbook_Open(99)) or start excel test.xls(99) where 99 is the parameter which is passed to the open sub? Private Sub Workbook_Open(comm as String) MsgBox comm End Sub...
  5. C

    I can't Run My VBA with MSOffice 2010

    I installed Microsoft office 2010 and I cannot get my Excel VBA macro to run. Specifically the VBA is supposed to grab a Text file(Note Pad) and parse into columns in excel. Can someone help me? I have included part of the VBA code below. Today = Application.InputBox(Prompt:="Enter Dispatch...
  6. S

    Run macro against every file in a specific directory

    Let's say I create a macro to delete the first 15 columns of a workbook. Is it possible to run that macro against every .xls file in c:\commissions? Thanks!

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top