vba - validate previous month file selection

[Mallesh23]

Hi Team

I want validation to cross check whether user has selected correct excel files.
Every Input file Range("a1") has this line :-ABC Limited (Period = Apr-2020 - Apr-2020)
This is the standard format only month and year get changed.

My task is to validate previous months file, to current months file selected.

if user select may months file as current months , previous file should be April months.

Current Month ABC Limited (Period = May-2020 - May-2020)
Previous Month ABC Limited (Period = Apr-2020 - Apr-2020)


Thanks in advance
mg

 

[Mallesh23]

Hi Team,
This is my File name,

A	B
Current Month File	Previous Month File
ABC XYZ INDIA PRIVATE LIMITED (Period = May-2020 - May-2020)	ABC XYZ INDIA PRIVATE LIMITED (Period = Apr-2020 - Apr-2020)

Sub TEST()

Dim CurrentMonth As String
Dim PreviousMonth As String

CurrentMonth = Split(Range("a2"))(7)
PreviousMonth = Split(Range("b2"))(7)

MsgBox CurrentMonth
MsgBox PreviousMonth


'output - CurrentMonth = May-2020   compare here previous month should be Apr - 2020
'output - PreviousMonth  = Apr-2020  


End Sub

 

[Fluff]

Cross posted vba - extract month and compare

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.