วีดีโอ

Hello, I find your video interesting, I have a problem myself, maybe you can help me, I have to go through different ranges in which I want to vlookup every cell that refers to a player, I give an example of the code that I made in Vba, but it is so long that I can't show everything; (There are 18 players) Range("D2").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Player18,4,FALSE)" Range("D3").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Player17,4,FALSE)" Range("D4").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Player16,4,FALSE)" Range("D5").Select I have "D2:D10";"G";"K";'N";"R";"U";"R";"Y";"AB" Same letter but from 12:20; 22:30; 32:40; 42:50 you see it is quite complex, can you help? If if you need to know anything else please ask! Please give an example.

Great video!! It really helped me.

Great. Thanks so much!

Hi sir, I just saw your video. Will it be possible to download 3D models that are for sale on the website?

"show native" that box some t code is ok, some t code is not, i try to use a display voucher(FB03) then print to PDF(save PDF as file). I cant have that script. do you have any idea to handle this?

absolute legend, thank you <3

Excellent solution! I've been searching for this for a long time! New subscriber!

thank you bro <3

thank you so so so much

hello. If I were to detach a virtual hard disk that has my entire OS on it, would I still be able to utilize the OS? I'm not super tech-savvy, but I have an entire 4 TB hard-drive that I can't use because everything is downloading to the 50 GB virtual disk. It's gotten so bad that I can't even update Discord on launch. Any assistance would be greatly appreciated.

done ❤❤❤❤❤

Bluestacks app created this hard disk file and i can't delete bluestack folder because it has a registered Microsoft Virtual Disk in my System

Hey so i have a lot of pdf urls to download, probably like 1000. How can i download the bulk all at once? since do it manually would take ages. Also the i need to login (username & password) first so i can have access to the pdf urls, can u help?

allah razı olsun

thank you so much, this helped me a lot!

not working

Thank you!

You saved my A with the 'Full Path' not only the name or Destination Folder! it worked with full path including the file name

Looking for vba macros to get the details of meta data from universe in sap BO. (class, objects, columns and tables that are mapped.) Appreciate your help

A jeżeli mam w Excelu w tabeli wiele adresów e-mail, temat, treść maila i chciałbym jedynym przyciskiem wysłać do wybranego jednego adreata maila. Da się taki automat zrobić?

how to do in python , put on one video

I'd like to make contact with you if possible? I'm sitting with SAP T-code that I want to automate with VBA. The SAP transaction is time consuming and prone to human error when data is incorrectly captured. I would like to automate the process and learn the process, so that I can implement it on other T-codes as well.

THANK YOU!!!! I can't believe I worked so hard without knowing this.

i hope this works ! boxes are so annoying .. lol

Liked it a lot. I am also a VBA programmer and just started one channel teaching how to use openGL in Excel (Programando em Excel para todos)

Getting 614 error

Hi Tomasz, very helpful thank You so much. I got issue with API method URLDownloadToFile but with Your example I Won!

Great Video, I have a question. I am getting a Failed to open PDF Document when I try to open the file. Since it is appearing in my location I am assuming it downloaded okay. I am using MS ACCESS to do this which I don't think is a problem, and I didn't change the location, or do I have to use Excel for this to work?

Excellent video, I really appreciate it. Question, how can I download the file if I need to enter credentials Login Name and Password?

Can we use this in any other tool??vba scripting?

Amazing video. Thanks for it. I am facing an issue.. My script stops when there is popup message after saving. Can you please make a video. How to skip popoup message in sap and move ahead with next codes

thanksss

Hej Tomasz, mam arkusz w excelu ktory chcialabym automatycznie odswiezac bez manualnego pobierania listy z SAP czy jest to mozliwe?

What I forgot is that the number of rows being searched is 20.

Hello sir, maybe you can help me I made code in Vba but it is long now I would like to make it smaller and maybe "loop" and "for loop" can help with that. Here part of the code: Application.ScreenUpdating = False If Sheets("Menu").Range("E2") = 1 Then Sheets("toplay1").Select Range("A1").Select ActiveCell.Formula2R1C1 = _ "=FILTER('S1'!R[1]C[1]:R[20]C[1],'S1'!R[1]C[1]:R[20]C[1]<>" "")" Range("B1").Select ActiveCell.Formula2R1C1 = _ "=FILTER('S1'!R[1]C[5]:R[20]C[5],'S1'!R[1]C[5]:R[20]C[5]<>" "")" The Range continues until "J1" you also notice that at "c[ ] each time 4 are added, that is because the search area moves 4 columns each time, if you can help me with this I will be able to continue with the rest I think, can you help me PLEASE

Hi, I am trying to put my connection name in the script but it is showing error. Please help me with this. In the connection name I have to write the name or SID or the group/server

Genius!! thanks a lot!

Thank you so much, it is very helpful for me.But when I run the code to fetch data from SAP,I find a problem.If the table.RowCount>110,I can not get the values of the cells.It return empty.So I can not fetch all the data from SAP to Excel.I have try to serach the problem by Google,but I do not get useful infomation.Could you help me to resolve this problem.Thank you a lot.

Thanks for the video , URLDownloadToFile has worked well for years downloading .xlsm file to execute a task by a calling excel macro. Overnight Google Drive has put a warning page in the path , in regards to risk of this type of file, I contacted support and they say it can't be bypassed ):. Any ideas would be appreciated

very good job

I downloaded the urlmon lib from online, but how do I get the code to work?

Thanks, seems a clever workaround!

Simply awesome videos 👍. I often revisit these videos in order to do something else sometimes as the steps explained are divided in a very simple manner so that one can easily customize them.

Big thanks ❤

hi. how to access database through network and to other PC's? what is the connection string?

Very nice .. may i know your instagram page ?? For contact ?

Great video tutorials👏👏! Your tutorials have been incredibly helpful for me and have improved my productivity at work. Thank you for taking the time to share your knowledge. I wanted to ask if you know of any similar or equivalent scripting tools for the new version of SAP we will be using soon, SAP S/4 HANA. Your expertise and insights would be greatly appreciated. Thank you again for your amazing tutorials!

Thank you! Interesting and informative content. Question.. You did not include any clean-up in your demo.. closing of connection, destroying objects, etc. Do you not consider that necessary?

Hi, thank you for this video. I don't understand the working but the solution works and solves my issue

Can You reply a Code That can Retrieve Column Header from ADODB Recordset. This Code Works Perfectly. But, the Provider Name Change to 'MSOLEDBSQL'. ASSUME ME AS BEGINNER. THANK YOU FROM INDIA.