Currently I'm trying to import the info from access query to the excel worksheet ( actually I should say "link"), Because the file will be distributed to different user, so I think I have to use Relative path to link them, the only way we can achieve this is using Vba, however, I'm not familiar with VBA, please can someone give me an example of the loop. THANK YOU a lot!!!
Basically, I want to import the data from access Load report #2 (query) into Load report #2 (excel worksheet)
The pics below show the location of these files.
1.
2.
3.
Basically, I want to import the data from access Load report #2 (query) into Load report #2 (excel worksheet)
The pics below show the location of these files.
1.
2.
3.
Last edited:
