shared file

Hi all We have a shared Excel file in a Teams channel. Everyone has the channel set as a Onedrive shortcut too, so it creates a daily backup of itself on the first opening each day using a Workbook_Open script. This script also sets a temporary view so people don't mess up what each other is...

I have an excel file that I use to update daily schedules. The code is fairly simple yet has intermittent faults due to an unknown reason. The code below opens a file( on teams), updates links and then closes the file, the fault is, sometimes the file will open and close but not update the...

Hi All, My team use a shared, macro-enabled (.xlsm) workbook, with roughly 25 users in it at the same time, 24 hours a day. Over a few days, the shared user list gets full up, sometimes people's entries appear in there 4 or 5 times each. This causes the workbook to get bogged down which...

I'm getting runtime error 1004 because someone else has a shared file open. When I open the file manually, it asks if I want to open it read only. But when VBA opens the file, it says Someone else is using the file. Please try again later. Then I get the 1004 error when I return to VBA. Why...

Hi There, I have a problem that I'm sure many folks have encountered. Our office utilizes a shared drive to access documents. It has its pros and cons, but we've recently run into a problem. There is a coworker who keeps forgetting to close an important excel document that is often used by...

With this code : Sub TEST() Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet Set xlApp = New Excel.Application xlApp.Visible = False Set xlBook = xlApp.Workbooks.Open( "C:\temp\pippo.xls" ) Stop xlBook.Close SAVECHANGES:=False Set xlSheet =...

Morning friends! We have a shared excel workbook that has charts with text boxes. The problem is, the chart sizes change from computer to computer. For example, if I open the file, all of the charts are sized to 6.4 X 9.8; another user can ope the exact same file and the charts are 7.1 X...

Hello, I'm working on shared files I created for multiple people to access on multiple computers (same type of computer, same excel 2016 software). It was working fine with the group I tested on, but as more people tried to use it, They’re getting an error that there is a problem within a...

Hi I have a workbook that contains VBA and works fine as "exclusive only". The moment it is shared I get "Object Required" error when the workbook opens. here's my code, however it is basically just filtering and copy/pasting. Any help would be greatly appreciated. Private Sub...

Hi all, I'm so excited to have joined Mr. Excel and this will be my first post! I'm very basic with VBA but want to learn so much more. I think I missed my calling not becoming a computer programmer, but accounting it is for now! In my company we have the weirdest month end calendar and I...

Hi, Can someone assit me by looking over my code below or alternativly at my workbook & make any suggestions as to why it won't execute when the file is shared? This is my first attempt at VBA & I'm stumped! It is part of a 'Scan in / Out' time capture workbook that I've written up. Reason is...

I have a shared file that intake workers are constantly updating with admissions. Yesterday someone inadvertently deleted the file. Since someone had the file open, I was able to save the file, however, to be proactive, I'd like to make the file undelatable. Is there a way to make a shared...

Can someone please help me with my issue before I'm going nuts:confused: I have 6 employies that have their own workbook shared with onedrum.com and me. I have a workbook that shall get their workhours synched with my workbook, and at the same time synch back to their workbook. This is...

Hi everybody, I am having an issue when opening (not downloading) my file from the website version of my company's email server, or from my company's actual corporate server itself. When I open the file, the private sub macros work. Any macros that are stored within the workbook or modules...

I have an Excel document saved in a shared folder on our server. I usually always have this document open and everyone else can open it as read only to view the information they need. This document will not open on one persons computer while I have it open on my computer. The prompt to open...

Hi, please see the details below: Background: Excel 2007 Shared workbook with Autofilter and Frozen Panes. Issue: When a user filters the information and then saves the file, excel changes the frozen panes automatically depending on the filtering used (yes, it does it by itself) even when the...