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.
@928Apache2 күн бұрын
Thank you!
@praveenpshenoy82142 күн бұрын
Thank you❤
@jamesrichie84425 күн бұрын
Thank you, you solved my problem 🎉
@nirmalmathew43126 күн бұрын
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?
@lucyandethel17 күн бұрын
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.
@innongwenyah9 күн бұрын
Great
@donaldson110 күн бұрын
thank u so much, so easy and straight to the point
@uwhelper10 күн бұрын
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.
@mkirby200011 күн бұрын
Melissa, Thanks. This was very helpful.
@tekrunner98711 күн бұрын
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.
@tiagomelo807112 күн бұрын
Thanks very much!
@muhammadalizaffar24412 күн бұрын
Great, very helpful
@meylakshmanan173512 күн бұрын
Excellent. Thanks
@mamdouh73314 күн бұрын
Thank you ❤ ur amazing. Hi from Egypt.
@joseyow114 күн бұрын
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.
@donnasaud510816 күн бұрын
YOU'RE A LIFE SAVER! THANK YOU!!
@DK_Son16 күн бұрын
This was incredible, and so easy to follow along with! Thank you for this!
@linaalsaedi22418 күн бұрын
♥️♥️
@herseem19 күн бұрын
Outstanding, really made me re-think how to get information from participants in a trial.
@generybarczyk699319 күн бұрын
Verr interesting. Mucho Danke.
@Abzarad2 күн бұрын
qué es eso sprache my friend LOL
@user-hh7ms5mj8m21 күн бұрын
A calm, cool and fully prepared trainer with curated content. :)
@David-xz7rb23 күн бұрын
The only issue I'm having is this completely disabled RGB in my case..
@braingenius568623 күн бұрын
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?
@NYAKALLOMOKELE-qp3oj25 күн бұрын
Thank you so much for your help but now how do I sort the data?
@salvinabraganza872425 күн бұрын
Generally when all data is in one file the file becomes heavy. does the combine file also get heavy once data is imported?
@HINATASANDY25 күн бұрын
Excel version please
@ajaykumargupta637126 күн бұрын
mam not showing after export send mail for selection....pls help
@treesmadeclear27 күн бұрын
Thank you
@MX5195927 күн бұрын
Hi Melissa thank you so much for this tutorial, you are so easy to understand. John from Australia.
@yosrayari955527 күн бұрын
thank you it's really helpful
@edolson701419 күн бұрын
It is much easier to use Chat GPT. Just paste the screenshot into Chat GPT and say "Can you generate a table of text based on the screenshot I pasted here?" Voila!
@abhishekkamble989528 күн бұрын
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..?
@favoursamuel8963Ай бұрын
Thanks for this, how do I achieve same result in Google Sheets?
@user-ju8jg1fj6mАй бұрын
hi, do u have a way of alternate colors in a writer document :? thank u
@craigbertrand6011Ай бұрын
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?
@craigbertrand6011Ай бұрын
thank you
@DeeInkersoleАй бұрын
Really helpful video. Very clear and not too roomy.
@Sabuz73Ай бұрын
Very informative? Can i do same import from text files as well ?
@MelComptonАй бұрын
Hi. Yes it should work the same way. :)
@BeentoTheCross9 күн бұрын
@@MelCompton When I navigate to the folder with my text files, there are no files to select. Any ideas why I am not seeing my files?
@simransultan8483Ай бұрын
Absolutely amazing
@RobertoJRHАй бұрын
Thanks a lot.
@David8nАй бұрын
Ha! Well done! I'd never have guessed the 1,1,1,1 trick in a million years! Thanks!
@Shaego_NadirАй бұрын
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.
@jillianrisseАй бұрын
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.
@jillianrisseАй бұрын
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.
@dd4allАй бұрын
Can I change the checkbox in the 'generate pdf' from X to a nicer looking 'vink'?
@JL-pg4pjАй бұрын
thanks
@fankafabioАй бұрын
Thanks for the tutorial
@ahmadalkhorashi3125Ай бұрын
Thanks
@appleseed_316Ай бұрын
Thanks this saved me pulling out my remaining few hairs ! 🥰