Thank you for sharing this - it is useful and very quick. If I want to get Modified date in 2nd column with folderPath, how should I do it? like I have xyz.xml file but it appears to be in 4-5 different folder under one-XYZ folder and each folder has same filename but different modified date & different sizes. I want to pick the most recent one into excel sheet OR show all but Most recent one on top most row. Appreciate it your time/help!
Dear Sir , I have See your Tutorial , You have Not discuss ,How Select Next (Middle) Empty cell Offset Function . Could You Please Describe the Middle Offset Function ,
@@mostainbillah offset just takes where your range and moved it up or down or left and right. I use it a lot when deleting a sheets contents. I will use the select current region and I will offset it by 1 row so it doesn't delete the header row. I haven't used the middle function so I can't help there
I guess someone will need this: -First of all in Excel Reader that is reading your file you need to set "Select sheet-> By name [Jan] -Then in Flow Variables, for sheet name you set "Sheet" that comes from "Table row to variable loop" -And for me I had error in Loop end that thinks column count is not the same so just check: -Allow variable column types & Allow changing table specificationns I had these issues I have 12 sheets for months that I want to be 1 table with all Months 😅 This video helped me so now I help anyone who needs !
You're a damn good teacher for an old fart like me. The last programming I did was around the turn of the millennium. (except for a few modifications to old, existing ones)😂
@@EverydayVBAExcelTraining Well the line that VBA stops at is : Workbooks("historicalweeklydata.xlsx").Activate or Workbooks(2).Activate I also receive same eroor in other VBA macros trying to select a SHEET. Again all this has worked for years in 2007 but not in later version (2021) of Excel. There are other issues trying to open links to web sites that have never been an issue prior.
Thank you! My professor wanted us to create a function just like yours without using the "application.worksheetfunciton.sum" command. However he wanted us to use "for loops" instead of the "for each".
Thanks for sharing this VBA code. Could you help me with the Macrocodes in this senario? Sheet 1 (DATA) is where I will input the details and Sheet 2 (DATABASE) where it will be save as a database. Senario: In Sheet 1 (DATA) using column, I will put up to multiple entries: DATA SHEET column sample: name/age/phone Jay/12/123 Joy/16/456 Will create command button SAVE. Condition: Once i click the save button, if the names are new entries the data will automatically move to the DATABASE sheet then clear the entry in the DATA SHEET proof that already moved to the database sheet. however, if the name is duplicate there will be a prompt that I have a duplicate value and won't be able to save in the DATABASE sheet. Also the data are retain to DATA Sheet to identity easily the duplicate. Thank yo in advance.
Hello, i am have a similar issue but i cant fix it :( ..not sure where to mae the changes..can you please share your Email address? So that i can share the code with you as it's quite long.
I am trying to use this code to do this with defined tables on both worksheets but I keep getting a 424 error (MasterTracker and MasterTracker4 are the table names to move from and to respectively). How do I go about doing exactly this with defined tables?
Is it possible to save as PDF instead of .xlsm? I tried to replace filename = Application.GetSaveAsFilename("Default Name of Saved File", _ "Excel Macro Files,*.xlsm", 1, "Save the File") Debug.Print filename with filename = Application.GetSaveAsFilename("Default Name of Saved File", _ "PDF,*.pdf", 1, "Save the File") Debug.Print filename and I get a file that is saved in PDF but I am unable to open it.
Hi,. thanks for the video. Can you please help me to detect the error that it is triggered in the last line: ThisWorkbook.SaveAs Filename:=nombreFichero Sub backAuto() RunTimer = Now + TimeValue("01:00:00") Application.OnTime RunTimer, "backAuto" 'nombreFichero = "c:\temp\Excel\" & Year(Date) & Month(Date) & Day(Date) & Hour(Time) & Minute(Time) & Second(Time) & ".xlsx" nombreFichero = "f:\davidtemp\" & Year(Date) & Month(Date) & Day(Date) & Hour(Time) & Minute(Time) & Second(Time) & ".xlsx" MsgBox nombreFichero ThisWorkbook.SaveAs Filename:=nombreFichero End Sub
Eu tenho um botao com mousemove, mas ele so é ativo quando eu clico em outro botao, tipo: Ele é para atualizar, mas ele so aparece quando eu chamo os dados para serem atualizados, dai ele fica com efeito de MouseMove, nao sei como fazer, pois se deixo ele assim, mesmo que coloque .visible = False, por ele ter o mousemove, ele aparece, o que fazer e como fazer?
Man! Your Array videos are the best. I am just starting off with Excel VBA and this is the simplest yet most comprehensible videos I have come across on the whole internet. Thanks, man!
@@EverydayVBAExcelTraining I've set it back to general number and taken out all the table level default zeros - in and working again until a moment ago, I had just done a batch sql update and insert on tables and now I've got div/0 going on. So, there must be zeros progating somewhere.
Yeah, I have constantly gone back an forth on that one. To not define variables is NOT best practice but it also takes time to explain on videos and can be more confusing for someone new to vba. I don't know what the right answer is here.
Funny story. I do this very rarely but found it very useful so I posted the video. About a year later I forgot I had done the video and when I googled how to do this my video came up. Haha Glad it helped
Thank you so much! question, is there a way we could make the sheet number dynamic? I tried Sheet&"i" with i as an integer and i increases by 1 each time it goes thru the loop, but always get an error. Much appreciated..
Sheet.name & I This should do the trick. Sheet is an object that contains cells, format, charts, shapes etc. so you need to tell it what part of the object you want and in this case it is .name
VBA can select by the name of the sheet which the user can change. You can also select by the code name or even the index (sheet number left to right) I typically use code name because then the end user can't mess up my code
Do you know a way to create an alias for the username section of the file path. Similar to the path you extracted, my organization shows the individual usernames near the beginning of the string. I created a macro that will copy and paste data from a template into a new workbook and save the new workbook as a defined cell reference. It works perfectly for me but my coworker cannot run it on her machine.
You would need to add some error handling. How I would research the.problem is write a simple macro that checks for an Alias or username on their PC and prints it in A1. Then you will be able to isolate if the error is the alias. The other thing to check is permissions on the folder