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