Geek Answers Handbook

Relative file paths for Excel data connections

I have 7 csv files and one xls file. In the xls file I have 7 sheets (one for each csv file). I can create a data connection that will read every csv file into a given sheet. However, when I zip the xls and 7 csv files and send them to someone, they cannot open the data in the xls file because it is trying to access the files on my computer (C: /Desktop/MyComputerName/file.csv). Can this link be made relative? Is there any other way to access the contents of a csv file without making it cell by cell?

+7
file excel connection
source share
2 answers

According to further research, this is not possible without writing a VBA / macro script using the workbook path.

+7
source share

With VBA, you can simply record a macro when creating a data import, and then check the generated VBA. You can change the macro and use it to load data from anywhere.

+1
source share

More articles:


All Articles