I have about a hundred XLSX files in a folder. I'm using the VBA code below.
VBA correctly inserts a Date into all workbooks but does not display the correct format. It is as if the Enter key function is missing.
All workbooks already have formatted cells by Date "dddd - dd.mm.yyyy".
Attached is one of the closed workbooks that Inserted/Replaced Date.
Part of the VBA code I use in the 'Master' workbook.
btw: I'm a beginner in VBA
Does anyone know how to solve the problem?
VBA correctly inserts a Date into all workbooks but does not display the correct format. It is as if the Enter key function is missing.
All workbooks already have formatted cells by Date "dddd - dd.mm.yyyy".
Attached is one of the closed workbooks that Inserted/Replaced Date.
Part of the VBA code I use in the 'Master' workbook.
btw: I'm a beginner in VBA
Code:
For i = 1 To myN
With Workbooks.Open(myFiles(1, i) & "\" & myFiles(2, i))
.Sheets("Product").Range("C6").Formula = ("31.10.2019") 'change to suit SheetNameTab and Value or Formula
'.Application.SendKeys "{ENTER}" 'not work?????????????
.Close True 'close and save wbk
End With
Next