Posts by JBMS

Hi Roy,

After running the above code results are not populating. Only the excel sheet is created in the folder with the naming convention "UniqueEntries".

There is no data in the sheet.

The error occurred at the end(after running the code)

Hi Roy,

Thanks for your kind help.

Tested the code, following are the observations.

1) After running the code one message box pops up. I have attached the screenshot of the same.

2) One excel file is created in the folder with the naming convention "UniqueEntries"

Request you to please assist.

Thank you for your message.

1. Yes the code should open the each workbook in the folder and run the count

2. Yes each file will have data in the same column and will have only one sheet.

3. Yes the results should populate in a new excel sheet along with the file names.

Thank you.

Hi Roy,

Thanks for your kind response. Please find the details below.

1) There are multiple excel files in a folder.

2) In column "A" of every excel file details of employee IDs are there. Employee ID is a combination of alphabet and numeric value. The example is provided in the attached excel file.

3) The employee IDs of a few employees are repeated multiple times in the same column(column "A").

4) Need a VBA to provide the count of unique values in column "A" for all the excel files in the folder.

5) The count of unique values in column "A" of each excel file should be populated in a new excel sheet along with the file names.

6) Sample excel sheet is attached. The unique value count should be 6 for the file which is attached.

Your kind help is highly appreciated.

Thank you.

Hi All,

Need your help for the requirement.

Hi All,

Need your assistance for VBA code to get count of unique values in one particular column(column "A")

There are multiple files in a folder and for all the files the data is in column "A".

VBA to generate the unique values count in separate excel sheet along with file names.

Thank You.

Hi,

Please suggest a way to make the VBA run faster. The provided code was working really well, however taking little time for the excution. Your help is appreciated.

Hi,

Thank you it is working now. However, it is taking a lot of time. Please advise.

Hi,

The above code is running, however, the changes are not made to the files in the folder.

Hi,

Yes, it is giving an error pop up message as "Run-time error '438':
"Object doesn't support this property or method.

1) Just to be more specific. All the files in the folder are in XLSX format and the data is only in sheet 1 of the workbook.

Hi,

Thank you for your quick reply. Appreciate your help. Need the VBA to apply the changes to all the xlsx files in a folder. So the macro/VBA should change the sheet width and height to 1 Page. Orientation as "Landscape" and Paper Size to "Legal". Request to extend your support.

Thank you.

[xpost][/xpost]

Hi Team,

Need assistance for the below query.

VBA to select the Width and Height to 1 page, Orientation as Landscape and Paper Size to Legal for multiple xlsx files in a folder

Hi,

Thank you for your help.

Hi Team,

I need help To Increase the width of the columns in a sheet for multiple files in a folder using VBA.