[Solved] Variable Links to Named Array

[Cat101]

I have a large, multi-tab spreadsheet that is created monthly.
I need to grab a named array from the prior month for year-to-date numbers, as well as, prior year-to-date numbers.

I've created the links to change year and month, so I have the right directory to pull from.
example: 'file:///X:/bookkeeping/Stats/CB-10/2025/2025_10_EOM_CB10.ods'#$Entry_FR.F3

i know I can create the link within each cell, but that would mean they'd have to be changed every month - they have one MasterSheet
which is used monthly. I studied PathURL that was used for Hyperlinks, but I dont want to have to touch it, so that doesn't work.

I've been struggling with this to long -- any suggestions?

[Zizi64]

any suggestions?

• Do not use links to an another files. It may cause some errors. Work in a single spreadsheet file

• Use macros to import data from the other files. You can import (get/put, copy/paste) more than one data by one macro

[Cat101]

Oh, If I could be in one file & one directory, it would be so much easier. However, each month has 10 sheets & is a small monster on all it does, to add all of these into one year wouldn't work well. Plus I'd still have the problem of prior year..

Anyway, I've had little experience with macros & except for recording key strokes, and that was a bust. Any suggestions on where to start with best understanding macros?

[F3K Total]

Hello,
did you try to change the complete source file:

ModifyLinks.png (74.44 KiB) Viewed 6036 times

R

[Cat101]

I dont believe Ive ever looked at that... thanks

[Cat101]

Hello,
did you try to change the complete source file:ModifyLinks.png
R

Humm, when I first tried this, it didn't keep me in the directory of the file -- maybe I had to many windows open? But I had to select down, 5 levels to find the file & that sucked, especially when my mind couldn't remember them all.. SMH..

But when I have the one file open ONLY, it stayed where it needed.. which is a YEAH..
I first tried "UPDATE" but all I got was the circle of death. But Modify worked & the most they hav to do is go back one directory & go forward one,
those are doable. When I changed the source file, it changed all the links in the file, which is very cool.. THANKS for pointing it out.. Now to show it to the users & see if it works for them..

I'll keep looking for a good overview on macros -- I've seen lots of code, but I'm looking for a big picture and overview on them. I see they can be written in Basic or C#, I think, both of which I've done, but never for an open office spreadsheet. I can assume a million things, like is a compiled or realtime - or is that only old world words? When its loaded is it only for that spreadsheet or is it for the world -- I've made that mistake on templates & paid dearly for that.

Well, it's Christmas Eve now & this project is acceptable, time to go.. Merry Christmas all..

[Lupp]

(Spoken aside:)
I never used such links for a long time now, and I have to confess that I didn't thoroughly study this thread therefore, but the subject reminded me of the very first bug I ever reported (in march of 2013 in a bad beginner's style):
https://bugs.documentfoundation.org/sho ... i?id=61743
Well, that's for LibreOffice, but from "legacy" times.
Since 2013 I reported about 100 bugs, and very many of them are resolved (fixed), some within days.
The linked one was not.