Frankvk
New Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Use xlsm as a data source
Hi AAB, Thanks for the reply, that's what I thought. The problem is the xlsm is a 'masterdata' file, linked to others files with loads of data. I use VBA in the file to link files & filter the data I don't need. However I resolved it by adding another vba script in the that copies all and paste value in a new file which I then can use as a datasource. Thanks again ! Regards, Frank845Views1like1Comment