Search results for query: powerpoint VBA

  1. Uncle Gizmo

    I'm in Love with ChatGPT

    This might be of interest to some members here. A blog about controlling PowerPoint with ChatzGPT and VBA... https://sennhauser.com/create-beautiful-powerpoint-slides-with-chatgpt-and-vba/
  2. Uncle Gizmo

    Hello Fellow Accessors

    I wonder, could this blog provide some inspiration:- https://sennhauser.com/create-beautiful-powerpoint-slides-with-chatgpt-and-vba/
  3. strive4peace

    want to come to an online user group meeting?

    join us Tuesday 31 October! noon Central time. NOTE: 5pm London time since y'all switched clocks back and we didn't yet ... normally 6pm for Brits (thanks, Colin @isladogs) . All are welcome and it's free. Two free tools that run in Access: (1) List Objects from Access databases and (2) VBA...
  4. The_Doc_Man

    Hello guys, nice to join you

    The problem with code validation is that VBA (used underneath Access, Excel, Word, PowerPoint, Outlook, and a few others) is a pseudo-compiler. VBA generates emulation code for a virtual CPU (and we can't guarantee the implied characteristics.) It doesn't create binary code like more...
  5. E

    Hello guys, nice to join you

    Wow! This is enlightening! i will send it to them. Thank you very much. :)
  6. The_Doc_Man

    Accesshooked for long, still no expert

    Hello and welcome to the forum. VBA isn't that hard. The trick is the objects you can touch in the environment. Different objects for Access, Word, Excel, PowerPoint, Outlook, etc.
  7. U

    Solved Report Export as Pdf, Export as Excel and Export as Word.

    I suggest you have a look at 4tops document creation using Microsoft Access. It supports all documents you require, Word, Excel, Pdf (also PowerPoint) and gives you full control over the documents you want to create including where data goes in the document. The wizard produces detailed VBA code.
  8. M

    Show a Progress Bar on Form Loading ...

    Forgot to mention, it only works in Access and you can also use DoCmd.Hourglass = true/false - but that seems to reset when the current procedure ends: https://learn.microsoft.com/en-us/office/vba/api/access.docmd.hourglass In Excel - it is Application.Cursor...
  9. GPGeorge

    ColorIn Function

    I have a long-standing tradition. If there is a simple, effective, consistent, native way to accomplish a task, I use it and don't waste a lot of time trying to write a wad of new VBA code to replicate it. This applies not only to Access, but to Excel, PowerPoint, and Word, as well.
  10. The_Doc_Man

    Export the report in Access to PowerPoint and add each page of the report to a slide

    If you don't use the PowerPoint library then you are stuck. Part of the difficulty is that you will have trouble doing this directly because of what you use as a file output format. Once a report is output as PDF then you need an Adobe external library to break it apart. The Excel output...
  11. L

    Adobe VBA Reference to password protect a PDF

    Hi everyone, I am able to export MS Office files to PDF via VBA, no problem. However, as Microsoft don't give an option to password protect the PDF using VBA I am now looking to the Acrobat VBA reference for this. I have Acrobat Pro on my PC, so have access to the Acrobat References...
  12. Isaac

    Solved Importing Excel Spreadsheet that has a password

    No, that's Excel VBA. Doesn't matter that you're doing it from Access, Outlook, Powerpoint, Word or Visio. It's still Excel VBA. Thus, you're more likely to get help in the Excel forum, because the people most experienced with Excel vba will be looking there. Suit yourself - just some advice.
  13. Jason Lee Hayes

    Solved 3D Images on a form

    Is this possible? Has anyone done it? On Windows and macOS, Word, Excel, PowerPoint, and Outlook support inserting 3D models directly into your documents, workbooks or presentations to illustrate a point. You can rotate models 360 degrees or tilt up and down to show a specific feature of an...
  14. Gasman

    Create database and load a module using vba.

    Jack, what I would do is run that reference code on a db that has that reference, and use that? You could even put it all into a table? Here is my 12 version Access - Microsoft Access 12.0 Object Library - {4AFFC9A0-5F99-101B-AF4E-00AA003F0F07} - 9 - 0 - C:\Program Files (x86)\Microsoft...
  15. isladogs

    Option Explicit ?

    I'm not aware of any reason for omitting it It has long been a request that MS make this the default in all new databases. In fact it seems logical that it should be the default option in all VBA enabled applications such as PowerPoint / Excel / Word. Perhaps the reason for not doing so dates...
  16. Cotswold

    What datatype is Public MyVariable

    I was thinking of procedural languages actually. However, I would never think of any of those Office applications as being a development environment to create a business system, with the grudging acceptance of Excel maybe being an exception in some instances.
  17. MajP

    What datatype is Public MyVariable

    Actually the opposite is probably true. All the Office applications that support vba (Excel, Powerpoint, Outlook, Word) can either support User Forms or their GUI (worksheet, document, slide, etc) supports vba and scripting. I cannot think of any software application that has forms and a...
  18. Minty

    Link PowerPoint to Database

    You can update a graph datasource in Powerpoint from Access or the other way around in VBA. I'm not sure you can link them though. Advance Warning! : PPT VBA is an interesting learning curve.
  19. M

    Solved Determine if M365 via VBA - how?

    Making progress ... @isladogs - Thanks - I missed the part of your comment with the #. I'd seen that for 32/64-Bit Bitness, but never knew what it did. I learned something new. If it doesn't work, I have another idea. The sub that is failing is called Export2XLS. Rather than splitting it...
  20. MajP

    VBA error handling tutorial

    There should not be any difference. You are not writing in Access or Excel, you are writing code in VBA. Those links provided are generic to VBA, but would not matter if error handling in Access, Excel, Word, Outlook, PowerPoint etc. My error trapping is identical in all of those applications.
Top Bottom