How To Automate Your VBA Coding & 10x Your Development In Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ส.ค. 2024

ความคิดเห็น • 50

  • @ExcelForFreelancers
    @ExcelForFreelancers  2 หลายเดือนก่อน

    🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom

  • @ExcelPracticalSolutions
    @ExcelPracticalSolutions 3 หลายเดือนก่อน +2

    This VBA Code Automator is a game-changer! Automating the code entry with AutoHotkey integration seems incredibly efficient. I appreciate how detailed the explanation is, especially the part about customizing shortcuts to insert specific code blocks. This tool will definitely save a lot of time for anyone working with extensive VBA projects. Thanks for sharing such a valuable resource!

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 หลายเดือนก่อน

      Thank you for your kind words, I'm thrilled that you found the tool valuable!

  • @abdullahsafi9430
    @abdullahsafi9430 3 หลายเดือนก่อน +8

    He's automating the automation!

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน +2

      Yes for sure you will be able to code faster than me when you learn this method and download my template. Thank you for your Likes, Shares & Comments. It really helps.

    • @DataAnalyticsPro21
      @DataAnalyticsPro21 3 หลายเดือนก่อน +1

      7.30 PM of which time zone sir?

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      Hi and thanks this will be live at 9:00 PM GMT + 7 However your TH-cam should show your time zone. I hope this helps and thanks so much.

  • @stigcorneer8306
    @stigcorneer8306 3 หลายเดือนก่อน +2

    Fascinating idea.
    What I would have liked in the video itself is to start with a shorter feature review. Then, as a viewer, I don't have to sit and wonder about what it will actually be and have an easier time understanding from the start what the various components will be for.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      HI and thanks very much for the feedback. I will remember to do this in future videos. I do appreciate that and thanks so much

  • @Mosha-Aldisri
    @Mosha-Aldisri 3 หลายเดือนก่อน +2

    Fantastic effort sir
    Can you teach us a lesson about the Google Sheet API and integrating it with Excel by creating a new library for us to work with its components, taking into account the Arabic language?
    It is a simple intervention, please pay attention to it

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน +1

      Hi and thanks so much for your comment. I try to stay focused on Excel. Thank you for your Likes, Shares & Comments. It really helps.

  • @user-bj7ul7qs8y
    @user-bj7ul7qs8y 3 หลายเดือนก่อน +2

    very good
    Thank you for everything you provide
    I have sent you the excel file for the installment program

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      Hi and thanks very much. I have seen the email however I am unable to provide any one on one help since I get hundreds of emails a day. If you need help with this please post a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
      We have 60,000 Members who would love to help you with this. Thanks so much.

  • @JOSELUISTORREZRIOS
    @JOSELUISTORREZRIOS 3 หลายเดือนก่อน +1

    Thank you very much for the tutorial explained step by step, excellent contribution, blessings.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      For sure, you are very welcome and I am happy to help and share. Much appreciated.

  • @JanBolhuis
    @JanBolhuis 3 หลายเดือนก่อน +1

    Well, what can I say...., I'm using almost the same comment for every video and application you teach us.... And again another great video!! Thank you so much!!

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      Thank you so very much, I really appreciate that Jan. Thank you for your Likes, Shares & Comments. It really helps.

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 3 หลายเดือนก่อน +1

    This is so awesome. Thank you so much Randy for this amazing video.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      For sure, you are very welcome Syed and I am very happy to help and share

  • @wimschiphorst8541
    @wimschiphorst8541 3 หลายเดือนก่อน +1

    Interesting video. I don't do much with VBA for Excel, but I do a lot with Access VBA. I will try to see if this method can also be applied there.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      HI and thanks so much. Yes this will work in any VBA, or any application for that matter. I hope this helps and thanks so much.

  • @muhammadkausar2842
    @muhammadkausar2842 3 หลายเดือนก่อน +3

    Amazing sir 👍
    Will u give us the download for this masterpiece ?
    Without purchase

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน +1

      Hi, you can download this file for free using the links in the description under the word DOWNLOAD as soon as the video launches next Tuesday. I hope this helps and thanks.

  • @muhammadkausar2842
    @muhammadkausar2842 3 หลายเดือนก่อน +1

    I salute your efforts
    You deserve 10M+ subs
    Really impressed and i really appreciate your work
    Thank u very much
    Can i download it

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน +1

      Thank you so very much, I really appreciate that. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

  • @sohealsingh
    @sohealsingh 3 หลายเดือนก่อน +1

    Hello Randy
    Excellent, very useful

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      Great, thanks so much Soheal. I really appreciate it

  • @marcosmelendez09
    @marcosmelendez09 3 หลายเดือนก่อน +1

    This is awesome! I want to learn vba so badly

    • @7Denial7
      @7Denial7 3 หลายเดือนก่อน +1

      Why dont you wanna learn some other languages, like c# or javascript?

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      HI and thanks so much. I have a beginners series on TH-cam here th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
      You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourseRandyShared

  • @mrblom988
    @mrblom988 3 หลายเดือนก่อน +1

    Hi, I hope you answer this, I been following your videos and they are amazing, learnt a lot, I've created Asset Register using VBA, but it takes a long time to open, and the file size is 1 GB , how can I reduce the size and improve the opening time.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      Hi and thanks for your comment and following. To reduce the file size its best to make sure to separate your front end (user interface) and back end (database). Then make sure to remove any formats or conditional formatting from your database as these can add to the file size considerably. You may also want to consider archiving some of your data into another workbook if possible. I hope this helps and thanks so much.

  • @tungsonnguyen7988
    @tungsonnguyen7988 3 หลายเดือนก่อน +1

    Thank you so much.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      For sure, you are very welcome and I am happy to help and share

  • @tungsonnguyen7988
    @tungsonnguyen7988 3 หลายเดือนก่อน +1

    Hi Randy,
    I like your clip so much!
    But it is not easy for us (english is not our native language) to catch up all the informations there.
    For example, at 23:26 you say about the auto hot key software. There are so many infos there to make it run at the first time.
    Could you please make a summary in writting at the end of each clip? It will help us a lot in understanding your ideas more clearly.
    Thank you very very much.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      HI and thanks, yes for sure I can do that, and also in the beginning as well. Thanks again for your valuable feedback. I appreciate that.

  • @brenthalbach3645
    @brenthalbach3645 3 หลายเดือนก่อน +1

    I purchase you Lifetime VBA Code Library. I suspect just adding the AHK specific macros & a few changes and this will work in that workbook?

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      Thanks very much for your support Brent. Yes for sure, the workbooks are a bit similar, however the VBA Code Library has Categories and Types, a search feature and 500+ Macros inside.

  • @AraRoodbuik
    @AraRoodbuik 3 หลายเดือนก่อน +1

    The download link in my email for downloading this workbook is broken. Page not found is what I constantly get.

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 หลายเดือนก่อน +1

      Hi and thanks for your email. The download link has been updated to a zip file which includes both the file and the ahk script here
      freeworkbookdownloads.s3.us-east-2.amazonaws.com/VBA_Code_Automator.zip
      I hope this helps and thanks so much.

  • @danp6101
    @danp6101 3 หลายเดือนก่อน +1

    Hi Randy. I installed Version 2 and it says #IfWinActive ahk_class wndclass_desked_qsk ;ensures following scripts
    run in VBA Editor++
    This line does not contain a recognized action.
    Nor did it recognize #NoEnv.
    is there a way to correct this.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      HI and thanks very much. Can you try this with Version 1 and see if it works?
      Thanks very much.

  • @MrGoudfay
    @MrGoudfay 3 หลายเดือนก่อน +1

    it's not working ! u didn't share the Autohotkey script ! written script like in video not working !

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      HI and thanks, and I am sorry about the missing file. If you try downloading again, I have now updated the download to be a zip file which includes both the application and ahk script.

  • @sat1460
    @sat1460 3 หลายเดือนก่อน +1

    Is it free application sir?

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน +1

      Yes it is for sure. As soon as the video goes live, the link will be available under the word DOWNLOAD. Please make sure to watch the full video when it goes live.
      I hope this helps and thanks so much.

  • @MJLCabral
    @MJLCabral 3 หลายเดือนก่อน +1

    You used to make reference to Steve Rynearson's AutoMacro Code Generator, what happened to you no longer making that reference?

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน +1

      Steve has a great product and I love automacro. I am actually waiting for Steve to give me a new link to his product, as there were some changes, so I hope to hear from him soon on that.
      Thank you for your Likes, Shares & Comments. It really helps.

    • @MJLCabral
      @MJLCabral 3 หลายเดือนก่อน +1

      @@ExcelForFreelancers I also had some problems contacting him, finally today I had the links to the new version!

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 หลายเดือนก่อน

      Oh ok very good. Yes I am sure when i get the updated links as well I will continue to promote his products since I also really like them as well.