EXPORT does not work in some pc's

[rsampathy]

Hi,

I have below EXPORT command in Access VBA code, it does not work in some PC'S (Access 2007).

COMMAND:
.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryExporter", strFileName, True, "Data"

While generating report, it will appear loading box then it will disappear.
It will not generate excel sheet.

Any suggestions please.

Kind Regards,
Sam.

 

[Guus2005]

Assuming:
- You used the complete command:
Docmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryExporter", strFileName, True, "Data" ?
- qryExporter actually produces records?
- strFileName is NOT read-only
- strFilename exists and sheetname Data exists?

If all assumptions are met, you won't have a problem.

HTH

 

[rsampathy]

Thank you.

This command works in my PC but not in user PC.

In problametic PC - Even it will not open dialog box of dlgSaveAs.show.


With dlgSaveAs
.AllowMultiSelect = False
.InitialFileName = "\\Fmgdata3\data03\GlobalCorporate\Magnum\Reports\Exported Data\Export_" & Format(Now, "yymmddhhnnss") & ".xls"

.InitialView = msoFileDialogViewDetails
.Show

strFileName = .SelectedItems(.SelectedItems.Count)
End With

 

[vbaInet]

It could be something to do with your references. I think the library you may want to check up is "Microsoft Windows Common Controls"

 

[Avelino]

Hi

The office 2007 was upgraded to Service Pack 2 ?