permission

Anyone know how to clear this issue. I get this message with any query I run associated with this table and can't find this table anywhere now. I no longer see tt in my relationship either. I tried deleting my import table and rebuild it but, I can't do that either. RAW_NJUNS is the name of my...

I have my spreadsheet set up so on Sheet2 there are 2 columns of titles and the 3rd column is an empty cell. Next to this empty cell is a button that the user can click, a file browser opens up, and they can choose an image. Selecting an image will insert the file path into the cell and insert...

Hello, I'm trying to duplicate and save my active workbook but for some reasons, the following error is popping up during the macro execution; "Permission denied - Run time error 70". I tried to browse around but i still cannot find where I made the mistake in the coding. Any help would be...

Hi There I work at a large hospital and we have an issue with our door access system in regards to cards having duplicate doors placed on cards and this is causing some not to work. I have attached a sample which shows the cards with their contents. I need to reference each cards contents to a...

This line of code sometimes results in a "permission denied", but other times it works fine. UserForm5.ListBox1 = arrayOutput Seeking help/ideas/suggestions

Hello, May somebody help me how to tabulate with a formula the following information please. <tbody>#CACACA [/URL] "] A B #CACACA [/URL] , align: center"]1 STAGE 1 #CACACA [/URL] , align: center"]2 ID 0 #CACACA [/URL] , align: center"]3 NAME JFMSC #CACACA [/URL] , align: center"]4...

Hello, Does anyone have any idea why this line of VBA: ThisWorkbook.Theme.ThemeColorScheme.Save ("C:\myThemeColorScheme.xml") works fine for me, the person that created the workbook, theme and macro but throws up a 'Permission Denied' error for anyone else?

I'm analysing some system role based permissions, to understand and display which users have access to which permissions and perform a comparison. The way the data has been presented to me so far is such that I have one table that presents permissions mapped into groups permission profiles...

Hi All, I have several source xlsx. files saved on the drive (offline) and on the sharepoint. I am able to refresh the powerpivot via "existing connections" except for 1 file (see error message below). I have full control permission. The file is not in use by anyone else. I have re-loaded...

Hi everyone, so I have a workbook for my tenants when they pay their rent. I've created a template and have been using this method for a few years now. Today I try to make an entry and save it but when I clicked on File, two highlights came up. One said the workbook sheets are protected...

Hello, Me and my colleagues have several workbooks in a shared environment (Druva in sync). We have some problems with conflict / duplicates files that are generated when more than one user open the same file and edit it. I'm aware that there are some vba solutions for this issue. However...

Hey everyone, I am a new user on Excel and I have been using tutorial succesfully so far, however im stuck with a problem. I needed drop box for a project so I used activex dropbox and needed the value of the drop box in a cell so i used range ("A1") = me.combobox1.value. Everything worked so...

I am looking in a VBA project I've downloaded and have found following code SQL = "BEGIN budget_p.upload_from_excel(" & ... & "); END;" I've looked through the entire project for the names "budget_p" and "upload_from_excel", but can't find anything. The project is helping me update and...

Hi, I've set up a sharing workbook but have a problem with permission. I want it to effectively 'lock' the input for users after they 'submit' their data. The specific user cells have been made accessible using Allow Edit Ranges in protected worksheets. Accordingly I'm wondering if there's...