I can't import my own spreadsheet, says I don't have permission(?.

B

BluzDude

I am trying to create a macro to import data from an Excel spreadsheet that I
created. When I run the macro I get a message that says that the spreadsheet
is either already open by another user or I don't have permission. I created
the spreadsheet myself on my own personal computer. Why will Access not let
me import that data?
 
J

JohnK

Do you have the spreadsheet open when you are trying to import? If so, you
will get the message you described.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Dealing with a Pivot Table (when I don't want to) 0
You don't currently have permission to access this folder 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Need Help Creating a Word Template using Excel 1
Create timeline with event being hyperlinks to documents on drive 1
Permission in Outlook 0

Top