Dynamic Objects in vba

[therenjithr]

I have multiple workbooks and worksheets and I need to create multiple objects for the same. Number of sheets are not finite but I want to use all objects at different scenarios. I tried to create dynamic objects but didn't help. Please suggest.

 

[Sektor]

What are you talking about?

 

[therenjithr]

please ready carefully

 

[therenjithr]

please read carefully

 

[Norie]

Can you explain further?

Workbooks and worksheets are objects, are you trying to 'dynamically' reference them in some way?

 

[therenjithr]

I am browsing these workbooks from a folder and their are saved from a different source. When I browse and open each workbooks from a folder, I want to set an object name to each workbook and worksheets within that workbook

 

[Norie]

Are you opening the workbooks manually or with code?

If it's the latter it's easy to set references to the workbooks you are opening.

If you have a reference to a workbook you can easily reference the objects, eg sheets, within the workbook.

 

[therenjithr]

I am opening workbook with code. But the issue is there are many workbooks in a folder and each workbook can have multiple worksheets.

 

[Norie]

What are you doing with the workbooks/sheets?

Are you opening all the workbooks at the same time?

 

[therenjithr]

I am opening one workbook at a time but all workbooks will be be opened. I want to set a variable name to each worksheet in a workbook and workbooks can be multiple.