Set up this excel Macro
Budget $10-30 USD
- Freelancer
- Jobs
- Visual Basic
- 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
Awarded to:
10 freelancers are bidding on average $29 for this job
Hello Sir I am available right now please knock me I can do this absolutely as you want . Thanks Anowar
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
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
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
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.
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
Hahaha, your project could be the easiest ever. Happy to help with the above. Here for any question you might have.
✨✨✨⭐⭐⭐✨✨✨ 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
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