vinmam123VBA
New Member
- Joined
- Dec 18, 2020
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hi Friends,
Can you please help me with VBA code where I can select Multiple files at once by Browsing.
For example-
I have four files in one folder. Below are the file names(File names keep changing)
1.Source1
2.Source2
3.Source3
4.Source4
I need trying to come up with options where I can Browse and select these files something like below
Select file 1 -- Option to browse and select one file
Select File 2 -- Option to browse and select second file
Select File 3 -- Option to browse and select third file and so on
After these I need to make Changes in the files. For that I should be able to select the opened file through variable name(Because file names keep chaning)
For example-
Once I open all four files If I want to go to sourcefile3 and make some changes then I should be able to do it by activating this file by variable name
Regards,
Vin
Can you please help me with VBA code where I can select Multiple files at once by Browsing.
For example-
I have four files in one folder. Below are the file names(File names keep changing)
1.Source1
2.Source2
3.Source3
4.Source4
I need trying to come up with options where I can Browse and select these files something like below
Select file 1 -- Option to browse and select one file
Select File 2 -- Option to browse and select second file
Select File 3 -- Option to browse and select third file and so on
After these I need to make Changes in the files. For that I should be able to select the opened file through variable name(Because file names keep chaning)
For example-
Once I open all four files If I want to go to sourcefile3 and make some changes then I should be able to do it by activating this file by variable name
Regards,
Vin