$$Excel-Macros$$ Saving Files - Replacing existing files - "Yes to All"

2009-12-15 Thread Sing
Hello, I have an excel program that creates 6 different tabs and then attempts to save these different tabs as files in a specified folder. If the program has already run and the files already exist in this folder, excel says "A file named 'D:\Spectra Files\SLB-H.SPC' already exists in this locati

$$Excel-Macros$$ Insert FilePath into cell

2009-12-10 Thread Sing
Hey, does anyone know how to get a macro to insert a folder path into a cell? I'm not talking about the whole filepath like in using dim x as string s = application.getopenfilename I need only a folder, as I am then going to access that cell to determine where to save a bunch of files later on i