Recent content by CosmaL

Thank you all! I found out that the problem is on the sharepoint's file and the way that the form handles the attachement's link. Thanks!!!

Hi everyone! I have an issue: I get data from an online form via excel (linked table), which i append in my main table in access. Each record has a field with an attachment, which i get as text/hyperlink in my linked table. Is there a way to download the file and save it in a local folder...

Thank you all! I've used the proposed function from arnelgp !

Dear friends, i've got some cells with various string data. All of them contain-for sure- a sequence of characters like H500, H501, H600, H603 etc Is there any way to exctract only this sequence (H***) from each cell? Thank you in advance!

Thank you Isaac! Your advise is very higly appreciated!

Thank you, it's working!

Dear friends, i have the following statement in a loop. For i = 1 To 20 If (InStr(1, Range("E" & i).Value, "Valid", vbTextCompare)) And (Range("D" & i).Value >= 10) Then ... End if Next My question is if there's a way to declare as following: Dim ValidVar as range Dim ValidVal as...

I will correct everything, thanks! Path will be full now on! I think i wouldn't find the error while testing, because data.xlsm was activated during F8.

Thank you all once more for your help!!!!!!!!! :)

Is it possible to upload your file? I think i've lost something with the mods.

Still nothing. I think the problem is in both If Range("S" & i).Value = "Action" Then and inttrow I've changed it to "I" & i > '" and i got 1 result in line 4.

Sorry it's .xlsx, corrected

And after 18 should be 21, where S column is "action". It's really strange that inttrow remains 2, it should start from line 4.

I open it and then with block i copy the data from data.xlsm

introw gets incremented everytime at the end of the loop. If test.xlsx is closed, code does open it but it doesn't retrieve any data!