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