Hello
I have a strange issue occurring on one computer and not the other. In Excel 2007 I have a xlsm file copying data from Sheet1, pasting it to Sheet2 and then saving as a CSV.
The goal here is to create a new file in CSV format with only the contents of Sheet2.
Everything works fine on my PC. On a customers PC he does not receive an error but the file is empty. So in other words he had a file in the correct directory with the correct file name but the records are not present. There is no data. If you open it in notepad there is nothing to be seen.
Can anyone think where to start troubleshooting this problem? Like I said there is no error. I personally checked the Trust Center settings and all directories involved have the green light. Is there some macro security setting that would disallow the content from being placed in the file?
Thanks for any help
I have a strange issue occurring on one computer and not the other. In Excel 2007 I have a xlsm file copying data from Sheet1, pasting it to Sheet2 and then saving as a CSV.
The goal here is to create a new file in CSV format with only the contents of Sheet2.
Everything works fine on my PC. On a customers PC he does not receive an error but the file is empty. So in other words he had a file in the correct directory with the correct file name but the records are not present. There is no data. If you open it in notepad there is nothing to be seen.
Can anyone think where to start troubleshooting this problem? Like I said there is no error. I personally checked the Trust Center settings and all directories involved have the green light. Is there some macro security setting that would disallow the content from being placed in the file?
Thanks for any help
