Hello Mustaqim, Thats strange, can you share the code you are working on? May be you skipped the line where *pdf_files* was defined? Error code means variable named *pdf_files* doesnt exist which is why it cannot recognise it.
Hello Loyd, Please try below answer from *THE ARIN KAMBLE* on this page, seems to be working, I have not tested it myself. learn.microsoft.com/en-us/answers/questions/1725182/how-can-i-export-data-on-excel-from-a-password-pro
Hello, if you have java installed already and still getting an error, then please try below steps, the java setup is bit tricky but hopefully a one time setup. from windows start option, search for *Environment Variables* and search for *Edit environment variables*, then follow below steps: **** Under the System Variables click Path and then press the Edit... instead of New. Then in the next screen (Edit environment variable for the Path variable) click New and add the address, e.g. C:\Program Files (x86)\Java\jre1.8.0_201\bin. Press OK and the Path variable will be appended/updated.**** Answer taken from below: stackoverflow.com/questions/54817211/java-command-is-not-found-from-this-python-process-please-ensure-java-is-inst Source code: codepad.site/edit/q9aig7rj
Good solution. If you want to remove just blank columns you could also transpose then just apply the Remove Rows>Remove Blank Rows which results in a cleaner formula. I do like the flexibility of your solution though to remove columns with only 1 entry.
I get a Runtime 429 error on the line with Set OutApp = CreateObject("Outlook.Application") and can not seem to trouble shoot the issue. I have tried early binding and resetting the .DLLs. Any suggestions?
Hello Angel, Please try out below. To use early binding, you first need to set a reference to the Outlook object library, Microsoft Outlook xx.x Object Library (xx.x is version number and depends on outlook you have) Below code lines will need to be changed. Dim olApp as Outlook.Application Set olApp = New Outlook.Application answer taken from: stackoverflow.com/questions/60266233/i-am-getting-a-run-time-error-429-trying-to-get-excel-macro-to-send-a-email Please try it out and let me know.
After playing around with it, if you demote the columns (select the Use Headers as First Row option), then do everything in the video, and then promote the columns (Use First Row as Headers) you'll keep your headers!
Hi, Ye. I try to do make it work like that but no luck. I think it’s much convenience if we can reply directly to that to do list instead of searching it in the inbox to reply.
Hey Ananda, Thats a very clever way to fix dates, not many people know it. However, multiplying by 1 can only fix dates which are already in correct format as per US dates mm/dd/yyyy and are recognised at text instead of dates. In such situations where you have dd/mm/yyyy, multiplying by 1 doesnt fix it. Check out this youtube short for another quick way to fix such dates. ru-vid.com9T7d_AEGpvg?feature=share
Hello, per google, please try below: go to File --> Options --> Add-Ins --> Manage Excel Add-ins --> Go, and then check the Analysis ToolPak box and click OK
Glad it was helpful! I have another VBA video where you can open multiple PDF files in one click, it can also work on visible/filtered rows only, make sure to check it out. Thank you. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-V33cB3HfgZ8.html
Hello, please access the excel file using below link: docs.google.com/spreadsheets/d/1e0u6WVSPxBNJTFr1bckRMbJw2zdI9Qou/edit?usp=sharing&ouid=110820750791230145171&rtpof=true&sd=true Also adding link to the code: codefile.io/f/rMHi4ctl6X
Hi, I am having a crazy task that might be impossible to execute. I already processed the table using PQ, so my table is dynamic and information may in and out depending on my Status. When project is "Done" it's removed from the final table, when project has an "In Progress" status it gets into the final table for my analysis where I have some manual formulas (that is no embeded in PQ) and Text. Hope this step is clear for now! And the most funny issue is that in this final table (excel table that is refreshed) I am adding a column, when I enter a formula there is no issue, because this formula applies to all active cells in the table right? But when I add some "text" - it does not work like a formula and "text" remain in the same cells in spite of my projects may in and out, and "text" does not match the project anymore, does excel have a solution here? Where I would like that my "Text" will be dynamically moved up and down or removed if project goes out from the table :) I can not find the answer unfortunately
Hey, that is an interesting issue. From what I understood, the text corresponds to the project, and I am assuming each project has some unique identifier. One suggested way would be to create a helper table with Project ID and notes, and then merge this table with your final table using Project ID. Let me know if that solution works out for you. Cheers!
true, but DAX means learning a new skill, which can only be used inside of Microsoft Excel or PowerBI. Why not learn an open source tool which offers much more flexibility and can be used together with other tools/libraries.
Thank you Govind. Its not necessary to shift to one technology or other, both can work pretty well in tandem. Python is supposed to supercharge your existing skills.
Thank you and thats great to hear. I work in an accounts department and have streamlined and automated a lot of things over the time using python. Looking forward to share the knowledge with the world.
thats true, but I believe due to high learning curve of DAX, it makes more sense to learn it if you want to use Power Pivot and ultimately PowerBI dashboards/reports. While Python is a general purpose language and not too difficult to learn even with non coding background. It is open source and there are ton of libraries available with thorough documentation/walkthroughs.
Great solution! Just wondering, what would you recommend if my dataset exceeds the column limit? Asking because I'm working with a dataset with +80k records and need ideas. Thanks!
Hello Ivan, Thank you for the positive feedback, it means a lot. For dataset with 80k+ rows, I would recommend using either R or python. R I have observed to be significantly faster in loading data compared with python pandas, you can try out both if you need more help, leave a comment.
Hello, thank you for watching the video. You can access the code at below link, make sure to install relevant libraries. If you are still having issues understanding the code, let me know and I will be happy to explain. codepad.site/edit/q9aig7rj
Hello. these are Jupyter code cells inside of VS Code using interactive window. These are really helpful when I need to run a code block one by one, instead of running everything altogether. You can read more on it on below link: code.visualstudio.com/docs/python/jupyter-support-py
@@laalbujhakkar Hello, other than bunch of themes, I have DataWrangler - very helpful for data analysis folks. IntelliCode - Dont use it much Jupyter Jupyter Cell tags R - Dont use much of R Script Codiumate - Have use a bit but it was causing a lot of memory usage. I jumped from pycharm to vscode due to speed, so dont want to slow it down.
@@sainitij1254 I have checked and the video uses *Post an article* You can see at 0:12 second mark, it says post as article. Please follow along the video and let me know if it gets your problem resolved. Thank you.
I am glad it helped. I actually made the full video using Power Automate and Microsoft Scripts but later realized that Power automate right now only supports refresh queries that are connected to Power BI, no other refreshes are supported. Lets hope Microsoft fixes it soon!
Thank you, I appreciate it. If you find extracting data from PDF to excel interesting, do check out my latest video where I extract PDF data using R script, Python libraries and Microsoft Power Query.
Thank you Atef, I appreciate it. Please use below code and let me know if it works for your task, it will save and close all open excel files. If you want me to make a small video explaining the code, let me know as well. Sub SaveAndCloseWorkbooks() Dim wb As Workbook ' Disable display alerts to suppress warnings Application.DisplayAlerts = False ' Loop through all open workbooks For Each wb In Workbooks ' Save changes if the workbook has been modified If wb.Saved = False Then wb.Save End If Next wb ' Close all open workbooks without warnings Workbooks.Close ' Enable display alerts again Application.DisplayAlerts = True End Sub
LoLz... Now we just need to replace the PC with a microcontroller to run the python to simulate a USB mouse. We also need targeted clicks and simulated workloads, like typing meeting notes based on zoom meeting audio 😁
Lol, with the speed AI and tech is progressing, it's not too far. Interesting, I know few organisations who track employees on whether their computer mouse is active or not, and then asks for an explanation for being away from the desk.
Thank you so much for the kind words! I'm thrilled that you found the video helpful and that you're inspired to give it a try. I appreciate your support!
Hello, This uses some libraries of python as well, including the numpy library. Can you screenshot the error and link it here? I am using it on regular basis and it works fine. I am currently running python 3.9.0, numpy version is 1.26.2
@@theDataCorner I figured it out! Have to use Power-shell or Windows Terminal for power-shell to get Auto-Editor to work with newest versions of Python and Pip
Hello Ahmed, thank you for watching the video. and yes, please share your excel file along with requirements/issue at thedatacorner5@outlook.com and we will see what we can do.
