Solved

other users unable to open saved file

Posted on 2014-01-09
2
260 Views
Last Modified: 2014-01-09
Hi Expert's excel 2007

I am saving a file using vba code
WbkName = Left(ActiveWorkbook.Name, InStrRev(ActiveWorkbook.Name, ".") - 1) ActiveWorkbook.SaveAs Filename:="\\jjjdje.com\file2\" & WbkName & "_" & Format(Date, "dd mmm yy") & ".xslm

However, once the file saves other users are unable to open the file because you are asked to select a programme to open the file with...and also the excel icon when you save a file from the save as option is different. ..
0
Comment
Question by:route217
2 Comments
 
LVL 13

Accepted Solution

by:
Nick Denny earned 500 total points
ID: 39768393
You've ended with xslm and should be xlsm
0
 

Author Comment

by:route217
ID: 39768421
Thanks doh doh doh again on my part. ..

excellent heads up
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question