Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Shell Program for Excel

chrish008chrish008 Member Posts: 17
I am new to VB and VBA and am wondering where exactly is the dividing line between the language and the apps in both cases.

I wish to create a shell program to operate upon spreadsheet data in Excel. Is it possible to create a standalone executable program (which opens Excel) to do this or must all VB code be executed from within Excel to work on Excel data?

If the former case is correct, what are the basic commands for:

a) Executing Excel
b) Loading an Excel spreadsheet *.xcs

Any comments would be most appreciated.

chris.



Comments

  • ZantosZantos Member Posts: 139
    I can help with the first part, but not the second:

    Shell("C:Program FilesExcelExcel.exe")

    Nothing to it - ..:: Zantos ::..
  • Chris BrownChris Brown USAMember Posts: 4,624 ✭✭

    _________ // http://forcoder.org // free video tutorials and ebooks about // Java, Ruby, C, Visual Basic .NET, Delphi, Objective-C, JavaScript, Perl, Assembly, Swift, C#, R, MATLAB, PHP, C++, Go, Python, PL/SQL, Scratch, Visual Basic Bash, Lua, LabVIEW, Awk, Transact-SQL, Alice, Apex, Fortran, Logo, Hack, D, Dart, Julia, VBScript, Prolog, Rust, Erlang, Scheme, Scala, Kotlin, Crystal, SAS, F#, ABAP, Clojure, COBOL, FoxPro, ML, Ada, Lisp // ___________

Sign In or Register to comment.