Jump to content

Search the Community

Showing results for tags 'vba'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • LTT Official
    • LTT Releases
    • Forum Information
    • WHALE LAN
    • LMG Sponsor Discussion
    • LTTStore.com Merch
  • The Hub
    • General Discussion
    • Tech News
    • Off Topic
  • The Workbench
    • New Builds and Planning
    • Troubleshooting
  • Computer Hardware
    • Graphics Cards
    • CPUs, Motherboards, and Memory
    • Power Supplies
    • Cooling
    • Cases and Mods
    • Peripherals
    • Audio
    • Storage Devices
    • Displays
    • Networking
    • Servers, NAS, and Home Lab
  • Software
    • Operating Systems
    • Programs, Apps and Websites
    • Programming
  • Video Games
    • PC Gaming
    • Mobile Gaming
    • Console Gaming
    • Looking For Group
  • Consumer Electronics
    • Laptops and Pre-Built Systems
    • Phones and Tablets
    • Home Theater Equipment
    • Photography and Videography
    • Hobby Electronics
  • Community
    • Folding@home, Boinc, and Coin Mining
    • Build Logs
    • Member Reviews
    • Guides and Tutorials
    • Hot Deals

Blogs

  • Growing up. An Aussie Thechy
  • Bleedman0xx's Den of Experimentation
  • Day by day life goes on...
  • Megadarkwood's Blog
  • Ssoele's Blog
  • Forum talk with Lil Chillbil
  • wng_kingsley7's Blog
  • [Game Dev Log] Unnamed FPS
  • Konker777's_Blog
  • IdeaStormer's Blog
  • gastew15's Blog
  • LoGiCalDrm's Thoughts
  • ericlee30's Blog
  • A day in the life of brownninja97
  • Slayr's room
  • looney's Blog
  • ASSASSIN's outpost
  • Bluejay0's Nest
  • EpicGeekonFire's Blog
  • rianjp16's PC parts list
  • TheSLSAMG's Garage
  • nsyedhasan's search for jiggabeets
  • TEC Blogs
  • Why i love / hate web development
  • Steam Controller
  • Vitalius' Blog
  • Wpirobotbuilder's Blog
  • Storage Blog
  • Material which is knowingly false and/or defamatory, inaccurate, abusive, vulgar, hateful, harassing, obscene, profane, sexually
  • Whaler_99's Happy Fun House Blog
  • Juurus' Blog
  • SkullAbyss' Blogs
  • Tea1337's Blog
  • Flyin' Flymaster | Theatrical Rigging
  • Personal PC/Storage/Infrastructure/Network
  • The Depths of Technology
  • WinNut's Train Barn
  • Zach.No.
  • Haralds55's Blog
  • amazing life
  • I Need help fast BUDGET $2200 (including mouse, keyboard etc)
  • R9 280x
  • R9 280x
  • R9 280x
  • Osmium's fabulous page of rants and stuff!
  • Brapson's Bag of Thoughts
  • First PC build. Any Suggestions?
  • Radiators
  • Alpha17x's Blog
  • ThatGammerKid's Blog
  • seabass9990's Rant and Pondering Blog
  • Jogostar's Blog
  • Matt Robinson Tech Views
  • terere93's Blog
  • terere93's Blog
  • MyBF4pc's Blog
  • Chris7013's Blog
  • Manuel99's Blog
  • SSOB Or nothing
  • DIY NAS
  • VPN Service
  • FocusBoxHero
  • The blog which is SeriuzBuzinez
  • Jason Jamelo's Blog
  • REXOR456's Blog
  • LeeToby's Blog
  • PC Build need help on whats needed
  • sharif's Blog
  • Alex_A90's Blog
  • mettler0618's Blog
  • SpurnOfHumanity's Blog
  • Jasecore's Blog
  • JAYJAYBEE303's blog
  • bwh5816's Blog
  • crappydog1050's Blog
  • crappydog1050's Blog
  • hard decision between amd fx 9590 or intel core i7 4770k?, please no fanboy
  • New 700$ Build Need Help First Time Builder.
  • Asesino Tom's Blog
  • TRIGUND's Blog
  • Volbet's Firehouse
  • Jake Taylor's Blog
  • Old truck is new again
  • Vince_DL's Blog
  • Does it love you back?
  • rippedj's Blog
  • antoainb's Rant n' Stuff Blog
  • spider monkey's Blog
  • Ynkeeblood9's Blog
  • Check my specs!
  • It's not original, but it'll do.
  • kriege's Blog
  • EmotionalSloth's Blog
  • Polandball Comics
  • Android on x86
  • help with a motherboard
  • phoenixgamer912's Blog
  • SaleemVFX's Blog
  • kingbf4's Blog
  • R4 Build Log
  • Helios79's Blog
  • DecryptedDrive
  • DecryptedDrive_LOCAL
  • r9 280x reference card
  • LawrenceBarnes's Blog
  • SpikeyMikey21's Blog
  • wolftoy's Blog
  • Tymakz's random thoughts!
  • uli
  • Minnesota Strong's Blog
  • The AMD Radeon R7 260X
  • Needalight's Blog
  • thetitanzorg130's Blog
  • A little help here
  • need help picking a keyboard
  • aken's Blog
  • SP.2 PRODUCTORY Blog
  • Switching to Linux Permanently
  • Q Talks About...
  • Ten Year old's build
  • miku126's Blog
  • Msxander99's Blog
  • LUCIFER's Blog
  • The Rabbit Hole
  • Corsair 250d Case window dimentions
  • PoonDad's Blog
  • O_O
  • thresh41's Blog
  • DildorTheDecent's Blog
  • Minibeast's Blog
  • Nikolas' Blog
  • tenmoleyhendens' Blog
  • Pebbleberries' Blog
  • Maxwit44's Blog
  • Mr.Sommer's Blog
  • AMD's Path to Being Debt Free and Successful
  • The Dude Speaks...
  • Automatic Intelligent Rig Assembler
  • ObeseWalrus' Blog
  • AlWinwood's Technology Blog
  • JonnysWeb Blog
  • USB DRIVE VS. SSD DRIVE
  • mvitkun's Blog
  • SgtRafsta's blog bout life
  • KareemGhanameh's Blog
  • my life sucks
  • Addlinny's Games and Tech
  • zadda1's First Blog
  • Killaknight's Blog
  • estil's Blog
  • MeNotAliveHD's Blog
  • dizmo's Blog
  • TrueOgre's Blog
  • AHappyDugong's Blog
  • New build! \o/
  • MrDucco's Blog
  • vintarq's Blog
  • Canopus72
  • SwagMoney557's Blog
  • Rants
  • Custom Modding My Custom PC | Grant_gwdigi_Tech
  • Alejandro31's Blog
  • supersaltyname's Blog
  • supersaltyname's Blog
  • ASUS Maximus VII Formula ROG Z97 and Gigabyte Z97X-GAMING G1 WIFI-BK Motherboard
  • My Week with Jarvis
  • ridge1002's Blog
  • djdwosk97's Blog
  • eagertolearn
  • JIT's Gaming and All Around Tech Blog
  • saif's Blog
  • techswede's Ramblings
  • Lanoi's Track
  • Macbook Pro Retina Review Over Time
  • Enigma's Blog
  • 4980HQ Experiments
  • s00cl0se's Blog
  • NovaFlux on Computers, idiots, and how shits so damn expensive
  • -Cole-'s Blog
  • A10Tech
  • I need help for a video editing/gaming/recording processor
  • M e T r i X's Blog
  • SLI compatibility
  • Victoria277's Blog
  • GhostWindGamer's Final Ranting Place
  • Build Log Blog
  • Intel Integrated Graphics Development: Pure Speculation
  • the unknown's Blog
  • ImOnTheComputer's Blog
  • Nvidia VS AMD: AMD's Advantage
  • zadda1's Blog
  • PaulCahilig's Blog
  • I need some help
  • My new pc isn't working
  • Failures of Ubuntu: An Enthusiast's and Programmer's Perspective
  • adenoidpeak66's Blog
  • I Need To Build Budget Gaming Pc
  • My Tech World and Reviews
  • I have my list of parts to do a PC. How do you rank it?
  • The ULTIMATE Watch_Dogs Optimisation
  • LukaP's Mac G5 CaseMod
  • Its not a blog just dont know how to post
  • I need Evolve Key please message me if you have one
  • tacodemauro's Blog
  • Syntaxvgm's Blog
  • Sho's Blog
  • a day in the life of a student
  • WoW is fun and finals are coming...
  • Welcome templete
  • Banana Milk's Blog
  • Guardian 75's Blog
  • Armitage's Blog
  • i need help with steam
  • Chronicles of the LHS Computer Club
  • R_Kaplan23's Blog
  • pantsRoptional's Blog
  • •[]•-PCMC ℂaℒℒ-ℊIrℒs Ѻ7Ѻ578IѺIѺ4 _=_ Ѻ976775824Ѻ Baner-PiMpri EscOrts Service-Hinjewadi, Dehu rOad Call Girls
  • AdoreMe's Blog
  • yeasin's Blog
  • HeathcliffGR's Blog
  • JScott03's Blog
  • heartleyj's Blog
  • Razer_Intel's Blog
  • Random drivel
  • ShaunHawkwright's Blog
  • ChameleonGuy's Help
  • hillbill549's Blog
  • Help With My Gaming PC Build?
  • G E E K A Z O I D
  • Where are the GTX 970/ 980 8GB Versions?
  • panozy's Blog
  • panozy's Blog
  • Dreamo's Blog
  • Nitz's Blog
  • intel ssd upgrade BSOD
  • Amethyst Castle
  • Buttertoast's Blog
  • I need help
  • Jobo's Blog
  • littlemanbigdreams' Blog
  • heatherheidi89's Blog
  • What Inspires Me
  • geoyul's Blog
  • Lays' Blog
  • domdom116's Blog
  • what new should i get?
  • tTrReEvVnOeRl909's Blog
  • jal12795's Blog
  • The Hermit's Corner
  • Persuasion Blog For class
  • Unfinished Pieces
  • vStatic Zer0's Blog
  • Nickzoom's Blog
  • Desert_Storm_'s Blog
  • Things Nowak Says
  • kamdevvashikaranmantrasBlog
  • blackmagicspe££ Blog
  • amin.a.nakhjavani's Blog
  • DxD~'s Blog
  • Anthony's Apartment
  • U can't take my Sweg
  • eestimees50000's Blog
  • Radeon HD 7770 GHz Edition w/ 300 W power supply?
  • I blogged
  • first pc build
  • shadakak's Blog
  • SSD and hard drive config?
  • Smokey Attempts: PC On The Wall (Drawer)
  • Smokey Attempts: The Red Mod
  • Smokey's Chronicles
  • darkreaver's Blog
  • Helionet's Blog
  • Current Events and General Overviews
  • Rexibous' Blog
  • creatureofthecave's Blog
  • reRoast
  • Project Retroid
  • Good android phones
  • tterbkcots' Blog
  • mustaphaist's Blog
  • 1823alex's Blog
  • KESS_217's Blog
  • zenithar's Blog
  • Toms' rants about Esports and CS:GO
  • Brother PC Build
  • Swndlr's CSGO Skin Showroom
  • Swndlr's CSGO Skin Showroom
  • jmad2011's Blog
  • Child's Play
  • Teknoligie
  • buum's Blog
  • Brad.Neil's Blog
  • Upgrade build
  • Kendo's Blog
  • adzzkasper101's Blog
  • Kavala Checkpoint
  • Tower Builds
  • is amd still good for editing
  • † Tech Tips Christian Fellowship †
  • krishi's Blog
  • Where I post so I don't spam my statuses
  • Prastupok's Rants and Thoughts on life and computers.
  • My PC Upgrade Blog
  • zeldafan19's Blog
  • bigirishman's Blog
  • SSL's Blog
  • knkritpillw's Blog
  • knkritpillw's Blog
  • HiddenTLR's Blog
  • Steve83990's Blog
  • qwertywarrior's Blogimm not allowed on offtopic so im gonna post here
  • MustafaNL's Blog
  • Cool idea for new office/super fun time
  • Cool idea for new office/super fun time
  • help me remember
  • FloRolf's incredible Blog
  • murz's blog
  • Nvidia GTX 660 ti wanted
  • Sarbartha's Blog
  • The Mechanical Experience
  • YeahLOLNo's Casual N00b Blog
  • Le boring life of Zach
  • Biferony's Blog
  • russell dahms2's Blog
  • Slim 24 Pro India
  • prashanth13's Blog
  • madtomzxc's Blog
  • Power Supply
  • orangemonster's gaming rig
  • need help GPU not working!
  • which GPU?
  • Speedierbug's Blog
  • Building My First Gaming PC
  • BIG BIG GIVEAWAY
  • jitflexx's Blog
  • Joysontp's Blog
  • ImTamTam's Blog
  • Backfishr's Blog
  • The Great Vessel Giveaway
  • normix123's Blog
  • Backfishr's Blog
  • Vessel giveaway
  • Durairaja's Blog
  • Molivas1998's Blog
  • CriminalReaper's Blog
  • Lukas Jonneryd's Blog
  • Big Giveaway
  • SidWiz's Blog
  • SidWiz's Blog
  • SidWiz's Blog
  • SidWiz's Blog
  • Tedjej's Blog
  • Robin Tharu's Blog
  • Sam_Walker's Blog
  • Sam_Walker's Blog
  • Shark Vader's Blog
  • Craig;Strachan's Blog
  • moodyjake16's Blog
  • GamingGab's Blog
  • giveaway
  • KappasUnite's Blog
  • gary123
  • Big Giveaway!!!!!!!!!!!!
  • Mat123's Blog
  • AugustG1's Blog
  • RaymondB's Blog
  • BIg Giveway
  • TobbeDeVall's Blog
  • westlee83's Blog
  • Stefan99's Blog
  • AwakenedIssues' Blog
  • Hypros' Blog
  • epilole's Blog
  • SuperiorAnion's Blog
  • Big Give Away
  • Kasper Friis Kristensen's Blog
  • Jimmy's Blog
  • TheDrunkenBear's Blog
  • StaticZebra1's Blog
  • StaticZebra1's Blog
  • Vessel Giveaway
  • LordSquire's Blog
  • Kabeltrommel's Blog
  • blacknight642's Blog
  • golgeter100's Blog
  • Autumn_Elephant's Blog
  • Linus giveaway
  • awesomepossum's Blog
  • navjeet321's Blog
  • navjeet321's Blog
  • linus give away on vessel
  • Linus giveaway
  • Uber giveaway
  • jmotl96's Blog
  • dildo_baggins' Blog
  • Silverstar233's Blog
  • Vesselll
  • Big Giveaway
  • YourComputerGeek's Blog
  • TMLK's Blog
  • Onka's Blog
  • xtianlegaspi's Blog
  • x4biddenxgrimmx's Blog
  • Smrda123's Blog
  • GooBado's Blog
  • PandaOwl2's Blog
  • Big Giveaway
  • Veljko's Blog
  • roarreduce's Blog
  • Vessel Giveaway
  • gamingbanta 1's Blog
  • Big Giveaway :D
  • Stef's Blog
  • Big Giveaway :-))))))
  • JaylChambersIII's Blog
  • Big giveaway!
  • Big giveaway!
  • Big Giveaway
  • All good things must come to an end
  • KimSH's Blog
  • big giveaway
  • Big giveaway
  • Aetherial's Realm of Things
  • Big givaway
  • Big Givaway
  • Best Computer Cases under, $80
  • Thebman712's Blog
  • mmuller2015's Blog
  • Maxdepalma's Blog
  • fishhydra1's Blog
  • safwanroslan's Blog
  • xXINDUSRTALXx's Blog
  • Justgotdunkedandrekt's Blog
  • maad's Blog
  • NoobDude's Blog
  • my mice issues
  • duileilome's Blog
  • mahrok's Blog
  • Slick's Blog
  • levidittrich's Blog
  • Editing program For gtx 900 series
  • Ctrl's Blog
  • TheGreatMage Gaming's Blog
  • HELLFOX's Blog
  • kingston ssdnow v300 120gb not recognized on windows
  • myrddinshadows' Blog
  • Gaming PC need it at ~$650-700
  • David Jones
  • mrousavy_'s Blog
  • IGeorge Blog
  • HexGamingYT's PC Case And Motherboard Blog
  • DudleyTM's Blog
  • saadkat6666's Blog
  • Maitrik's Blog
  • dustincarlton88's Blog
  • Pugs501's Blog
  • the ongoing build battle
  • Ellie's Hella Pooter Blog
  • Question
  • aylmao.moe
  • Strando123's Blog
  • dr_deconstruct's Blog
  • IronGamart's Blog
  • KBH's Blog
  • High Performance Computing For Dummies
  • Custom PC Build Guide
  • Guys Please Help!
  • ilias_ragkousis' Blog
  • Butters_420's Blog
  • JoeStoutatl's Blog
  • zappian's Blog
  • JurunceNK's Blog
  • Procesador
  • Fx 6300 With gtx 960 or r9 280x is best
  • ThatGuyWhoTwirlsHisPen's Blog
  • Moving to the PC Master Race
  • Tf2 spycrab raffle
  • f5alcon's Blog
  • Need Help With GPU Choice
  • What should I buy for video editing?
  • NDY777's Blog
  • dragonballz's Blog
  • Agent80085's Blog
  • Tech and Gadgets Archive
  • Tex63's Blog
  • help tips and tricks
  • killerfox1977's Blog
  • CoolaxGaming's LTT life
  • tnt's insane inside
  • Best builds around $600
  • Casper The Cat
  • Where did you get this?
  • Asus 24" VG248QE or BenQ XL2411Z
  • Life of a Techie
  • G33k 4 L1F3's Blog
  • Prof.TEACHER's Blog
  • RasenShuriken's Blog
  • Bazinga's Pc?
  • My $1000 Gaming Pc Build
  • A new way to watercool a pc? And an hybrid solution!
  • please help me
  • Can this pc run gta 5 at 60fps
  • Neater123's Blog
  • noor's Blog
  • Project Zoe
  • Medieval kingpin
  • 775 Monster
  • My life as 1 of 2 PC builders in the family
  • osx maverick virtual machine
  • Izaibo's Blog
  • Tharusha's Blog
  • Maricruz8500's Blog
  • First Water Cooling Build
  • Cryless' Blog
  • realtek decide to block 7.1 software playback
  • My Bookmarks
  • Sgt.Puggsly's Blog
  • Pepijnn2's Blog
  • Used GTX 970 vs GTX 980, Which should I get?
  • Suemael's Blog
  • My first gaming PC
  • zodiac
  • Where to Buy Asus NX90?
  • Building a 600€ gaming PC
  • HanselPutra370's Blog
  • Dis is confusing
  • TheNinjaElite's Blog
  • GameCast News Weekly
  • LukaP's Blog
  • Can my PSU handle this build? (Especially my GPU)
  • PepeSilvia's 1st Build research
  • NAR31K's Blog
  • UCGAMEPC's Blog
  • gundamboy123's Blog
  • razer product problem
  • Demetria's Blog
  • Dabobminable's Blog
  • Darth Morbis (Build and Showcase)
  • Need Help!
  • Michael26's Blog
  • souviksundargh2's Blog
  • jivan's Blog
  • deavmi's Blog
  • AgentEddie99's Blog
  • Tayer's Blog
  • xps 13 vs thinkpad t450s
  • Ram Upgrate???
  • Rashy's Blog
  • kalyan chand's Blog
  • illegallybrowned's Blog
  • Kay@'s Blog
  • Frost Ninja's Blog
  • Computer Case Project
  • Looks at my suit!
  • Soham Amin's Blog
  • samsterling's Blog
  • Project Cove
  • JakobRosell's Blog
  • Deadpool9011's Blog
  • ronickz's Blog
  • tebinsta's Blog
  • ElvanOng's Blog
  • Dispelling some R9 300 series confusion
  • john lorenzo patayon's Blog
  • The Bleeding Edge
  • STRMfrmXMN's whitelist of PSUs
  • AK Angel's Blog
  • TechXero's LTT Blog
  • Random things with a raspberry pi
  • The Development of Neon
  • Zeruel's Blog
  • Multithreaded Game Template Code
  • rivalrifle's Blog
  • Pc Blog
  • Raid Zero Danger?
  • WHEA_UNCORRECTABLE_ERROR
  • A wee bit if help needed
  • Can hear but when I talk into mic my friends can hear me with the SS 9h
  • Jlryan's Blog
  • +Core ? vs Faster Core ?
  • Harryoclegg484's Blog
  • JOEJOE20's Blog
  • Tommy-b-10's Server Build
  • Lowering the voltage
  • Cockpit Creation
  • Needing a good laptop for school under about 1000 euros or under
  • Taylor borie's Blog
  • is this pc good
  • Harry Sidhu's Blog
  • Brakes on Driverless Cars
  • Rohanm's Blog
  • Recommendations for water cooling
  • Herping And Derping With Zexen
  • Keven_Z's Blog
  • Polgara's Blog
  • ToastyCircle151's Blog
  • Patzemon's Blog
  • Elllie's Pooter blog with some sparkles and custard
  • joe henigan's Blog
  • OC→JoinLinusMediaGroup's Blog
  • desired70's Blog
  • The Adventure's of soaringchicken
  • Benchmark´s R7 260X
  • baxtmann's Blog
  • Bwahhh
  • mrpepo16's Blog
  • CupOfJoe's Blog
  • Jim-B's Blog
  • Are these parts decent with each other?
  • killerson69's Blog
  • Daddy-Oh's Blog
  • abhinav95's Blog
  • enrico2001's Blog
  • Help, Want to make my first Gaming PC
  • What is the differance between a 128 bit and a 256 bit graphics card?
  • *NEED HELP* NEW GAMING RIG 2015
  • Calvin10112's Blog
  • Fx 9590 Cooling
  • budget 3D modeling advise
  • Frosteler's Blog
  • AnnieSmith's Blog
  • Help with parts and bottlenecking
  • Atarexy's Blog
  • HELP ME PLEASE!!!!
  • Please help
  • SoloGamingG1's Blog
  • kamikaze_sarg's Blog
  • HELP!
  • JBPblogging
  • AVICII_USA's Blog
  • AlexAppleTips
  • albiedam32's Blog
  • Need completely over kill pc NOWWWW!!!!
  • first gaming pc build
  • ShayanLP's Blog
  • R4 Build #2
  • RAVE
  • The Rig Build
  • Epiceleon's Blog
  • Desertman's Blog
  • 9blazed-fury9's Blog
  • Enderking's Blog
  • Romario9113's Blog
  • PC Spec help
  • alexit95's Blog
  • ZonkyHD
  • Please help me i'm building my first pc and I need good part's for 1,500
  • URGENT
  • Best 2011-v3 motherboard
  • SirMonti's Blog
  • PC Issues
  • DevTechTips' Blog
  • Which headphones
  • Lyngaa's Blog
  • Moosecoop's Blog
  • ryangunter1's Blog
  • Kanye90's Blog
  • LocalGook's Blog
  • Blackis_007's
  • ilance101's Blog
  • Olafny's Blog
  • jakecurrier33's Blog
  • Should i buy this prebuild pc?
  • tleejr5349's Blog
  • Bobert1011's Blog
  • Voltage computer systems
  • Nandit_HAF's Blog
  • Good price for selling a computer...
  • Tony Z's first pc
  • James's Blog
  • The-Furrbles' Blog
  • danny8632's Blog
  • Help me with my Stoomtrooper?
  • Need help with CPU bottleneck
  • My Dream PC
  • My Gaming Rig Review
  • Drummaboy57's Blog
  • A techy blog
  • WIDE SCREENS UHH :3
  • Nettot's Blog
  • AbdulQadeer's Blog
  • Jake's Tech Selects
  • TheSkylord2104's Blog
  • PSU Upgrade?
  • Thoughts from Sunshine1868
  • handymanshandle's Blog of Blogginess
  • one fault about amd GPUs
  • For the Noobs
  • SmittyWerbenJagerManJensen's Blog
  • Shyamrao's Blog
  • Dell Inspiron 15r (5520)
  • Raman_Kumar_Kharche's Blog
  • Raman_Kumar_Kharche's Blog
  • BlueMagma1's Blog
  • THE BEAST
  • Open looped water cooling
  • BigKahuna's Blog
  • pcman365's Blog
  • LoafMan's Blog
  • WanderingX7's Blog
  • viper123's Blog
  • GeorgeJacobIsANerd's Blog
  • GeorgeJacobIsANerd's Blog
  • A random PC thoughts blog
  • Systool Overclocking Infectious
  • PatonFTW's Blog
  • Motherboard & Case upgrade!
  • JonnySel007's Blog
  • Noob looking to upgrade
  • Scrapyard Wars Ideas
  • VintageThief's Blog
  • MangoIce's Blog
  • a2j_'s Blog
  • Kanoire's Blog
  • Toysoldiers35's Blog
  • Flappie's Blog
  • Andria's Blog
  • x_xMDFKx_x's Blog
  • Guywhoneedshelp's Blog
  • 3drenderings123's Blog
  • New pc for under 750$
  • Hackintosh Under 5000 USD
  • Sekhon's Blog
  • B4USAWME's Blog
  • Computer turns on but no display output...
  • Please Help
  • Harry__Bird's Blog
  • Noob Builder
  • Love Minecraft Blog
  • AC Router Help
  • kiwicasper's Blog
  • Sound Card suggestions?
  • New Cars Review Blog
  • SteelHaddock's Blog
  • Honda dream of life
  • Gaming Monitor
  • Using Microsoft Edge
  • AurorasDestiny's Blog
  • AIO to Dsktop plan
  • Xboxfreak's Blog
  • redlimerock's Blog
  • Choosing a UPS battery backup
  • tibosuys_'s Blog
  • Windows on a laptop?
  • Gaming/Work-Horse PC
  • B1tKru5h3r (My workstation)
  • Ultraretrotech
  • cestigoy375's Blog
  • MrNeeds2know's Blog
  • Xenift's BuildVille
  • TELL US YOUR PC SPECS
  • LTT Audio Sub Recommended Audio Gear
  • arnab_razor's Blog
  • sonic72391's Blog
  • MrUnknownEMC's Christmas Giveaway
  • shadowbyte
  • HADA's Blog
  • GSTARR
  • Vicyo's Free Time
  • Cow House
  • Star Wars Movie Review
  • SteelHaddock's Blog 2
  • New Pc Startup issue
  • WDC's Blog
  • eoinmuirhead's Blog
  • I NEED HELP!!!
  • IKNOWIMBOSS' Blog
  • zakaria jouimaa's Blog
  • Corsair K30 Raptor Lighting Effects
  • Kevin2015's Blog
  • My Random Creations
  • Making video games (or at least trying
  • Mohammadhussain's Blog
  • BigJigglyPanda's Blog
  • odinpalen1234's Blog
  • optelic2003's Blog
  • thegamingmau5's Blog
  • CrapShackGaming's Blog
  • SnipeWay's Blog
  • Ashraf_Akon's Blog
  • Nestorrd91
  • WhOaMi-Gaming's Blog
  • LegoManPilotGaming's Blog
  • GreenJesus' Blog
  • smiddy305's Blog
  • Brutalizer's Blog
  • CameronWagers' Blog
  • Should i build a pc
  • Awesome Tech Site
  • Cool Tech Sites
  • ScarisRacer's Ramblings
  • advice on my pc
  • Jakub321's Blog
  • Weekly JaKobs
  • Help me Please
  • Vietnam Visa On Arrival
  • Solidice's Blog
  • Curious
  • LankyIvan's Blog
  • chris070163's Blog
  • heggy_1's Blog
  • RandomnessSlaya's Tech Talk.
  • Cheap PC Build
  • The epic $300 Build
  • GizmoDude52's Blog
  • Jahramika's Blog
  • CPYarger IT Services
  • The Blog of An Average Tech Geek
  • PCZAVRE BLOG
  • My system automatically just run down
  • Is eSports an actual sport? I definitely think so.
  • itsMilan Creations
  • Joonikko's Blog
  • VIDEO CARDS!! (help me god)
  • Windows 7 and 10 resources and commentary
  • Team Adam
  • Learning Russian
  • Yuan
  • Opinion of my PC Build
  • a home made NAS in a desk
  • CPU Overheating on startup
  • NEED HELP
  • Lerodz8
  • Help I'm building a computer and I don't know what drivers to Insta
  • Abdul Samad
  • Should I SLI? Or upgrade?
  • Modded PCS+ 390x
  • More Case Reviews?
  • Intel Nuc with dedicated graphics
  • JXZT
  • Setups
  • Suggestions for my New Gaming PC
  • The Nubby Ninja Blog
  • A PC THAT IS WORTH $1500
  • My first build will it work
  • HELP FOR SUPPORT MAXIMUM RAM LIMIT
  • gtx 960 preforming wierd
  • Build list-best for budget!
  • iamdarkyoshi's Random Stuff
  • The Truth About Beats
  • Alex
  • no post
  • Djole123 tries to Windows 95
  • Why You Shouldn't Blame Intel For the PC Performance Slowdown
  • Display Things
  • Deals
  • KRONIKL
  • DownToEarthTechtips Blog
  • Engineering log
  • Alan's Blog
  • Yurizaki's Tech Ramblings
  • Nathaniel S. Edwards
  • i5 6600k vs i7 6700k for gtx 1060
  • FrostByte: My personal rig
  • Important tips that will help you grow your business mind
  • Lovinglasvegas
  • My sort of scratch build of an ATX case.
  • PaintChips
  • Vernon Glick's Blog
  • My Hackintosh build
  • Test Blog
  • Miscellaneous
  • Life Status Update
  • Real Game Engine Code Optimization
  • Server and Networking Blog
  • Programming: You Think It, I'll Optimize It
  • LTT/Forum App schenanigans
  • Remix's Technology Blog
  • IGPU TEST-LAPTOP | SPANISH | ENGLISH | <3
  • QA Web Testing and software testing NEWS
  • Finally upgraded GPU!
  • Spicy Italian Discord Bot
  • Build Dictionary
  • Graphics Card
  • Lyft Stories: The Wild & Sad Tales of Washington's 'Finest' Passengers
  • $1000 Builds
  • Technology: PC vs Automobile
  • It's not a bug, it's a feature!
  • My Build
  • My Linux guide
  • Tech Dreamer's Thoughts Basket
  • An admittedly silly concept for a first build
  • Iphone productivity
  • Charter Email Technical Support Helpdesk 1800-721-0104
  • What if you are unable to install third party software? Just call us on Apple Tech Support Number +1-800-468-9074.
  • AOL Customer Care Number +1-844-502-0074
  • Victor
  • Apple tech Support number
  • Miscellaneous Data Resources for Everything
  • Harinder siwach
  • Just a student's blog :)
  • PCPartPicker Build's
  • Ooooo forgot about these! :P I'ma start one!
  • webdesigntrends
  • Max's Journal
  • Slowly Upgrading an ASUS cm1730
  • Zack's Power Hour Thinking Blog
  • coqueiphone
  • Finderding
  • Streaming PC on a Budget? (Parts list/ideas request)
  • Business & Personal Related Blog
  • Tech Media
  • My life is a nightmare and all I live for is computer hardware
  • Telecommunications
  • K65 RGB LUX HELP!
  • Problem i need to solve fast!
  • Nightwalker
  • king_gonzalez.23
  • Does this work out?
  • Nootrina
  • Help with power supply please.
  • Why MySQL is better than Couch DB?
  • HP Compaq 6000 Pro Case Help?
  • Most powerfull CPU in the world.
  • PortzJ's Pc Life
  • Peeps Games - Zombie Escape
  • Need help upgrade cpy
  • HTML File Explorer BLOG
  • i can't unpack ram or create custom kernel
  • Doc's Cafe
  • Chaching's Problem Between a GTX 1050 Ti or a RX 570
  • Revealing HELLO2 Video Communication Device
  • Putlocker.! The Walking Dead Season 8 Episode 14 Full Online Free
  • Topniun
  • Blog of a Broke PC Enthusiast
  • deep
  • Semicolon
  • Colson's Rants
  • Be Sure Before Choosing The Right Bangalore Escort Girl
  • How to Have Fun with World of Warcraft Cosplay
  • D13H4RD's tech cavern: My opinions on many things tech and gaming plus cars
  • Need tech help
  • Computer interoperabiliy is now aweful.
  • Laptop Temperature Problem
  • Brouilleur de telephone portable est essentiellement
  • Aol desktop gold download
  • Download the AOL Desktop Gold Software
  • Microsoft office word corrupted file recovery
  • Password Recovery in AOL Desktop Gold
  • Chalkie's Weight loss Blog
  • World Travel
  • Meerkat's Flight Training
  • Well so far i hate my life
  • Health & Beauty
  • TopHat's First (and Last) LTT Blog!
  • Why not?
  • The Frosty Fest accident launches for PS4
  • Antonio Conte can play his two assiduously the added way round
  • Speed still reigns absolute in Madden
  • A new way to hack Facebook account in seconds and has not been blocked yet
  • I don’t anticipate MLB the Actualization 18 has looked better
  • MLB The Actualization alternation will not be able
  • Ambition to see how they administer to Rocket League
  • blogs_blog_1143
  • The PC and Xbox One communities get an arrival of new talent
  • We see Rocket Accord as a agenda sport
  • Sox appear on Tuesday that Garcia was placed
  • Rocket League is on the border of its third ceremony
  • Exciting being advancing up for Rocket League admirers
  • It adeptness be the endure big riff we see on the bulk Rocket League theme
  • FIFA has become the advertence bold in football simulators
  • There's something acutely acceptable about rocketing into the sky
  • There's something acutely acceptable about rocketing into the sky
  • Sterling Shepard is one of those ardent Madden admirers
  • What is the best 3DS homebrew app?
  • Accept such a bang with MLB The Appearance 18
  • Rocket League's gameplay translates aloft acutely able-bodied as a result
  • Rocket League's gameplay translates aloft acutely able-bodied as a result
  • Their Rocket League action is deceptively simple
  • We still do not apperceive a specific absolution date
  • Who ambition to accomplish something in FIFA 19
  • Frick Accolade for broadcasters in a commemoration at Doubleday Field
  • Our best admonition at this moment in your FUT career
  • Dự án chung cư nam rạch chiếc quận 2
  • Yahoo Customer Service Number to Recover Hacked Yahoo Email Account
  • movies
  • Yahoo Customer Service Helpline Number 24/7 For Instant Support
  • EVGA PSU roundup.
  • bestonlineoffersuk
  • PC Build Price Minimization
  • Stuck in bios cant boot to window icon.
  • Orbital's Pizza Adventures and Other Things
  • Gayathri
  • Random Stuff
  • What is a Body Mist, and How It is Used?
  • LTT Folding Month 2018!!!
  • Brandon
  • Gtx 750 ti - black screen after launch game
  • Techno Headz - Resolve Issues
  • Problem with opening Port Forwarding
  • Finn's Tech Blog
  • halp me
  • NEW TO THE PC WORLD.
  • Need EXP GDC complete set up.
  • Techhikers
  • Arika's random stuff
  • Caden Britton
  • Iphone Update 12.1.1 Needs fixing
  • Yurizaki's Programming Guides
  • No boot no debug no post
  • q&a/ama
  • Random Blogs, Probably about Cases
  • Jtalk's Blogs
  • test
  • Disjointed
  • poupee silicone
  • pkbazaar
  • Grizzly Coolers Reviews By Size
  • BioFluxe slim
  • Healthy mindsets in the age of information.
  • I have 2 problems with my PC
  • Asher's Blog
  • Custom Desk PC Build Log
  • Ask Me Anything
  • Canada Permanent Resident
  • Best immigration consultants in Delhi Ncr for Canada & Australia PR
  • Best immigration consultants in Delhi Ncr for Canada & Australia PR
  • Best Hong Kong Immigration Visa Consultants in Delhi
  • Best Australia Immigration Consultant Services In Delhi
  • CANADA IMMIGRATION
  • AUSTRALIA IMMIGRATION
  • AUSTRALIA SKILLED WORKER VISA
  • SKILLED INDEPENDENT VISA (SUBCLASS 189)
  • Drake101
  • technical support services
  • khaled adel
  • Shane
  • Corneltuttle
  • Game Dump Questions
  • Used Parts Flipping
  • employees Monitring
  • Инфа
  • del 11
  • Graphic Designing Tips
  • Tech & Designing Tips
  • Black Friday
  • TOMOT Computer Speakers for TV/PC/Laptops/Desktop
  • Gordon Mware Digital
  • Summer Folding Sprint! 2019
  • Toolopedia
  • An Idiots Guide to Everything Nerdy
  • Buy Best Anet A8 3D Printer
  • PCB Assembly- An Essential Technology for the Fourth Industrial Revolution
  • Altium Designer Basic Tutorial
  • Turnkey PCB Assembly Products and Services
  • IoT security and ways of securing IoT
  • extreem018
  • Download Aol Desktop Gold
  • n-droidrom
  • Does ram affect gpu load
  • Aol Customer Support NUmber
  • Crunchy's Gaming Blog
  • Xiauj's first time experiencing Linux on the UDOO BOLT V8 (Ryzen-SBC) as a First-Time-User/Linux-Noob!
  • QuickBooks Customer Care Number
  • TurboTax Customer Care
  • yueshan
  • Earthlink Password Reset
  • Do You Need Fashion Advice? It's Right Here!
  • Gordon Mware Tech Tips
  • Monitor MicroReviews
  • Display Adaptor/Refresh Rate fix
  • Sowon's Switches Reviews
  • Advice For Gathering Information For An Auto Injury Case
  • blues or brown switches
  • samsung galaxy s5 battery
  • Gordon Mware Tech Tips
  • D.I.Y OTG Cable
  • Folding Month 2019
  • (888)572–7379 Recover a forgotten Aol username & password
  • ourtime login - pof login - plenty fish pof login
  • xKyric's Ongoing Search for Price to Performance Hardware
  • del 22
  • Sub $1000 Gaming Rig, 3D Mark: 8557! First Build Ever!
  • Test
  • The use of carnations FloraSpring aims to increase digestion
  • Sowon's Album & Song Reviews
  •  Have you heard about this amazing money making website?
  • L7 COCO
  • We Buy Houses Nationwide USA
  • ZheYingChin
  • Arising issue in Sync Arlo Camera
  • pc games issue
  • pc games issue
  • Upgrading PC
  • Epic Games Free Games List Updated July 1st
  • Health insurance Assoc Is Surely Best For Everyone In Many Opinions
  • Hostsailor
  • Work At Home
  • Low-end abundance
  • TheHealthRadar
  • SchoolFork
  • NetworkProfile.org
  • LTT COVID-19 Folding Event Blog
  • Behind the Forum
  • This is a test
  • YouTube CPM blog
  • My Journey in Morrowind
  • Quantum | A Brief History of Quantum
  • Reality News | Your Daily Briefing
  • Summer Folding Sprint! 2020
  • Interesting Toy Robotics
  • Cloaked’s Indie Game Dev Blog!
  • Air cooling test
  • operation badger: The Log to End All Other Logs (of mine of this build)
  • Portal 1 themed custom case planning and build blog
  • DGBuildsPCs Tech Blog
  • Samsung Galaxy A 41 mini review
  • Folding Month 2020
  • Pens, inks & more
  • Help with RGB Hub controller
  • sub68 random
  • A Dive Into Custom Keyboards & Mechanical Switches (2021)
  • Compiling hell
  • Browser Expriences
  • Mid-Week Madness Folding Sprint
  • whatever you want it to me
  • Playstation 3 Slim (Model CECH-2504A) Restoration and Upgrade Project
  • Random humor
  • Marlyland Area Rail-Rebooted
  • RX480 PCB Powder Toy Art Project
  • Project Winterfell
  • "Summer" Folding Sprint 2021
  • LBNL news
  • What is
  • XKGB
  • Folding Month 2021
  • WHIM
  • Bloons TD 5 world record attempt
  • dava4444
  • Linusified default wallpapers
  • My Take On the State of Computing
  • AudiTTFan's Blog
  • IPD
  • AluminiumTech News
  • Vishera's Blog
  • Summer Folding Sprint 2022
  • Thrasher_565 hub links build logs
  • Mod pack for beamng.drive
  • Interactive Stream
  • Interactive Stream
  • Folding Month V
  • some computer stuff
  • Summer Folding Sprint 2023
  • Art of the week
  • Macify
  • A Programmer's guide to Tech and Life
  • Igor
  • Folding Month VI
  • Grants Electronics
  • automation reboot
  • TGif Gamer on LTT
  • LIVING WITH A Z FOLD 3
  • Дача

Product Groups

  • Subscriptions
  • Review Items
  • Shipping

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Discord


Steam


Origin


UPlay


Battle.net


PlayStation Network


Xbox Live


Twitch.tv


Twitter


Heatware


GitHub


Website URL


Location


Interests


Biography


Occupation


Member title


Other

Found 13 results

  1. Hi, I'm looking to be able to resize a table and then fill the table cells with data from another table in a custom order. This is how I resize the table Sub Resize_Table() Dim rng As Range Dim tbl As ListObject Set rng = Range("DisplayTable[#All]").Resize(Range("E11") + 4, Range("D11") + 1) ActiveSheet.ListObjects("DisplayTable").Resize rng End Sub Is there a way to fill the cells with data from another table?
  2. Typical task for me: I have a list of names of 50 local businesses and I need to find out their mailing address. I usually google them manually and copy/paste their address into my excel file. There's got to be a better way. My research shows several ways including google places api, vba code, excel power query. But the info is overwhelming and I'm not really smart enough to know what most of it means... My skill level is I can copy/paste VBA code and create various macro functions in excel. Any insight would be great. I'm willing to do my own research, just need to go down the right path, and not 100 dead ends based on my coding skill level. Thanks, Scrim Snacks
  3. Hi, I have a new student job and the task assigned to me is to empty option boxes in an excel documents on the onedrive of the company so they can be filled out again by the employees. The only problem is that that that each excel document has 12 tabs and that each tab contains more than 70 option boxes. I have to empty 40 such documents a week (one doc per employee). Is there a way to empty all option boxes (make them blank again) with a macro? The help is much appreciated
  4. I have tried a lot of approaches. But can't seem to make this work: I'm creating a UI in excel. A cmd-button on sheet1 opens a userform. Another cmd button (in this userform) allows the user to add a row of new fields in the form along with a cmd button to delete the row - if so required. It is this cmd 'delete button' I'm having issues with. The delete buttons are created, and the code inserted into "userform1", but does not execute when I click on the newly created cmd buttons. Here is my code: Option Explicit Private Sub UserForm_Initialize() Dim arrNames, arrCaptions As Variant Dim NewBtn As Control Dim Code As String Dim NextLine, LeftPos, Gap, i As Long Dim objForm As Object Set objForm = ThisWorkbook.VBProject.VBComponents("UserForm1") arrNames = Array("cmbName1", "cmbName2", "cmbName3") LeftPos = 100 Gap = 15 For i = LBound(arrNames) To UBound(arrNames) Set NewBtn = UserForm1.Controls.Add("Forms.CommandButton.1") With NewBtn .Left = LeftPos .Top = 5 .Width = 65 .Height = 30 .Name = arrNames(i) .Visible = True .Caption = "Delete row " & i + 1 .Font.Size = 10 .Font.Name = "Times New Roman" End With 'Add the event handler code which does not seem te work at the moment 'The code is added to "userform1" but does not execute when clicking on the new command buttons Code = "Sub " & NewBtn.Name & "_Click()" & vbCrLf Code = Code & " MsgBox ""action for cmd button"" & i" & vbCrLf Code = Code & "End Sub" With objForm.CodeModule 'Find last line in Codemodule NextLine = .CountOfLines + 1 .InsertLines NextLine, Code End With 'NEXT button's pos. LeftPos = LeftPos + NewBtn.Width + Gap Next i End Sub Please advise...
  5. I'm working as a graduate assistant this semester and was tasked with helping figure out how to get a process more automated within my department. I am an accounting major so my computer programming experience is next to zero. I am trying to figure out the best way to have email notifications sent to folks when files are added from to a network folder. We are using PDF fillable forms and they get one process completed in one network folder by an employee and then get copied over to another network folder for the next person to complete their portion. It's at that point that I'd like the system to send an email notification maybe every hour or something if there have been additions to the folder. I don't really care about email notifications for file deletion. The problem I've run into so far with solutions I've found online is that my organization uses Gmail for our email services and every batch file I've found requires the usage of Outlook or some other type of SMTP type email set up. Thanks
  6. Hello there my friends, I'm currently administrating and managing the MS Exchange 2013 Server down here the company where I'm working at. But I've ran into a quit huge problem for our / my workflow. Now a bit more details about the problem itself: I wanted to write a Script in Visual Basic for Applications (VBA) which does the following things: I have to enter 2 Dates, one counting as the "start" and the other one counting as the "end" of a certain time period. If I confirm them by clicking on another button labeled "Confirm", it should convert the 2 Dates, into a String-variable and combine the variable with a pre-entered cmdlet for the Exchange Management Shell for me.... The Command should look something like this: get-messagetrackinglog -Start [Starting Date] -End [Ending Date] -MessageSubject [Bills] -sender: [Mail-Adressof our Company, which sends out Bills] | Select timestamp,EventID,recipients,messagesubject | Out-File [serverpath]\MailTrackingLogs\MailTrackingLog.csv And the command, that the Script creates, works.... if u copy and paste it manually into the Exchange Management Shell (EMS)... But I want the Script to automaticlly copy the Command into the EMS, but that doesnt work ... I was thinking about the cmdlet call shell ("powershell [Path of the PS-Script]") but that one only executes PowerShell Scripts and doesnt execute the get-messagetrackinglog cmdlet. Any idea´s on how I can rid of this Problem in my VBA Script? Now if anyone of you guys is into that kind of Stuff, pls help me Im Dying.... thx Greetings, Iqu
  7. recently i programmed something in VBA ( i am just starting to learn how to code) and i ran my code on two computers with the same version of windows however the results where not what i was expecting. Computer 1: Processor: core i5 2 cores 4 logical processors base clock 2.30GHz Graphics: intel(530) RAM = 8 gb at 2133MHz Cpu usage = 65% Gpu usage= 10% For 100000 iterations it took 30.30s Computer 2: Processor: core i7 6cores 12 logical processors base clock 2.20GHz Graphics: intel(630) RAM = 16gb at 2667 MHz Cpu usage = 10% Gpu usage= 53% For 100000 iterations i stopped it at 7 min can anyone explain why computer 2 is way slower? this is the code
  8. I'm writing a program using Python 3.7 that needs to export cells into an Excel document with part of the text in each cell underlined. To form the Excel document I'm currently using the openpyxl library, which, as far as I have been able to find, has the ability to style cell by cell, but not just portions of text inside the cells - I've also looked into using xlsxwriter, which has one picture that looks like it may have been able to format on the string level, but nothing in the documentation. I'm open to using any export solution though. I've also tried using U+0332, combining low line, between characters but since I'm working partially with Chinese text it does not render correctly. Text is scraped using Beautiful Soup 4 and portions that needed to be underlined could be enclosed in <u> tags if needed. If there is a macro or number format that I could use to remove the tags and replace them with an underline that would also work great for my use case. Thanks for your help in advance! Edit: So looking at the Excel object model it looks like the smallest object you can really work with is a range of one cell, not content inside the cell. Fairly certain that there isn't a Python library that can format pieces of the string, going to try to write something in VBA. Direction on that would also be appreciated.
  9. I'm working on a program to automate some functionality of a research lab. One of the problems is that saving the file they want to use the sample ID as part of the name. Unfortunately I've run into some issues where " and / are used in the sample ID which as you know cannot be saved in Windows. The reason I'm changing variables from sampleID to correctedID is that I want to keep corrected id and my sample ID separate. I'm doing this because this program also automatically writes a several page report where the sample ID is called multiple times and needs the full sample ID. The bit of my code that I've inserted is this: Dim idArray As Variant Dim y As Integer correctedID = "" If InStr(sampleID, """") Then idArray = Split(sampleID, """") y = UBound(idArray) For x = 0 To y correctedID = correctedID & idArray(x) Next x End If If InStr(sampleID, "/") Then idArray = Split(sampleID, "/") y = UBound(idArray) For x = 0 To y correctedID = correctedID & idArray(x) Next x Else End If If correctedID = "" Then correctedID = sampleID End If Until I added this block of code there were no crashes whatsoever. With this block of code about 10% of the time excel will hard freeze with no error thrown and require me to kill it using command prompt. Thoughts? On the rare event that the code crashes BUT doesn't hard freeze excel it highlights a line near the bottom when I am saving the excel file. That line is: ThisWorkbook.SaveAs "T:\TCNA Laboratory US\PTCA\PTCA Data\20" & labArray(2) & " Automated\" & labArray(1) & labArray(2) & "\PTCA" & labArray(1) & _ labArray(2) & " C373-5 " & correctedID & ".xlsm" This is where I am calling the correctedID. I ran debugging statements to keep an eye on what value is stored in correctedID but it seems correct. If more information is required please let me know and I will provide it asap. Thanks!
  10. Using the Yahoo finance API I am acquiring market data to fill out tables. The problem I am having is when I want to add a calculated field to both my form and my table the calculation only are applied to the first run through of the program and loops after do not get calculated again. I am new to access and to VBA so forgive the ignorance if this is just a simple fix. Option Compare Database Option Explicit Private Sub btnClearData_Click() CurrentDb.Execute "DELETE FROM HistQuotes", dbFailOnError Me.Requery End Sub Private Sub btnFetchData_Click() Const FilePathName As String = "D:\file.csv" Const tmpFilePathName As String = "D:\file1.csv" Const ForReading = 1, ForWriting = 2 Dim oStream As Object Dim WinHttpReq As Object Dim FSO As Object Dim filetxt, filetxt1 Dim myURL As String Dim InputString ' As String ' Dim FileToWrite As String ' Dim InputFile As String ' Dim OutPutFile As String ' Dim Ssql As String Dim ticker As String Dim StartDay As Integer, StartMonth As Integer, StartYear As Integer Dim EndDay As Integer, EndMonth As Integer, EndYear As Integer 'clear table CurrentDb.Execute "DELETE FROM HistQuotes", dbFailOnError Me.Requery Me.Repaint DoEvents 'import symbol data --------------------------------------------------- ticker = Me.cboTicker StartDay = Day(Me.dStartDate) StartMonth = Month(Me.dStartDate) - 1 StartYear = Year(Me.dStartDate) EndDay = Day(Me.dEndDate) EndMonth = Month(Me.dEndDate) - 1 EndYear = Year(Me.dEndDate) myURL = "http://real-chart.finance.yahoo.com/table.csv?s=" & ticker & "&d=" & EndMonth & "&e=" & EndDay & "&f=" & EndYear & "&g=d&a=" & StartMonth & "&b=" & StartDay & "&c=" & StartYear & "&ignore=.csv" ' Debug.Print myURL Set WinHttpReq = CreateObject("WinHttp.WinHttpRequest.5.1") WinHttpReq.SetTimeouts 60000, 60000, 60000, 60000 WinHttpReq.Open "GET", myURL, False WinHttpReq.send myURL = WinHttpReq.responseBody ' Debug.Print WinHttpReq.Status If WinHttpReq.Status = 200 Then Set oStream = CreateObject("ADODB.Stream") oStream.Open oStream.Type = 1 oStream.Write WinHttpReq.responseBody oStream.SaveToFile FilePathName, 2 ' 1 = no overwrite, 2 = overwrite oStream.Close End If 'edit CSV header --------------------------------------------------------------- 'edit the header line. "Date", "Open" & "Close" are reserved words. Set FSO = CreateObject("Scripting.FileSystemObject") Set filetxt = FSO.OpenTextFile(FilePathName, ForReading) Set filetxt1 = FSO.OpenTextFile(tmpFilePathName, ForWriting, True) filetxt1.WriteLine ("Price_Date,Price_Open,High,Low,Price_Close,Volume,Adj_Close,Trial") InputString = filetxt.ReadLine Do While filetxt.AtEndOfStream <> True InputString = filetxt.ReadLine filetxt1.WriteLine InputString Loop filetxt.Close filetxt1.Close 'end edit CSV header --------------------------------------------------------------- Kill FilePathName 'rename the file Name tmpFilePathName As FilePathName DoEvents 'import the data to the table ------------------------------------------------ DoCmd.TransferText acImportDelim, "quoteimportspecification", "HistQuotes", FilePathName, True Me.Requery 'requery form DoEvents Set FSO = Nothing Set filetxt = Nothing Set WinHttpReq = Nothing MsgBox "Done" End Sub
  11. I am in need of some questions answered for a very difficult access project I am taking on. I am converting a flat data system of my excel program into the relational system of the access app. I simply have 21 ETFs that are being recorded daily for Open High low Close. I will eventually figure out how to make calculated fields for Exponential moving averages, but that's a different issue. I have read and read and read "HOW TOs " but I have questions that I need to be answered in order to figure out if I am even doing the right thing, I am trying to make a sandbox where I can simply pick one of the ETFs in my list and run reports based on the dates and time intervals I enter. I have set tables with a general normalization understanding that hold the symbols in one table and the days in one table and all the data in between. I eventually want all the ETFs to update all data automatically with that specific end of day's data. Access app format has the lookup relations that are ridiculous to understand so I am at a road block currently. Do I have too flat of a model for access? Do I need professional help?
  12. Hey guys, i got a little problem with a VBA command. I need certain cells to come up in the color.index=4 if the cell has the word "Voll" inside. The cells where the word can come up are in the range of (P5:S18). I already tried google but i couldn´t find a solution that i can adapt... Thanks for Tips!
  13. I'm stuck in VBA, I'm looking for a language that's both marketable and usable in my current position. What I need to be able to do... 1. Automate windows terminal emulators(reflection IBM 3270 Terminals) 2. Automate MSOffice, excel/word/outlook/blah 3. Automate webpages using either IE or chrome. Currently I use IE, its just easier in VBA. 4. Has to be windows based...All end users use windows. Unfortunately, I don't have any database access right now. Or even database tools of any kind... It's a pain. But I'd like whatever I move to to allow me to connect to SQL server. I was going to start writing everything in vb.net, but I don't know if that's the best move for me. Even in VBA, i find myself writing a ton of "classes" because it makes all my work moving forward easier. I'm not scared of a learning curve, because I genuinely enjoy learning new things (As I sit here debugging code written in a language no longer relevant to a civilized society.). Until I decide a new place to rest my hat I've been spending a little bit of time every week familiarizing myself with the .net environment.
×