Thank you! Finally, a video that gives the answer I was looking for, short and sweet. KZbin, please gives this video more attention. Subscribed and liked.

Thank you!

Thank you❤

Thank you, you solved my problem 🎉

Thank You for this Tutorial. However, I do have few .txt files that have leading zero's in one of the cell. Those are getting trimmed in excel. So in the VB script is there any code we can add so that when macro imports the data from .txt to excel in text format (rather than general) so that leading zero's are preserved?

This was a wonderful video. I learned how to do it by watching it twice and I’ve been trying for hours to figure out how to do it.

Great

thank u so much, so easy and straight to the point

I have been watching some of your videos, and have learned quite a bit, wondering if you can tell me how to make a UI based excel sheet for certain types of forms. would like to collaborate with you on this task, so that i may explain my situation. I have seen this done before but individual refused to show me how this is done. This idea is intended for my business.

Melissa, Thanks. This was very helpful.

For anyone who needs to import CSV files with a delimiter other than comma, you need to do 2 things: 1) Make sure your file extensions are .txt rather than .csv (this is because of an odd behavior of the VBA function used to open files, see the answer to StackOverflow question 39890471) 2) In the macro code, replace the 2 lines "Set xTempWb = Workbooks.Open(xFilesToOpen(I))" with: Set xTempWb = Workbooks.Open(Filename:=xFilesToOpen(I), Format:=6, Delimiter:=";") This is for semi-colon delimited files, change the Delimiter parameter to your actual delimiter.

Thanks very much!

Great, very helpful

Excellent. Thanks

Thank you ❤ ur amazing. Hi from Egypt.

Hi, Melissa: Thanks for the video. It really helped. But after I followed the instructions, I ended with an error message when I hit the "Submit" button. Instead of seeing the e-mail, I got this error message: ActiveX component can't create object. Where did I do wrong? Please advise.

YOU'RE A LIFE SAVER! THANK YOU!!

This was incredible, and so easy to follow along with! Thank you for this!

♥️♥️

Outstanding, really made me re-think how to get information from participants in a trial.

Verr interesting. Mucho Danke.

A calm, cool and fully prepared trainer with curated content. :)

The only issue I'm having is this completely disabled RGB in my case..

I know you might not see this but I was wondering if there was a way where, when I click the submit button, the form could take the entries and populate a running list on another sheet within the document?

Thank you so much for your help but now how do I sort the data?

Generally when all data is in one file the file becomes heavy. does the combine file also get heavy once data is imported?

Excel version please

mam not showing after export send mail for selection....pls help

Thank you

Hi Melissa thank you so much for this tutorial, you are so easy to understand. John from Australia.

thank you it's really helpful

Great. What are the other options as a result of submit button rather than mail. Is there any option to upload the file to Omedrive..?

Thanks for this, how do I achieve same result in Google Sheets?

hi, do u have a way of alternate colors in a writer document :? thank u

If you import a PDF to make it a fillable form, The PDF opens in Draw. Do the same rules for making the PDF into a fillable form remain the same in Draw as they do in Writer?

thank you

Really helpful video. Very clear and not too roomy.

Very informative? Can i do same import from text files as well ?

Absolutely amazing

Thanks a lot.

Ha! Well done! I'd never have guessed the 1,1,1,1 trick in a million years! Thanks!

It works for me, but the issue is that 5 minutes exactly my monitors wake back up without any input and nothing I've looked up will fix it.

This was a super helpful tutorial. Thank you Melissa. Any suggestions on how to add/track important dates in this annual dynamic calendar - based on a separate tab list (holidays, PTO, task names on due dates, etc). I'm not able to add in rows in between/under each week to bring in key notes on specific dates.

This was a super helpful tutorial. Thank you Melissa. Any suggestions on how to add/track important dates in this annual dynamic calendar - based on a separate tab list (holidays, PTO, task names on due dates, etc). I'm not able to add in rows in between/under each week to bring in key notes on specific dates.

Can I change the checkbox in the 'generate pdf' from X to a nicer looking 'vink'?

thanks

Thanks for the tutorial

Thanks

Thanks this saved me pulling out my remaining few hairs ! 🥰

Thank you