Check if file exists from same folder spreadsheet was opened

**TimmerSuds** · 08-07-2016, 11:32 AM

I have a spreadsheet that may be opened from different folders.

Is it possible to create a macro to see if a file exists in the same folder that the spreadsheet was opened from?

Thanks

**Mumps1** · 08-07-2016, 01:37 PM

Try this macro:

Please Login or Register  to view this content.

Replace "Book4.xlsx" with the name of the file you want to check.

**TimmerSuds** · 08-07-2016, 07:10 PM

I've been unable to get this to recognize my file (Inventory.xls) located in the directory the spreadsheet was opened from.

Thanks

**jolivanes** · 08-07-2016, 10:03 PM

Just tried it and the code works like it should.
Did you type in the name exactly as is? No extra spaces, capital letters etc

**gaixixon** · 08-07-2016, 10:12 PM

Please Login or Register  to view this content.

**TimmerSuds** · 08-08-2016, 04:37 AM

I was able to get this to work:

Please Login or Register  to view this content.

Thanks for your help!

Check if file exists from same folder spreadsheet was opened

LinkBack

Thread Tools

Rate This Thread

Display

Check if file exists from same folder spreadsheet was opened

Re: Check if file exists from same folder spreadsheet was opened

Re: Check if file exists from same folder spreadsheet was opened

Re: Check if file exists from same folder spreadsheet was opened

Re: Check if file exists from same folder spreadsheet was opened

Re: Check if file exists from same folder spreadsheet was opened

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Check if folder exists, Create if Not

Check if Folder exists

Check if a mailbox folder exists

Check if folder exists, if not create it

Check if folder exists, if yes just copy sheet in to folder?

[SOLVED] How to check if a file exists in an ftp folder

how to check if folder exists

Bookmarks

Bookmarks

Posting Permissions