Help me on this error 490

[Marziya]

Hi

I am trying to program the "On Click" event on a command button to open an excel spreadsheet that it locates on our network drive of our office; unfortunately after I transfer file to another computer in our network to present it, the vb code that I addressed doesnt work.
is there anybody to help me and explain where is the problem?


Another problem that I am struggeling with is, I cant add our network drive to trust location of access.

thank you
Marziya

 

[Gasman]

And you never thought to show that code or explain what the new path now is?

Code should be be within code tags please. See my signature for how.

 

[Marziya]

And you never thought to show that code or explain what the new path now is?

Code should be be within code tags please. See my signature for how.

sorry

Private Sub btnPics_Click()
    Application.FollowHyperlink "V:\New Projects\VolvoTankN12\Pictures"
End Sub

I address a folder on our network like as write.

also

Dim x As Excel.Application
Set xlTmp = New Excel.Application
xlTmp.Workbooks.Open "V:\New Projects\VolvoTankN12\Invoices\InvoicesDetails\VolvoTankN12.xlsx"
xlTmp.Visible = True

and this code for opening the excel file.

both of them is located in our network.
I should mention that our network is workgroup network.

 

[CJ_London]

What is description for error 490?

Another problem that I am struggeling with is, I cant add our network drive to trust location of access.

presume you have ticked or tried to tick

Also check with your IT dept, they have the option to disable this ability

 

[Marziya]

I thick this checkbox

What is description for error 490?


presume you have ticked or tried to tick
View attachment 104814
Also check with your IT dept, they have the option to disable this ability

Error 490 - Cannot open the specified file
I got this error in another computer for opening the folder that I address in vb . but the folder is located in our share network and the address is the same for all users.

thank you for your answer but I already ticked this checkbox.

what option should I ask them to check?

 

[Cotswold]

Can it be that the Excel file is in use by another user and they are preventing you from opening it?

 

[CJ_London]

what option should I ask them to check?

ask them if they have disabled the ability to set trusted locations - usually applies to all office products, not just access

And have you been able to set the trusted location for both
"V:\New Projects\VolvoTankN12\Pictures"
and
"V:\New Projects\VolvoTankN12\Invoices\InvoicesDetails"

or at least set to

"V:\New Projects\VolvoTankN12"

and allowed sub folders

since you are not using UNC paths, you need to confirm all mapped drives are consistent across all computers - if they are not, this may be another reason

 

[Marziya]

Can it be that the Excel file is in use by another user and they are preventing you from opening it?

I dont think so because it was closed.

 

[Marziya]

ask them if they have disabled the ability to set trusted locations - usually applies to all office products, not just access

And have you been able to set the trusted location for both
"V:\New Projects\VolvoTankN12\Pictures"
and
"V:\New Projects\VolvoTankN12\Invoices\InvoicesDetails"

or at least set to

"V:\New Projects\VolvoTankN12"

and allowed sub folders

since you are not using UNC paths, you need to confirm all mapped drives are consistent across all computers - if they are not, this may be another reason

none of them couldn't be added to trust location.

 

[Gasman]

So put the file somewhere that is trusted and try opening from there. If that works ..........

 

[CJ_London]

none of them couldn't be added to trust location

does that mean all of them are added to trusted locations?

trusted locations for excel are separate from trusted locations for Access - they each have to be selected, have you done that for excel?