Register Free Newsletter Plus Membership
  • Home
    • Newsletters/Alerts
    • Forums
    • About
    • MS-DEFCON System
    • Master Patch List
    • Register
    • Login
Microsoft Patch Defense Condition level 4 There are isolated problems with current patches, but they are well-known and documented on this site.
SIGN IN Not a member? REGISTER PLUS MEMBERSHIP
  • WSAbraxus

    WSAbraxus

    @wsabraxus

    Forum Role: AskWoody Lounger

    Registered: 6 years, 1 month ago

    • Profile
    • Topics Started
    • Replies Created
    • Engagements
    • Favorites
    Viewing 15 replies - 31 through 45 (of 171 total)
    1 2 3 4 … 10 11 12
    Author
    Replies
    • WSAbraxus
      AskWoody Lounger
      June 19, 2008 at 8:56 pm in reply to: Getting data from multiple Excel books (2003) #1113495

      Sorry, copy/paste from somewhere else that hasn’t been corrected.

    • WSAbraxus
      AskWoody Lounger
      June 5, 2008 at 11:03 pm in reply to: Export lots of data to Excel (2003) #1111693

      It sure does…I did not notice that. anigrin

    • WSAbraxus
      AskWoody Lounger
      June 5, 2008 at 10:43 pm in reply to: Export lots of data to Excel (2003) #1111686

      Hans, I noticed your post after I posted mine.

      Yours looks like it would work, but I am needing to push from Access to Excel rather than pull data into Excel from Access.

      Thanks for the code, though. I will keep that for sure!

    • WSAbraxus
      AskWoody Lounger
      June 5, 2008 at 10:41 pm in reply to: Export lots of data to Excel (2003) #1111684

      After I posted this, I continued looking and found this code. I modified it to split the results into different workbooks based on a given field in the query/table. If a given set of data > 65k rows, it splits it into 2 tabs.

      WOW was it faster than my method.

      I hope this helps someone else.

    • WSAbraxus
      AskWoody Lounger
      May 21, 2008 at 10:22 pm in reply to: Delete Duplicate Rows (2003) #1109995

      I’ve tried that, too. Same error.

      Right now I’m trying exporting the data to a .txt file then re-importing but disallowing duplicates.

    • WSAbraxus
      AskWoody Lounger
      May 8, 2008 at 3:28 pm in reply to: VBA – Excel forumla referencing a different workbo #1108560

      Is it possible to have that cell = the VALUE rather than be linked?

    • WSAbraxus
      AskWoody Lounger
      May 8, 2008 at 2:51 am in reply to: VBA – Excel forumla referencing a different workbo #1108507

      Hans,

      If I could hug you right now I would.

      Consider yourself hugged!!

    • WSAbraxus
      AskWoody Lounger
      April 17, 2008 at 7:57 pm in reply to: Breakpoint removed—still jumps into code (2003) #1106004

      I did a Compile and the problem seems to be resolved.

    • WSAbraxus
      AskWoody Lounger
      April 17, 2008 at 6:51 pm in reply to: Breakpoint removed—still jumps into code (2003) #1105988

      But it hasn’t.

      This has been happening for a few weeks…on multiple computers.

    • WSAbraxus
      AskWoody Lounger
      April 2, 2008 at 3:28 pm in reply to: Read only tables…is it possible? (2003) #1104273

      Hmmm…I’m not interested in doing the security thing and there are no forms, just tables.

      Thanks for the info on security, though. I’ve never really known much about it.

    • WSAbraxus
      AskWoody Lounger
      March 15, 2008 at 2:12 am in reply to: Grouping for totals (2003) #1102061

      Perfecto, thank you!

      Someday I’ll understand the IIF function.

    • WSAbraxus
      AskWoody Lounger
      March 9, 2008 at 5:48 am in reply to: if value between 2 numbers… (2003) #1101276

      Well, I rethought it and went with this:

      =IF(E8<122,"BT",IF(E8<=142,"AT",IF(E8<=153,"OT","BT")))

      Still curious if there is a better way to do the inbetween…

      Thanks!

    • WSAbraxus
      AskWoody Lounger
      March 9, 2008 at 3:26 am in reply to: Save manipulated excel sheet with different name ( #1101273

      Thank you so much, Hans.

      It worked perfectly.

    • WSAbraxus
      AskWoody Lounger
      March 6, 2008 at 12:45 am in reply to: Access VBA reads file all at once (2003) #1100764

      So my best option is to loop thru the file, character by character, until I find a line feed and consider that a line for processing, right?

    • WSAbraxus
      AskWoody Lounger
      March 6, 2008 at 12:06 am in reply to: Access VBA reads file all at once (2003) #1100753

      When I copy/paste the CONTENTS of the file to a new file, it works, but the original file does not…

    Viewing 15 replies - 31 through 45 (of 171 total)
    1 2 3 4 … 10 11 12
  • « Older Entries
    Newer Entries »
DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address
Thanks for subscribing!

Register
Lost your password?

Plus Membership

Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.

AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.


Get Plus!

Welcome to our unique respite from the madness.

It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.

Search Newsletters

Search Forums

Advanced Search

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums
  • Search for Topics

    • Most popular topics
    • Topics with no replies
    • Recently active topics
    • New posts: Last day
    • New posts: Last three days
    • New posts: Last week
    • New posts: Last month
    • Topics with most replies
    • Latest topics

    Recent Topics

    • Windows 11 Insider Preview build 26200.5622 released to DEV by joep517
      12 minutes ago
    • Windows 11 Insider Preview build 26120.4230 (24H2) released to BETA by joep517
      13 minutes ago
    • MS Excel 2019 Now Prompts to Back Up With OneDrive by lmacri
      3 hours, 20 minutes ago
    • Firefox 139 by Charlie
      2 hours, 36 minutes ago
    • Who knows what? by Will Fastie
      1 hour, 6 minutes ago
    • My top ten underappreciated features in Office by Peter Deegan
      57 minutes ago
    • WAU Manager — It’s your computer, you are in charge! by Deanna McElveen
      13 hours, 13 minutes ago
    • Misbehaving devices by Susan Bradley
      3 hours, 5 minutes ago
    • .NET 8.0 Desktop Runtime (v8.0.16) – Windows x86 Installer by WSmeyerbos
      1 day, 6 hours ago
    • Neowin poll : What do you plan to do on Windows 10 EOS by Alex5723
      23 minutes ago
    • May 31, 2025—KB5062170 (OS Builds 22621.5415 and 22631.5415 Out-of-band by Alex5723
      1 day, 5 hours ago
    • Discover the Best AI Tools for Everything by Alex5723
      4 hours, 40 minutes ago
    • Edge Seems To Be Gaining Weight by bbearren
      19 hours, 44 minutes ago
    • Rufus is available from the MSFT Store by PL1
      1 day, 3 hours ago
    • Microsoft : Ending USB-C® Port Confusion by Alex5723
      2 days, 6 hours ago
    • KB5061768 update for Intel vPro processor by drmark
      6 hours, 26 minutes ago
    • Outlook 365 classic has exhausted all shared resources by drmark
      5 hours, 9 minutes ago
    • My Simple Word 2010 Macro Is Not Working by mbennett555
      2 days, 2 hours ago
    • Office gets current release by Susan Bradley
      2 days, 5 hours ago
    • FBI: Still Using One of These Old Routers? It’s Vulnerable to Hackers by Alex5723
      3 days, 19 hours ago
    • Windows AI Local Only no NPU required! by RetiredGeek
      3 days, 3 hours ago
    • Stop the OneDrive defaults by CWBillow
      3 days, 19 hours ago
    • Windows 11 Insider Preview build 27868 released to Canary by joep517
      4 days, 5 hours ago
    • X Suspends Encrypted DMs by Alex5723
      4 days, 8 hours ago
    • WSJ : My Robot and Me AI generated movie by Alex5723
      4 days, 8 hours ago
    • Botnet hacks 9,000+ ASUS routers to add persistent SSH backdoor by Alex5723
      4 days, 8 hours ago
    • OpenAI model sabotages shutdown code by Cybertooth
      4 days, 9 hours ago
    • Backup and access old e-mails after company e-mail address is terminated by M W Leijendekker
      3 days, 21 hours ago
    • Enabling Secureboot by ITguy
      4 days, 4 hours ago
    • Windows hosting exposes additional bugs by Susan Bradley
      4 days, 17 hours ago

    Recent blog posts

    • Who knows what?
    • My top ten underappreciated features in Office
    • WAU Manager — It’s your computer, you are in charge!
    • Misbehaving devices
    • Office gets current release
    • Windows hosting exposes additional bugs
    • May preview updates
    • MS-DEFCON 4: As good as it gets

    My Profile

    Login and Registration

    • Log In
    • Register

    Key Links

    • > Computerworld's The Microsoft Patch Lady
    • > Computerworld's Woody on Windows
    • AskWoody Knowledge Base index
    • BlockaPatch tools
    • Gift subscription for Ask Woody Newsletter
    • Microsoft Answers Forum
    • Tasks for the Weekend YouTube Channel
    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  
    « May    

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.