Error 55 File already open

E

Eric Marple

I have written a function that opens a .txt for OutPut
and it opens a separate .txt for InPut. I get a Run-Time
error 55. I see the help says you can't have the same you
must close a file opened for Input before opening it for
Output. Both .txt's have different names and paths. Does
anybody know a way around this?
 
T

Tushar Mehta

Maybe, if you shared the code that causes the problem...

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Auto Open Macro of external .txt file based on cell reference 1
VB6 Open Run-Time Error 55 1
Error outlook.com 0xc0000005 trying to open custom controls 0
Error 55 File Already Open 2
Word 2016 opening sooo slow 0
Problems created by Recent updates to Outlook 365 0
Project 2010 "Project has stopped working" error when attempting to import from Excel 0

Top