Automatically change file name when conditional formula is true

[hasan mougharbel]

Hello everyone,

I hope you're all fine today. I've developed VBA code (below) that generates Excel files based on a template excel file(attached below). Now, I'm seeking assistance to further automate the process for working with these generated XLSX files.

Specifically, I need help with a single automation step that involves renaming these Excel files. The renaming should only occur when a certain condition is met, indicated by the presence of a highlighted green color in column A, indicating condition is achieved.

To elaborate, I'm looking for a way to automatically add the word "checked" to the excel filename if and only if the condition(green color) in the file is satisfied. The condition is related to a specific formula in column A (sheet 1), which is to highlight $A$1:$A$2040 in green.

I'm open to any suggestions on how to achieve this automation in the most efficient manner and that requires minimal CPU power.

Thank you in advance for your support and expertise.

Please Login or Register  to view this content.

[Keebellah]

Hi, I have not downloaded your file but what you should do is add a variable newFileName
Fill it with the current filename
Before the wb.Close you add a check for that green column if it's green you edit the newfilenam to include the word "checked"
ins tead of wb.Close you do a wb.saveas with the new filename and kill the old file name or just close and save as you have noe.
I'll try and woirk it out but hope the idea puts you in the right track.
Since you've developed the VBA code this won't be too difficult for you

[Keebellah]

Try this:

Please Login or Register  to view this content.

[Marc L]

I'm open to any suggestions on how to achieve this automation in the most efficient manner and that requires minimal CPU power.

Hello,

for this the obvious is to avoid Excel and use a database software !

Anyway rather than a guessing challenge according to your Excel VBA procedure
in order to remove the useless - almost all actual code to trash ! - to be more efficient
you must create a new thread with your best elaboration of the VBA procedure purpose without anything to guess
and accordingly an attachment with a well reflective workbook (before & after states) without forgetting the csv text file …

[Keebellah]

The code explains what the result is the OP want.
No need (as I can see) for the csv files or whatever, just the code modification to do what the OP wants to achieve, no guessing for as far as I can see

[Marc L]

Hi Keebellah,

my previous post is based upon a specific initial post comment which has no link with this thread purpose according to filename
so my comment has no relation with the help you shared, the reason why I advised to create a new thread …

By the way your code message box text looks so weird !

[Keebellah]

Okay, the text looks weird because it's arabic

[Marc L]

Thanks. It looks specific as this codeline does not exist in the original code …