Pomoc oko automatizacije u Excel-u

Pomoc oko automatizacije u Excel-u

offline
  • FOX028 
  • Novi MyCity građanin
  • Pridružio: 06 Maj 2010
  • Poruke: 2

kada iz nekog Excel dokumenta preko VBA cod-a u vec postojeci Excel dokument upisem podatke i sinimim ga, kada ga ponovo otvorim otvara mi se samo aplikacija bez radne povrsine. U VBA sam vec podesio References.


Sub Primer()
Dim objExcel As New Excel.Workbook
Set objExcel = GetObject("C:\Primer.xls")
objExcel.Application.Visible = True

objExcel.Application.Sheets(1).Cells(1, 1) = 25

objExcel.Save
objExcel.Close
End Sub



Registruj se da bi učestvovao u diskusiji. Registrovanim korisnicima se NE prikazuju reklame unutar poruka.
offline
  • majaWL 
  • Novi MyCity građanin
  • Pridružio: 05 Jun 2010
  • Poruke: 2

Probaj umesto

objExcel.Application.Sheets(1).Cells(1, 1) = 25

objExcel.Application.Sheets(1).Cells(1, 1).Value = 25

ili jos bolje

ActiveSheet.Range("A1").Value = 25



Ko je trenutno na forumu
 

Ukupno su 1432 korisnika na forumu :: 269 registrovanih, 14 sakrivenih i 1149 gosta   ::   [ Administrator ] [ Supermoderator ] [ Moderator ] :: Detaljnije

Najviše korisnika na forumu ikad bilo je 15694 - dana 01 Feb 2026 12:23

Korisnici koji su trenutno na forumu:
Korisnici trenutno na forumu: -Max-, A.R.Chafee.Jr., advokat84, airliners, alberto, aleph_one, Alexandar-1973, Alojzije, ArchaBasha, ArmFPGA, Aska, Asparagus, Asteker, awathorn, babaroga, Bane san, Batko.VD.65, Battlehammer, BB, Bbbggg1979, Belac91, Beria, Betta, Bgd123, blejač, Bojan85, Boroš, bounty hunters, BOXRR, brandža84, BraneS, BrcakRS, brkan1, brufen, Bubili, Burovnyak, CCCP, cekic, cemix, Chainsaw, CHARLIE JA., cifra, Coficab, Colt D, CORDEIRO, CraniumWhite, CrazyDiablo, crazydkure, Czrweni, DaliborVukadinovic, dane007, Dare, Dd41d41, Dejan_vw, dejandr, dekan.m, deki1001, delboy, Despot1, dexteroza, Dimitrije Paunovic, Dimitrise93, djonsule, DJUNTA, djuradj, Djuza, domacinivan, DonRumataEstorski, Draganeli, draganl, dragisa dragisa, Drugsparrow, Duce, dulleo, dusan.l, Džekson, Electron, fokac, GH69, Giro77, gobrad, Goran 0000, Goran_, grunff2, GUARIN, Hans Gajger, Hardenberg, hatman, Holy Saber, HrcAk47, hyla, Igritelj, Imperator_Aleksandr_lll, istina, Ivan Gajic, ivan1973, Jaksa loznica, jeen yuhs, JK, Joco Skljoco, jon istvan, JOntra, Još malo pa deda, Kajzer Soze, Kamov, Kapetan993, kaput21, Karla, kibihrchak, kihot, Kobrim, Koca Popovic, Koce, koliko, Komanca, Komentator, komsija1, koom0001, Koser, Kubovac, kunktator, kybonacci, lacko, laganini123, Laske, Lazur_01, leptirleptir, livada123, ljubo70, Ljusa, loon123, LostInSpaceandTime, Lucije Kvint, luka35, Luke Pathfinder, Malahit, Manjane, MarijaC84, marko.markovic, markolopin, mercedesamg, MidnighT_AlieN, Mig 29, Milan A. Nikolic, Miletić Zoran, milivoje_vatrogasac, Millennium, Milo97, MilosKop, Milovan Dinic, mir juzni, Mićko, mladen.zovko, Moldovan, mrm, Naum T, Ne doznajem se u oružje, neko iz mase, nevjerna beba, niksa517, Njubara, Nmr, NNPD, Nobunaga, Nomica, ObicanUser, obsc, oldtimer, Orc, orfanel, Oscar, Otto Grunf, paja69, paladin71, Panta1992, pavle_pzs, pein, Pekman, peradetlić, Perudin_92, Petar888, Pewac21, Podljub, Poof, Posmatrac77OKB, Povratak1912, Prečanin30, promajauglavi, raf87, RajkoB, rambod, raptorsi, Ray1973, rebcooil, redstar72, Remain, repac, Resnica, Rok A Bit, Rothmans, royst33, samocitam, saputnik plavetnila, Sase, Seeker, Semberija, septembar, shlauf, singa, Sir Budimir, Sitan_Lopov, skylab1111, SlaKoj, sluga, Smiljkovich, snikolic, SOM, Sone1983, sosko, sspp, stalja, stefan95, stegonosa, steksi, stevo svinja, Stoilkovic, styg, T55, Tajpan, tamno.nebo, Tandrkalo, TheDictator, Tila Painen, Timočka Divizija, tm, tomo2, tooooom, Tragač, Tumansky, urosbg, US_Rank_0, Valter071, vargas, VaRvArI 85, Veless, veljkovicdani, Veljko™, Vitomir, vjetar, vladaa012, Vojkan Petrovic, Volkhov-M, Vujkeu, vukan0799, vukovi, W123, wizzardone, x011, Zec, zemljanin, ZetaMan, zexon, zil10, zmajbre, zmajognjeniivan, Zoca, Zvone, |_MeD_|, šumar bk2