Saveas from cell reference in specific folder

Hi All,

I am no expert on vb code and usually get by by pasting chunks of code from forums and tutorials etc.

The first part of my macro, for information/ context is as follows:

A .csv data file is opened and a macro started, which does the following:

• Open a template .xlsx file (which is read only to preserve its integrity)
• Copy 2 columns from the .csv file into a sheet on the template .xlsx file
• apply various filters required for generating a graph on a second sheet in the same .xlsx template file

The coding for the above is sorted and works well, but what I need help with is the second part, which I have been struggling to get right:
Following the above sequence, the following needs to occur:

• A "Save As" dialogue window to be brought up...
• Defaulting to a predetermined folder (say C:\folder)
• Prepopulating the filename with text from a cell reference in the active document (say A:1)
• Preselecting the file type as .xlsx

Saving must not be automatic, so that the user can revise the prepopulated file name if required, before clicking on save

Some code that I have been playing around with for this last part either saves the file as "FALSE.xlsx" or doesnt save anything at all.

I would appreciate any help anyone can offer

Lang

Thanks Jerry, thats awesome.

The savename and the user abort message work beautifully, but for some reason its not defaulting to the specified folder. I have tried different folder names etc and still to no avail.

I dont know if any of these environments would be causing the problem...

• Running Excel 2007/2010
• Running it in the personal macro

I would appreciate any further advice you can give.

Thanks again!
Lang