3 Excel VBA Training Questions YouTube

Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
For details you can visit our website:
http://www.familycomputerclub.com

Here are 3 Excel VBA training questions from my YouTube viewers:
Question No. 1
Comment on your video: Copy Data from one Workbook to Another in Specific Worksheet
yet again an amazing video tutorial - question for you sir, can you show us a short video - when "transfer data" button is clicked, it should prompt a warning "Are you sure you want to transfer data?" (or something) because most of the time, I click button by accident and then I have to trace back and delete from workbooks - Thanks
We create a Message Box with the option VBOK or VBCancel so that the user can decide whether he wishes to copy the data or not.
Question 2:
How to Login into Website Automatically Using VBA
Hi,
I followed the tutorial but when I run my code I get this error message: Compile Error: User- defined type not defined.
I am missing something. I attached my file if needed. Any help would be greatly appreciated.
Respectfully,
Mike

Mike wishes to login automatically into a website using username and password but he wants to use Google Chrome as his browser. We use the Shell command to access the path to the chrome.exe file and then define the URL using specific sysntax in Excel VBA to solve the problem.
Question 3:

I have watched your tutorial "Transfer Data from Multiple Workbooks into Master Workbook Automatically" on YouTube with great interest. This is something that I would like to implement.

I have retyped your code exactly changing the path and folder names to match my system and I am getting the following error. Please see attached image.
I believe the file path is correct, I have attached an image of this as well.

I am using windows 7 with a version of excel 2010.

I would appreciate any help or advice you may be able to provide.

Yours Sincerely,

Darren Elliott

This is perhaps the best question and Darren provides an elegant solution too.
Thank you Darren!
For complete VBA code: http://www.familycomputerclub.com/3-excel-vba-training-questions-youtube.html

Видео 3 Excel VBA Training Questions YouTube канала Dinesh Kumar Takyar