Completed

Set up this excel Macro

I have no idea how to set up this macro and get it to work

Note: The windows computer I have is netbook and it is not powerful or fast.

I want an excel file with the macro set up like in this youtube video (its 2 minutes long)

This is exactly what I need it to do

[login to view URL]

The program is in the same file location as the code below:

C:\Program Files\Native Instruments\FM8\[login to view URL]

These are some sample data points for the excel file

"F:\Cartridges\- Jack Deckard\[login to view URL]"

"F:\Cartridges\- Jack Deckard\[login to view URL]"

"F:\Cartridges\- Jack Deckard\[login to view URL]"

"F:\Cartridges\- Jack Deckard\[login to view URL]"

"F:\Cartridges\- Jack Deckard\[login to view URL]"

"F:\Cartridges\- Jack Deckard\[login to view URL]"

"F:\Cartridges\- Jack Deckard\[login to view URL]"

"F:\Cartridges\- Jack Deckard\[login to view URL]"

"F:\Cartridges\- Jack Deckard\[login to view URL]"

"F:\Cartridges\- Jack Deckard\[login to view URL]"

"F:\Cartridges\- Jack Deckard\[login to view URL]"

"F:\Cartridges\- Jack Deckard\[login to view URL]"

"F:\Cartridges\- Jack Deckard\[login to view URL]"

"F:\Cartridges\- Jack Deckard\[login to view URL]"

This is the code used in the video

Sub control_fm()

Dim Appis As Integer

Dim i As Integer

    

'AltKey = "%"

    'CtrlKey = "^"

    'ShiftKey = "+"

    'TabKey = "{TAB}"

    'EnterKey = "~"

i = 1

Appis = Shell("C:\Program Files\Native Instruments\FM8\[login to view URL]", vbNormalFocus)

    [login to view URL] Now + TimeValue("00:00:05")

Do

    AppActivate ("Microsoft Excel")

        [login to view URL](1, 2).Value = i

        [login to view URL](i, 1).Copy

    

    AppActivate ("FM8")

        [login to view URL] ("%f")

         [login to view URL] Now + TimeValue("00:00:01")

        [login to view URL] ("{DOWN}")

       

        [login to view URL] ("{DOWN}")

     

        [login to view URL] ("{DOWN}")

     

        [login to view URL] ("{DOWN}")

      

        [login to view URL] ("{DOWN}")

        [login to view URL] Now + TimeValue("00:00:01")

        [login to view URL] ("~")

        [login to view URL] Now + TimeValue("00:00:01")

        [login to view URL] ("^v")

        [login to view URL] Now + TimeValue("00:00:01")

        [login to view URL] ("~")

        [login to view URL] Now + TimeValue("00:00:01")

        [login to view URL] ("~")

        

    [login to view URL] Now + TimeValue("00:00:10")

i = i + 1

AppActivate ("Microsoft Excel")

Loop Until [login to view URL](i, 1).Value = ""

End Sub

Skills: Visual Basic, .NET, Excel, Excel Macros, Excel VBA

See more: excel macro fill empty cells, excel macro data cell, excel macro export xml, data net web application excel macro, excel macro expert india, excel macro load web site, install analysis toolpak automatically excel macro, excel macro convert weight, excel macro format phone numbers, excel macro copying cell content, compare tables using excel macro, excel macro open files, excel macro move data existing cell, excel macro front end creation

About the Employer:
( 1 review ) Ogden, United States

Project ID: #28019569

Awarded to:

(5 Reviews)
3.2

10 freelancers are bidding on average $29 for this job

AnowarRatul

Hello Sir I am available right now please knock me I can do this absolutely as you want . Thanks Anowar

$25 USD in 1 day
(199 Reviews)
6.1
royalcalif

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfille More

$30 USD in 1 day
(86 Reviews)
5.8
akritisood94

Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project More

$40 USD in 1 day
(71 Reviews)
5.7
kingqueen369

Hi, Greetings! ✅checked your project details Set up this excel Macro ✅Completed Time : 24 hours(independent and fast workers only) or your requirement deadline . I would like to work on your project and want to be dis More

$20 USD in 1 day
(13 Reviews)
3.6
naseefo

I have expertise in using VBA in MS Excel. I can solve this issue for you within a day. Please kindly get in touch so that we can discuss further.

$25 USD in 1 day
(7 Reviews)
3.5
yadavexpert53

Hi, I can assist you in the best way & according to project requirement. I am an expert and professional in MS Excel & VBA. It includes extracting information from text files, websites, transferring info in to excel, U More

$15 USD in 1 day
(21 Reviews)
3.7
daninec96

Hahaha, your project could be the easiest ever. Happy to help with the above. Here for any question you might have.

$30 USD in 1 day
(4 Reviews)
3.1
TatyanaVictory

✨✨✨⭐⭐⭐✨✨✨ I have a special skills in Excel Macro fields so that I can finish your project perfectly. I think we can discuss more detial via chat. I gurantee a excellent result with my last 7 years Macro experiences. w More

$20 USD in 1 day
(0 Reviews)
0.0
prasannauralsk

Hi, I have already completed the task at hand. You can download the same from my google drive. Just visit this link [login to view URL] You can download t More

$20 USD in 1 day
(0 Reviews)
0.0