I'm working on an Access 2010 Data Bank where I have a Macro instruction to export one of its Tables to MS Excel. Instruction is as follows:
Export with Formatting
Type of Object: Table
Name of Object: SorteadasPorDataBlank (table to be exported)
Output Format: Excel Worksheet
Output File: C:\users\Cassio2\Documentos\Lotofacil\ResultadosPo rData.xlsx (spreadsheed destination)
When this instruction is executed I receive an error message with the following contents:
Microsoft Access couldn't save the output file to the file you've selected
Among the 5 possible causes, there is only one that may be the cause of the problem: "Check if you have permission to save on the specified folder" All other 4 causes were verified, and couldn't be the cause for the problem.
I'm working under Windows 7 -32 bit and my profile is Adminiistrator, which I imagine, should allow me to save anywhere.
Does anybody have an idea of what could be preventing me from saving my file on the indicated folder?
Please, help.
Thank you ,
Cassio