Hey IS Forum!
Right now I'm trying to solve an issue I faced while using one of my macros that I made a while ago.
Purposue of my macro is perform some tasks regarding appending new columns in files that have to work with on a daily basis.
Lately, unfortunately, instead of one file there are several files that I receive for analysis event though it is the same in terms of its content.
I know that I can append them and run the macro but there is some specific issue that i think when resolve on my end would be able to help in my future work.
To the point. Is it possible, knowing that contents of given file are the same as in previous one on which a macro was created, to change somehow below listed line of code to perform task on active (opened) database instead of specific one whith a name as in this example "DATABASE NAME"? What I mean, is possible to run my macro on different files with different names without a need to change their (databases) names or changing the code of the macro for each specific file?
Set db = Client.OpenDatabase("DATABASE NAME")
Thank you in advance!
Last seen: 3 months 1 week ago
Joined: 02/11/2021 - 03:04