Prikazi cijelu temu
28.02.2017 15:21
28.02.2017 15:21
Predmet:Re: Export querie access u excel, VBA kod
Pokušao sa ovim, ali šalje mi poruku o greški "3274"
Private Sub Private_Sub_CmdTrns_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qrySveKnjige", "C:\Documents and Settings\User\Desktop\MySpreadsheet.xls", , "Sheet2"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qrySviCitaoci", "C:\Documents and Settings\User\Desktop\MySpreadsheet.xls", , "Sheet3"
End Sub
Prilozi:
Pokušao sa ovim, ali šalje mi poruku o greški "3274"
Private Sub Private_Sub_CmdTrns_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qrySveKnjige", "C:\Documents and Settings\User\Desktop\MySpreadsheet.xls", , "Sheet2"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qrySviCitaoci", "C:\Documents and Settings\User\Desktop\MySpreadsheet.xls", , "Sheet3"
End Sub
Prilozi:
poruka.JPG
Preuzimanja:336
Velicina datoteke:11.59 KB
Preuzimanja:336
Velicina datoteke:11.59 KB
Pozdrav!
Ovaj post je ureden 1
puta. Posljednja izmjena 28.02.2017 15:25 od strane Dado.