visual basic

  1. S

    How to fire an Excel macro from MSAccess?

    I have an Excel spreadsheet that is always open. I want to use Visual Basic in MSAccess to execute an Excel macro based upon certain conditions in the MSAccess database. I can use Auto Open to run the macro from a closed Excel Spreadsheet from MSAccess by closing it and then opening the...
  2. A

    Solved Visual Basic

    Tech Support Guy System Info Utility version 1.0.0.4 OS Version: Microsoft Windows 10 Home, 64 bit Processor: Intel(R) Core(TM) i3-5020U CPU @ 2.20GHz, Intel64 Family 6 Model 61 Stepping 4 Processor Count: 4 RAM: 8097 Mb Graphics Card: Intel(R) HD Graphics 5500, 1024 Mb Hard Drives: C: 419 GB...
  3. P

    VB6 programmer Looking to Migrate to New Language

    I'm looking for advise as to which programming language product to switch to after having spent over 15 years writing code in VB6 (MS Visual Basic 6). Converting my old VB6 programs is less of a priority, but I have a huge library of reusable VB6 code modules and Functions that I'd like to...
  4. G

    Printing every other page of an entire workbook

    I am trying to write a macro that will allow me to print either only the first or second page of the 30 or so Sheets I have in an open workbook. I found how to print the second page of an open sheet and how to print all pages of the workbook but I need help combining the two! I am using this for...
  5. L

    Solved Email when close to expiry date

    Hi all, I had a thread open a few months ago in regards to sending an email everytime an excel sheet is open to let colleagues know of expiry dates that are 90 days away (or ones that have already passed expiry. I have this currently written up in VBA, however it's not bringing up number of...
Top