I created a model but how can I run it with different data source file of the same structure?

[excelos]

Hello


I created a model with the calculated columns, the dashboard etc.

How do I run the same model using different data files as sources which have the same structure, just additional or fewer rows?

 

[Rijnsent]

Hi Excelos,
with "run the model" you probably mean: replace the data in your model-file with data from another file? I'm now assuming you have one table in your model where your "base data" resides and that those other data files have just that same "base data" layout, but with a different amount of rows. What you would probably manually do is empty your table, open the new data file, copy the data part and paste it into your model. After that, run the calculation and you should have an updated dashboard etc.
If that's your route, you could first do that manually while you're recording a macro and use that recorded macro to build some more VBA code to do that job for you automatically. When you have some code to look at, please do post it here (in CODE brackets).
Cheers,
Koen

 

[excelos]

I actually created a new parameter and now it asks for a source file path when I open the template.

However, I would like that dialog box to offer a 'browse' button to locate a file locally or paste a url. Is it possible?