98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Saving an open workbook
Saving an open workbook
Resolved · Low Priority · Version Standard
Mon 18 Feb 2008, 14:01Delegate Shehnaz said...
Shehnaz has attended:
Excel VBA Intro Intermediate course
Saving an open workbook
Hi
I wish to save a selected file as a temp file. I need the user to enter the name of the temp file.
KH07Data = Application.GetOpenFilename(Filefilter:="csv files (*.csv*), *.csv*", Title:="Please select the KH07 Workbook you wish to use")
Workbooks.Open KH07Data
KH07Temp = Application.GetSaveAsFilename(Filefilter:="Excel files (*.xls*), *.xls*", Title:="Please enter the name of the Temporary KH07 workbook")
How do i save the file names KH07Data to KH07Temp?
Shehnaz
Thu 21 Feb 2008, 09:49Delegate Shehnaz said...
RE: Saving an open workbook
I need to clarify the question.
I want to open a .csv file and save it as an excel file.
I have managed to open the csv file and get a request from the user for the new file name. I have also been able to save the new file name and work on it.
However, it does not seem to saving it as an excel file.
I realised this after i added another sheet and tried to save the file.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:New to Excel 2010 - Sparklines!Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting. |
