Problem for file extension

**Chandria** · 09-05-2017, 04:27 AM

Hi everyone,

I have a problem for the "Left" code anyone help me to fix this code.

Thanks,

Please Login or Register  to view this content.

**kev_** · 09-05-2017, 06:39 AM

What is your problem? The code works

Extension = Left(ThisWorkbook.Name, Len(ThisWorkbook.Name) - 4) & " Backup"

If workbook name is "thisFile.xlsm" then Extension = "thisFile."

What should the value of Extension be?

**Chandria** · 09-05-2017, 08:28 PM

Hi Kev_
I want like this "name of workbook & backup"
if i close the workbook the error show
I hope you understand

sample1.jpg
Thanks for the help.

**YasserKhalil** · 09-06-2017, 02:07 AM

Hello
Untitled.png

**Chandria** · 09-06-2017, 02:56 AM

Thank You very much YasserKhalil you solve my problem.

**YasserKhalil** · 09-06-2017, 06:24 AM

You're welcome. Glad I can offer some help

**kev_** · 09-06-2017, 06:32 AM

'I want like this "name of workbook & backup"

Try this method:

Please Login or Register  to view this content.

or as one line:

Please Login or Register  to view this content.

**Chandria** · 09-06-2017, 07:42 PM

Thanks you Kev_ i try your suggestion.

Problem for file extension

LinkBack

Thread Tools

Rate This Thread

Display

Problem for file extension

Re: Problem for file extension

Re: Problem for file extension

Re: Problem for file extension

Re: Problem for file extension

Re: Problem for file extension

Re: Problem for file extension

Re: Problem for file extension

Thread Information

Users Browsing this Thread

Similar Threads

Macro to open a list of spreadsheet and save them under file extension xlsx file

File name + Directory Path too long.......saves file without extension..........

Excel cannot open the file '(filename)'.xlsx' because the file format or file extension is

[SOLVED] Opening .xls in 2010 Error: file is in a different file format than its extension indicate

problem changing file extension on backp

removed file extension by accident, file opens as gibberish now

[SOLVED] Additional file with no extension created during File Save As proc

Bookmarks

Bookmarks

Posting Permissions