Can I eliminate this "File Now Available" -- Read-Write error message?

[EssKayKay]

Hello,

I’m receiving an error when attempting to run a select part of my code. There are eight parts of my total routine. However, when testing, it appears the second portion is where my problem occurs (cmdTest2_Click).

The error is:

Here is a snipit of my code –

Private Sub cmdTest1_Click()
Application.ScreenUpdating = False
Application.EnableEvents = False

ActiveWorkbook.Save
Range("TempCell") = "Repair"

'- - - - - - - - - - - Set variables - - - - - - - - -
Dim FilePath, FileOnly, PathOnly As String
FilePath = ThisWorkbook.FullName
FileOnly = ThisWorkbook.Name

   Range("T5") = PathOnly
   Range("T6") = FileOnly

   Range("T16").Copy
   Range("U16").PasteSpecial Paste:=xlPasteValues

'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Call ClearALL

Dim aFile As String
On Error Resume Next
    aFile = ActiveWorkbook.Path & Application.PathSeparator & "Amort_Temp.xlsb"
    Kill aFile

    ActiveWorkbook.Names("LookupDate").Delete
    ActiveWorkbook.SaveAs ActiveWorkbook.Path & Application.PathSeparator & "Amort_Temp.xlsb"
End Sub



‘. . . . . . . . . . .  IT APPEARS THIS IS WHERE THE PROBLEM OCCURS  . . . . . . . . . . . . . . . . . . . . . . . . . .

Private Sub cmdTest2_Click()
    Application.DisplayAlerts = False
    Workbooks.Open("" & Range("T5") & Range("T6") & "").RunAutoMacros Which:=xlAutoOpen
End Sub

T5 = C:\Users\?????\Desktop\
T6 = TryMe.xlsb

I was hoping to find a way to open TryMe NOT as Read Only. I would have thought being Read Only wouldn’t matter as I am only copying from TryMe not modifying it but apparently this is not the case. Any suggestions would be appreciated.

Thanks for viewing,
Steve K.

 

[RoryA]

As you should well know by now:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Is there a way to suppress a "File Now Available" message?

Hello, I posted this elsewhere but have not received any response. I�m receiving an error when attempting to run a select part of my code. There are eight parts of my total routine. However, when testing, it appears the second portion is where my problem occurs (cmdTest2_Click). The...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[EssKayKay]

Here's is the link to my other post as requested.

Is there a way to suppress a "File Now Available" message?

Hello, I posted this elsewhere but have not received any response. I�m receiving an error when attempting to run a select part of my code. There are eight parts of my total routine. However, when testing, it appears the second portion is where my problem occurs (cmdTest2_Click). The...

www.excelforum.com

I assume the reason people double post (or at least is the case in my point) - I feel the more eyes looking at a problem the better the chance of finding a resolution.
I will probably not stop double posting in the future when I do not find a "fix" to what ever is the problem is but I will most certainly note my double post in both forums.

Thanks for the heads-up - much appreciated,
Steve K.

 

[RoryA]

I'd already posted that link. Please post all others.

 

[EssKayKay]

I'd already posted that link. Please post all others.

That's the only two I have - sorry,
SKK

 

[RoryA]

That's only one link (you just reposted the EF one I had already posted). I know you have at least one other...

 

[EssKayKay]

That's only one link (you just reposted the EF one I had already posted). I know you have at least one other...

I'm sorry Rory but I'm confused. I have about 27 postings over on EF dating back to 2006. There are a few I posted in the last few months. Do you want these links?
Again, I'm not quite sure how to proceed.

 

[RoryA]

No. You have posted this question on at least one other forum (besides EF). That is what we need links to.

 

[EssKayKay]

Ahhh - I think I figured this out.

Redirecting

SKK

 

[Alex Blakenburg]

What is the issue you are having when open the workbook as Read-Only ?