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!

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top