I am trying to open MX Excel using a command button. I have tried using a hyperlink and various codes that i have found online with no luck. The Excel file is being used by Access as it bring data from the spreadsheet and displays it within a subform. (I think this is where the problem occurs)...
Yes i can access the file no problem the file is stored on my desktop with the access files. I have the excel displaying data within the access program which is where i think the problem lies as i the access program i taking data from the excel but when i want to open it, it does not allow me to.
I am currently not using any code just a hyperlink to open the file. Each time i try i get two error messages one saying the hyperlinks can be harmful do you want to continue -> Yes.... Then second error message Cannot access 'file name.xls'
I am trying to open MX Excel using a command button. I have tried using a hyperlink and various codes that i have found online with no luck. The Excel file is being used by Access as it bring data from the spreadsheet and displays it within a subform. (I think this is where the problem occurs)...
Hi Apr, i have tried this with no luck i have tried removing the subform which is importing the excel file and the button then works but, when i put the subform back in it stopped working.
i have completed removed the subform and my button worked fine.
- Here is the code for my subform
Workbooks.Open filename:="C:\Documents and Settings\cjacobs\Desktop\CustomerDatabase\Quote.xls", ReadOnly:=True
thanks
i have tried what you have suggested still with no luck i have done everything as explained when i have the excel file open first then open the database i can view both but as soon as i want to edit the excel i'm met with an error "the file is locked" the code you suggested to use only gives me...
How can i do this? I have posted this on a forum and nobody seems to be able to help me! I am able to view the excel file through the database but when the database is running i am unable to open the excel file using a command button or going directly to the file and opening it there i get the...
I have already created my bound object so i can see the excel file, this is not the problem the problem lies when i try to open the excel file from its original location (whilst the database is running)
- trying to open the excel file gives me the error: "Cannot access excel file.xls". I get...
hi apr i have tried what you have suggested this only allowed me to open excel. What i am trying to achieve is to be able to open the specific file but as i am already running the excel file within my database it does not allow me to do this so i am lookinf for a way around this. i thought...
Can you add a new user and give this user all admin rights - make sure you change this user to owner as well.
- Tools - Security - User groups and permissions - Change owner tab.
Hope this helps