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
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.
