excelvbapermissionsfile-permissionsreadfile
problem with open a .xlxs file, someone else is using it
i have a problem when i try to open a file .xlxs in a public disk P: with VBA Code. The file show me a message "please try again later - ERROR 1004". Many user use this file and this error is frequently usual. There is a solution for this ?
I think in copy the file and paste to my desktop but that is a lot of wasted time because is a large file.
Workbooks.Open filename:=nameofmyfile, Notify:=True, ReadOnly:=True
Solution
Try below and let us know if it works.
Use shared workbooks with different versions of Excel
https://learn.microsoft.com/en-us/office/troubleshoot/excel/use-shared-workbook
- Excel number format to only show decimals when necessary
- Private Sub for hiding worksheets based on cell value "View" / "Hidden"
- Power Query Filtered Rows based on value
- EDI translator to excel
- If formula (the sum is less than 30 then roundup tp 30)
- Unable to use a dynamic named range as a data series - what am I doing wrong?
- How to get the path of current worksheet in VBA?
- vba + copy sheet from one wb to another wb
- Is it still not possible to open Excel from a Word Add-In?
- Excel-365 functions don't work as expected
- Sum values based on three criteria and transpose result from tabular to visual layout
- How to use fraction string in Excel/Calc/Sheets as formula
- VBA Code Save in Local and Upload to Sharepoint
- List Sheet Names Without Macro or Excel 4 Functions
- Delete a specific value from one column and Rename another Value in Excel using office script
- Highlight cell in first column if row contains a partial text match
- Excel - Aggregate dynamically values in a Table using array formulas (MAP, BYROW, CHOOSECOLS, TEXTJOIN, LAMBDA, FILTER, HSTACK) in a single Cell
- How to convert a FILETIME to an excel date
- VBA CountIf() loop / Countifs() loop
- How to construct Dataframe from a Excel (xls,xlsx) file in Scala Spark?
- excel filter data and remove units of measurement
- How to reference the current User\Desktop location in VBA
- Apache POI autoSizeColumn Resizes Incorrectly
- Copy cell values to another worksheet based on cell value
- Import Excel to Pandas Dataframe, but preserve order of Day/Month in dates?
- M Code(Power Query) to Remove Empty columns that runs fast
- Excel Count if first character is 0 in string
- How can I send Excel range including header, in table, and email to list?
- Dropdown Lists Emptying When Filling Data in Worksheet
- Excel: How to take a weighted average where blank values cause proportional weighting shifts