Excel Support

%3CLINGO-SUB%20id%3D%22lingo-sub-1860641%22%20slang%3D%22en-US%22%3EExcel%20Support%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1860641%22%20slang%3D%22en-US%22%3E%3CP%3EHi-%20I%20have%20created%20a%20calculator%20in%20excel%20using%20Visual%20Basics%20and%20the%20calculator%20works!%20But%20now%20I%20want%20to%20add%20a%20button%20to%20the%20spreadsheet%20and%20link%20this%20to%20the%20calculator%20so%20that%20when%20the%20button%20is%20pressed%20the%20calculator%20will%20open%20and%20allows%20the%20user%20to%20use%20it!%20How%20do%20I%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1860641%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1862102%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20Support%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1862102%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F860046%22%20target%3D%22_blank%22%3E%40StevenTonkin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EMaybe%20that%20will%20help%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ECopy%20a%20.bat%20(batch)%20file%20created%20according%20to%20the%20following%20pattern%20into%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3Ethe%20%3CSPAN%20class%3D%22VIiyi%22%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Eautostart%20folder%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EC%3A%20%E2%80%A2%20User%20-%20Adninistrator%26gt%3B%20test.xlsx%20(The%20input%20of%20the%20file)%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EC%3A%20User%26gt%3B%20copy%20con%20teststarten.bat%20(Start%20Excel%20and%20open%20it)%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Etest.xlsx%20-%20Z%20(This%20works%20as%20a%20batch%20file%20-%20Z%20stands%20for%20Ctrl-z%20or%20F6%20key.)%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E1%20file%20(s)%20copy.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EC%3A%20User%26gt%3B%20start%20test%20start%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Ec%3A%20User%26gt%3B%20test.xlsx%20(again%20calls%20the%20file)%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EC%3A%20%5C%20User%26gt%3B%20(and%20opens%20Excel)%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20fact%20that%20Excel%20is%20opened%20twice%20with%20the%20file%20%22in%20between%22%20cannot%20be%20seen%20in%20the%20command%20line.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20first%20command%20is%20only%20for%20testing%2C%20and%20after%20'%20Z%20or%20F6%20you%20have%20to%20press%20Enter%20of%20course.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you.%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi- I have created a calculator in excel using Visual Basics and the calculator works! But now I want to add a button to the spreadsheet and link this to the calculator so that when the button is pressed the calculator will open and allows the user to use it! How do I do this?

1 Reply
Highlighted

@StevenTonkin 

Maybe that will help

Copy a .bat (batch) file created according to the following pattern into the autostart folder:

C: \ User \ Adninistrator> test.xlsx (The input of the file)

C: \ User> copy con teststarten.bat (Start Excel and open it)

test.xlsx ^ Z (This also works as a batch file ^ Z stands for Ctrl-z or F6 key.)

1 file (s) copied.

C: \ User> teststarten (start test start)

c: \ User> test.xlsx (again calls the file)

C: \ User> (and opens Excel)

The fact that Excel is opened twice with the file "in between" cannot of course be seen in the command line.

The first command is only for testing, and after ^ Z or F6 you have to press Enter of course.

 

Hope I was able to help you.

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)