workbook access

I have 2 excel workbooks, “Main”, and “Counter”. I need to pull data from a cell from a sheet in “Counter” and enter it into a cell in workbook “Main”. Workbook “Main” is recreated from a Template each month and renamed “[this Month],[This Year] ie: “Jun22 “. There is a cell in Main that...

I have written a code that looks for specific data in a different workbook, but the issue that I am having now is that it won't look through other open instances of excel, which is driving me crazy! If anybody has any insights in how to make excel look into ALL open instances of excel I would...

Hello, I have a protected workbook that contains a hidden and protected sheet. I want to restrict all access to this sheet for the user of the spreadsheet. The problem I am running into is this: the user can simply link to the cells in the hidden sheet from a different workbook. This...

Hi, I have one Workbook with Multiple sheets, and I want to protect every sheet with Password so other can not even view the data of that sheet.For e.x. I have sheet A, B, and C in my workbook, which I am going to give to person P1, P2, and P3. All three has their own password for their relative...

Is there an easy way to time-Limit password protection of a Workbook? The obvious option is to write VB code that Auto-executes and causes the password to change after a specified period. Are there alternative ways to accomplish the objective?

Hi, I have been working on a macro to read the file names and last modified dates for a bunch of files and organize it into a worksheet. Now, I need to access and read/write data from another excel workbook. I will specifically be reading rows of data and save it in arrays in VBA and then edit...