error 1004 in excel2019

Question

i try'd
workbooks.open "G:\path\file.xlsx"
and also without the path

but i get error 1004 whatever i try

Answer 1

The error usually occurs in Excel if

1. Any formula tries to access a column or range that does not exist in the sheet
2. Any VBA code tries to access a range that is out of range

Hope that helps.

Answer 2

Hi! @Leo 1954

●Is the file name specified correctly?
・ Path full address
・ File name
・ Extension .xlsm or .xlsm?

●may need a plug-in?
Introducing the Google Drive plug-in for Microsoft Office
https://drive.googleblog.com/2015/07/google-drive-plug-in-for-office.html

Hope its helps.

Answer 3

@Leo 1954

How do you open the file? Do you use VBA macro to open it?
If yes, we are responsible for general issues about Office desktop applications.
Since your issue is related to VBA macro which is out of our scope of support. I would change the tag to be “not-supported”.
To better help you, I would suggest you to post your issue on the Excel for Developers forum.
If you have any updates, you could also share the solution on this thread.

If no, double-click the Excel application to see if there are any errors.

Thanks for your understanding.

Regards,
Erin

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.