Bosna i Hercegovina



#1 28.03.2018-16:23
nevsad Offline
Clan
Registrovan/a od: 01.09.2010-14:40
Komentari: 187


Subject: export u excel
sintaksa koju koristim u 2003 radi

1.DoCmd.TransferSpreadsheet acExport, 8, "tbl234", "c:\izvjestaj\234.xls", False, ""

ali sintaksa
2.DoCmd.TransferSpreadsheet acExport, 8, "tbl234", "c:\izvjestaj\234.xls", False,"A2:F2"
ne radi

naime treba mi prazan prvi red od A1:F1
kad uzmem sintaksu br 2 javi mi gresku da nemoze naci objekat

ako ko ima ideju bit cu zahvalan
↑  ↓

#2 28.03.2018-21:47
nevsad Offline
Clan
Registrovan/a od: 01.09.2010-14:40
Komentari: 187


Subject: Re: export u excel
treba biti
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "tbl234", "C:\Izvjestaj\234.xls", False, "A2:AF65000"

i onda radi
↑  ↓

#3 30.03.2018-09:07
zxz Offline
Administrator
Registrovan/a od: 03.02.2009-16:22
Komentari: 9,793


Subject: Re: export u excel
I jeli ovo gotovo sad ili treba jos nesto.
Pozdrav
↑  ↓

#4 30.03.2018-23:46
nevsad Offline
Clan
Registrovan/a od: 01.09.2010-14:40
Komentari: 187


Subject: Re: export u excel
gotovo
fino hvala
↑  ↓

Stranice (1): 1


All times are GMT +01:00. Current time: 15.11.2018-09:07.