Posts by Sena • 33 points

• -1

  votes

  1

  answer

  148

  views

  Q: Can anyone explain what that expression is for and how to use it?

  I would like to copy more recent files from one directory to another. But besides being the mais recente (data de criação) I have other conditions for copying: Start with "Relatório Financeiro"…

  windows batch terminal

  asked 3 years, 3 months ago Sena 33

• 0

  votes

  1

  answer

  36

  views

  A: How to check dates past their expiration date?

  I managed to solve by changing the first condition with the following code: CDate(.ListViewEntradas.ListItems(i).ListSubItems(7)) < Date.

  vba listview excel-vba userform

  answered 3 years, 8 months ago Sena 33

• 0

  votes

  1

  answer

  36

  views

  Q: How to check dates past their expiration date?

  I created this Sub to process the data of my listview. However, the first part of my If is not working properly: .ListViewEntradas.ListItems(i).ListSubItems(7) < Date. I would like to leave in…

  vba listview excel-vba userform

  asked 3 years, 8 months ago Sena 33

• 1

  votes

  1

  answer

  1287

  views

  Q: Correct formatting for excel vba time

  Good afternoon! I’m finding a problem that I thought was basic but that I couldn’t solve. I have a Userform (Entradas) to register entries. These entries are played to my spreadsheet in Excel. In my…

  excel vba excel-vba excel-userform userform

  asked 3 years, 9 months ago Sena 33

• 1

  votes

  1

  answer

  284

  views

  Q: Runtime error 13. Incompatible types

  I was building a simple listing, and came across the 'Runtime Error 13. Incompatible Types'. When I Clear it tells me that the error is in the two lines of code of my 'If', referring to the dates.…

  excel vba excel-vba excel-userform

  asked 3 years, 9 months ago Sena 33