Recent content by richand1

Sorry! The reference for that line should be K:K, but yes, that is the intention. J:J is where the file location is stored. K:K is where the new save location is stored. But they are all on the same sheet: "File Directory". Thank you, Skip.

Thanks for that, Skip, although with the below code I can get the first file to open (I had to remove the table references as I couldn't get them to work): For Each hlink In ThisWorkbook.Sheets("FileDirectory").Range("J:J").Hyperlinks With Workbooks.Open(hlink.Address) .SaveAs...

Skip, the code you provided throws an error. I get the following: On line: With Workbooks.Open(r.Address) The cell reference in the error dialogue (if you'll consult the picture I provided you(!)) is the correct reference of where the first file location is stored. I'm guessing the error...

Thanks again, Skip. As long I've made someone feel fuzzy and warm, it's been a good day! I'll try this tomorrow. Rich

Hi, I have some code which loops through a given folder and deposits filenames and their locations among other details into a table on a worksheet: I have some code that then loops through the Hyperlinks in the "File Link" field/column and saves these files to a static location within the...

Thank you, Skip. I see what you're saying and it makes absolutely sense.

Skip, As always, thank you very much for your excellent response - this works flawlessly. Thank you, Rich

Hi all, I've found many things like what I want, but nothing that gives me it exactly. I've been trying to get this right for 2 days now.... I have an Excel table, "ActionPlan", which starts at cell B101. The table can be variable length and forms a template which many colleagues will take and...

I figured it out. In my database, I had some linked tables which weren't using the UNC of the files they were linking to. The solution, for future solution-seekers, was to open Linked Table Manager and, instead of using any network shortcuts to browse to the files in the New Location dialog...

Hi guys, thanks for replies so far. Combo: sorry, that was a mistype, it should be a backslash. DjangMan: Still no dice unfortunately; I get the same error when I replace my code with that line.

Hi, I have scoured the internet for the last few hours looking for solutions to this and, while I have found a lot of information around this error, I have found nothing that seems to relate to my specific issue. When I run the below code (which I have not written myself, I have pieced it...

Thanks Skip. I'll have a go and let you know how I get on. Rich

Hi all, I have searched and searched for a solution to this but I can't seem to find one anywhere. I want to be able to embed any number of Excel files into an Excel worksheet and have the code run through each object, open it, print it and then close the object again. Sounds simples, but I...

Ah. Combo, thanks very much for this. When you said to search for projects containing "Database" I didn't take into account the "DAOTest" module itself. So, I removed the "DAOTest" module, added in the DAO 3.6 reference to the library, copied the "DAOTest" module back into Personal and it...

Thanks Geoff. I have: So, exactly the same references as the other workbook less the DAO reference, but of course it won't let me add the reference.