VB.NET - VBA Code Drag and Drop!


With this tool you can pull VBA code by drag and drop from the application in an Office document, either into the document or into the VBA editor. The program is self-describing. The VBA code is read from text files, which are in a subfolder of the application. If a file with same name is found plus ending “.faq”, assistance can be spent over this file. Example: File is called "Sample.txt" - help file is called then "Sample.txt.faq". The text and help files are in subfolders like applications are called (e. g. Excel, Word…). If you maintain the structure, the program can be easily extended. In irregular distances I extend the program and add new codes in Excel. In the other Tabs there is only one example - now it is your turn. If you minimize the program, it is put down in the System tray and with one click again indicated. You must have installed the .NET Framework on the computer. The file at the end of the article is a MSI setupfile.



ExVBADragDropSetup.msi MSI Setup

Kommentare

  1. Hello Ralf...

    very nice Tool; I tested it and it works fine:-)

    One suggestion please: can you create separate english and german versions?
    I think, it's a lttle bit confusing when reading help texts in englich and german.

    Bye, Maninweb

    AntwortenLöschen
  2. Hi Maninweb, :-)

    that is a very good idea and on weekend I will compile two versions.

    Thanks for your suggestion.

    By, Ralf

    AntwortenLöschen
  3. do you have a vb.net to VBA converter ?

    AntwortenLöschen
  4. Not really. If you liked to program in .NET for Office, then look in Google for VSTO.

    AntwortenLöschen

Kommentar veröffentlichen

Beliebte Posts aus diesem Blog

Formeln - auch Array - per VBA eintragen...

Alle Dateien eines Ordners - Optional mit Unterordner

Excel -> Word in Textmarken (Bookmarks)...