Видео

Glad to hear it helps you save time! Similar result can be achieved through python pandas, especially if the dataset is big, which power query is slow to handle.

Thank you. Do check out other videos as well.

Hello. I don't think such a thing is possible with VBA. What exact page you need to open?

You're welcome

Glad you enjoyed

Hello, I am using VS Code and within VS Code, make sure you have extensions by name of *Jupyter* and by Name *Jupyter Cell Tags* installed, read more on link below, they are basically jupyter code cells. code.visualstudio.com/docs/python/jupyter-support-py Hope it helps.

Hello, Sorry I missed your comment. I will research and let you know what I find. thanks.

Welcome! Do you check out other videos as well!

Hello. Do you have prior experience with python? If not, I can recommend some beginner lecture videos, as these videos are project based and intermediate level skill is needed to go along.

@@theDataCornerokay and which extension do you installed in vs code to look like this browser view VS code.

hello, that is ipynb support in vs code. Please read below for more information on jupyter notebook. code.visualstudio.com/docs/datascience/jupyter-notebooks

Hello Winner. I would suggest to use Vs code, as a lot of people use it and it has good function overall. If you want something very simple for basic editing then use sublime editor or even IDLE that comes with python installation. Cheers!

Hello. Do you have python programming language properly installed? and auto-editor library installed as well? Open command prompt and type python, press enter. Does it give you the version of python installed?

@@theDataCorner Yes both are installed and I have worked on different other projects as well with python using vs code editor

Hello. Try below. 1- go to the folder the video is in, in windows explorer page where there is usually address like C:\Web.. type CMD and press enter. Paste below in CMD, change information as needed. auto-editor fileName.mp4 --margin 0.2sec --export resolve 2- If above doesnt work, try below in same command CMD window opened above: python -m auto-editor fileName.mp4 --margin 0.2sec --export resolve Let me know if any of above works.

@@theDataCorner Hey, I tried the last command but its hows no module name auto-editor :(

Hello, Please check answer at the end of page from below link, let me know if it solves your issue. community.plumsail.com/t/power-automate-not-saving-file-extension/13684/3

Thank you, do check out other videos as well.

Thanks. I am glad it helped. Check out other videos as well, they could be helpful as well.

Are you able to send me a similar sample PDF file? so I can test it and let you know. Email it here: TheDataCorner5@outlook.com

Hello. Within VS Code, make sure you have extensions by name of *Jupyter* and *Name: Jupyter Cell Tags* installed, read more on link below, they are basically jupyter code cells. code.visualstudio.com/docs/python/jupyter-support-py

All the best

@@shoppersdream thank you and check out other videos as well.

Hey bro, Code can be accessed from below link, let me know if you have any other questions. codepad.app/edit/yz3801h0

You are welcome! Glad it was helpful.

Hello Smith, Is your PDF scanned or computer generated? The error seems to be related to some font, I have not seen that error before. You can try using camelot, which works in similar way to tabula library, if that doesnt work, you can try using microsoft power query to do same task. ruclips.net/video/b8VTa3gYOBo/видео.html Camelot Code: import camelot import os import pandas as pd # List all PDF files in the current directory pdf_files = [x for x in os.listdir('.') if x.endswith('.pdf')] print(pdf_files) # Initialize an empty DataFrame to store the combined tables combined_df = pd.DataFrame() # Loop through each PDF file for pdf_file in pdf_files: # Extract tables from the PDF tables = camelot.read_pdf(pdf_file, pages='all') print(f"This pdf has {len(ttables)} pages") # Check the number of tables and select the required ones if len(tables) > 4: required_table = pd.concat([tables[2].df, tables[6].df], ignore_index=True, sort=False) else: required_table = tables[2].df # Add the PDF source column required_table['pdf_source'] = pdf_file # Append the required table to the combined DataFrame combined_df = pd.concat([combined_df, required_table], ignore_index=True, sort=False) # Create a copy of the combined DataFrame df_new = combined_df.copy()

Hello Albert, Glad to hear that! make sure to check out other videos on the channel as well.

Thank you, I'm glad you found it helpful. Make sure to check out other videos and leave feedback.

Thank you, Azeem, for long time fan of this channel!

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

@@theDataCorner send the print command on that pdf and save it as a pdf again

@@MrSiaa I havent tested it, but it might work.

Hello This seems to be a typo in description, its actually Screenshot to Text (OCR). Thank you.

Thank you, Ahmed, Below is the link for the source code. Make sure to check other videos as well. codepad.site/edit/8r4ld901

@@theDataCorner thank you. are you on linkedIn?

Hello Ahmed, sure. Code is below, I will add in video description as well. codepad.site/edit/3w48mae6

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

@@theDataCorner thanks for your time bro , keep it up .

Happy to help!

Hello, I will check and advise.

Great idea, Tim, Thank you. And make sure to check out my other videos on the channel as well.

Can you give me an exact time in the video where it says that? And i will look into it for you.

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.

Thanks Evan, let me look into it and get back to you.

Hi, this is also what I am curious about? Everything else works fantastically, but I do need to keep my headers.

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!

Thank you Ramisa, thats a great solution. I found a workaround but your solution seems much better and elegant, appreciated!

@@theDataCorner Happy it worked out :)

Hey, John. Do you want to reply to the same/original email? its an interesting question, let me research a bit and get back to you.

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.

Hello, i was able to find a way to do this, i will make a small video on it and share link here.

Thanks man!! You’re the best!

@@jayenriquez4550 Thanks. Check out below video, let me know if this is what you are looking for. ruclips.net/video/WTlAaezmlus/видео.html

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. ruclips.net/user/shorts9T7d_AEGpvg?feature=share

Thank you 🙌

Hello I will create a small youtube video explaining how to do this, I will add a link here once I am done, should be soon.

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. ruclips.net/video/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

Thank you for watching. I hope you learnt something new.

Thank you Azeem, hope you enjoyed the content!

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!

Thank you Azeem, appreciate it.

Thank you, Azeem.