permission denied

This is Listbox Loading when Form Initiate: Sub LoadDataList() On Error Resume Next Dim oLastRow As Long Dim oMatchFoundIndex As Long Dim oCounter As Long With oCurrentSheet oLastRow = .Range("A65000").End(xlUp).Row lstData.RowSource = .Range("A3:B" &...

Hey Everyone, Thank you for taking the time to read this, I am currently a novice VBA programmer beginning to learn the basics of visual basics. I had been trying to design a program to view/download current tax forms for client viewing. The program as designed is supposed to visit a page and...

I need to be able to automate data scraping of property assessment data for work, and I keep getting Error 70: Permission Denied. The weird thing is that for testing purposes, I left IE visible and the page navigates correctly, but the debug error stops a process that seems to be working. I...

Hi there Excel Masters, My file contains a function to Delete & replace itself for its latest version. This function can be accessed by a button on one of the sheets; or everytime I open the workbook. This function works perfectly if I trigger it from the button on the sheets, but if it is...

Dear All, I turn to you, because i ran into some troubles. I want to get the value from certain cell and put it into listbox. Here is the code i am using I get permission denied when the for cycle starts. If i have the values of the cells in the same sheet everything works great. Private Sub...

I have a questionnaire that has a few hundred checkboxes (not ActiveX checkboxes) that users complete as a part of our quality control process. Depending on the nature of the job different boxes need to be available, so each checkbox has been named according to when it is to be displayed. An...