yyyy-mm-dd

Hello Excel Community, I have a weird request which I am hoping someone might be able to provide a solution. I have rows where dates are provided in the following format yyyy-mm-dd and contain multiple dates in that format (Example: 2023-04-062023-04-072023-04-08). What I am trying to...

Hi All, I need help with a Select Case in my code. I'm new to VBA and have never used the Select Case function. With my online research, I found some examples, but none is really giving me the information that I need. When the user call a UserForm (frmResource) from any one of the sheets Monday...

I have a date stored in a variable: invDate (mm/dd/yyyy). As part of my sub I need to convert it to text in the format "yyyy-mm-dd". I've seen several solutions on this board, but for some reason they aren't working for me: expItemDate = VBA.Format(CStr(invDate), "yyyy-mm-dd") - doesn't work...

Hi Folks, I haven't had any luck in getting my code to reformat Date from 5/14/2018 to something without the forward slash. The code I found when I searched for a solution simply doesn't work for some reason. Here's my code showing all the iterations I've tried to reformat the Date...

Hi guys so I have a module that is crashing excel every time and I don't know why. I will paste it below. This path does not have two string variables declared; destinationpath and sourcepath When I try to add the declarations (as seen below), then press f8 to step through the module, the...

Hello. I am trying to create a macro that every time I close the file the macro makes a copy of that file. So far I have this but it still does not work well. Someone can help me? Thank you, Isabel Sub auto_close() If ThisWorkbook.Path = "\\Servidor\servidor\ORÇAMENTOS\orç - A Fazer"...

I looked, but don't see this posted, yet. This is a newbie question for someone learning VBA. I'm looking to format a date as text using a VBA formula. Why? Well, the reason is because the spreadsheet is exported and downstream is wanting a yyyy-mm-dd format. I'm looking to create a version of...

Hi there, I have a worksheet with 5 dates in cells (A1, A101, A201, A301 & A401) - they are all formatted dd/mm/yyyy I need to copy the date from these cells to other cells on another sheet but change the formats to yyyy-mm-dd - I thought I could use: Date1 = Sheets("Sheet1").Range("A1").Value...