Excel 2010 - How to quickly add multiple hyperlinks to different cells

Question

I want to create n DataFrames using the value s as the name of each DataFrame, but I only could create a list full of DataFrames. It's possible to change this list in each of the DataFrames inside it?

#estacao has something like [ABc,dfg,hil,...,xyz], and this should be the name of each DataFrame
   estacao = dados.Station.unique()
   for s,i in zip(estacao,range(126)):
     estacao[i] = dados.groupby('Station').get_group(s)

Solution 1

I found that calculating the file path like this worked:

=Hyperlink("file:///" & "C:\...")

Solution 2

You could use =Hyperlink("path/" & a1 ) then copy it down. A1, B1 etc would include the extra but of the hyperlink that changes

Comments

[Dave]

Right... and where does the hyperlink come from? Can you please provide some real examples. What is the value of Cell A1 for example? And what is the hyperlink to be?

[R Schultz]

What is the end goal? 1000+ links to folders seems like you may be trying to do something with excel that would be done better with another tool.

[Vali]

I'm having problems with the "path" of the folder part, could you please help with that? thank you.

[user301746]

Either the full unc path if it's on a network e.g. \\server\dfs or the absolute Windows path C:\folder . I suppose ActiveWorkbook.Path in VBA might make it more portable if needed

[Vali]

Thank you, i will try that, but any other ideas will be useful.