Search results

I have copied the functions from the user guide to save a secure work, but it won’t create the .xlsc or .dat file. It doesn’t error out, either. I added a msgbox to let me know if an jumps down to the err: label. I’m using the pathtofile function as well to create the full filename string. I’ve...

I have a macro that will copy a sheet and then save it as a CSV format. It uses the Application.GetSaveAsFilename to get the location and file name, then I use the With Activeworkbook .saveas to save the file. It does save the file just fine in the compiled version, but after it save the file...