I'm working on a project that requires moving data between two workbooks. The source workbook is password protected, which I can get around. The source file is always in the form FT_MMDDYY.xlsx. In my work book, I just need to manually enter the value of MMDDYY. I originally wrote the code the month of October (10) and everything worked fine. Now that our months are single digits, nothing I enter works. I've tried changing B1 to a text cell, enter the date as "012224", etc. Nothing works??? What am I missing???
secondly, the following commands works perfectly in Windows:
DataLake = "FT_" & Worksheets("Booked").Cells(2, 2) & ".xlsx"
MsgBox (DataLake)
Windows(DataLake).Activate
On a MAC, the script fails on the Windows command. What can I replace this with??
Thank you !!
secondly, the following commands works perfectly in Windows:
DataLake = "FT_" & Worksheets("Booked").Cells(2, 2) & ".xlsx"
MsgBox (DataLake)
Windows(DataLake).Activate
On a MAC, the script fails on the Windows command. What can I replace this with??
Thank you !!