command line

Hi Guys. I have two XLSX files. All sheets from the Second file should be copied to the First file from the end. But everything should be done automatically via command line. How can I do that? Please, describe everything step by step, I am a very new in excel automation. I have found a code...

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...

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...

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...

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...

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...

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!