ChatGPT (or equivalent) to write VBA code?

P

PhilBurton

Senior Member
OS Version(s)
  1. Windows
Outlook version
Outlook 365 64 bit
Email Account
IMAP
Operating system::    Windows 11
Outlook version:     Office 365
Email type or host:    IMAP + 5 PST files
Does anyone have experience with using an AI tool like ChatGPT to write VBA code?
 
It doesn't do well with Outlook code. It often mixed in word VBA or excel that does not work in Outlook (unless you bind the object models, which it doesn't do).

I was not happy with chatgpt or Copilot at writing php - but claude worked perfectly. I needed to convert a Microsoft sql stored procedure to mysql then convert the php that used the SP to use the mysql version. It handled it perfectly. It's possible that chatgpt or Copilot improved since I last tried them - did not do a comparison at the same time. I still have some SP and code to convert - if I have time, will test it in all.
 
Diane Poremsky said:
It doesn't do well with Outlook code. It often mixed in word VBA or excel that does not work in Outlook (unless you bind the object models, which it doesn't do).

I was not happy with chatgpt or Copilot at writing php - but claude worked perfectly. I needed to convert a Microsoft sql stored procedure to mysql then convert the php that used the SP to use the mysql version. It handled it perfectly. It's possible that chatgpt or Copilot improved since I last tried them - did not do a comparison at the same time. I still have some SP and code to convert - if I have time, will test it in all.
Click to expand...
About a year ago, I asked ChatGPT to write Pl/1 programs for me. (Long story short, I did all of my programming many years ago in Fortran and PL/1. I can't seem to get my head around classes, instantiation, objects, etc. Call me old.)

About half the time, ChatGPT did give me PL/1 code. But it often gave me C or C++ code, or some other code that I know was not PL/1.
 
You must log in or register to reply here.
My Feedback to Microsoft and their response; also New Outlook roadmap >
Similar threads
Thread starter Title Forum Replies Date
Commodore Any PocketKnife Peek equivalent? Using Outlook 4
N EnableEvents, Outlook equivalent Outlook VBA and Custom Forms 10
J Outlook Connector equivalent for Google Mail? Using Outlook.com accounts in Outlook 2
T Customized form: The Forward option shows write layout Outlook VBA and Custom Forms 0
F VBA code to dock Styles whenever I write or edit an email Outlook VBA and Custom Forms 0
A Read and Write to Text File Outlook VBA and Custom Forms 1
F VBA routine to write new sub routine in outlook Outlook VBA and Custom Forms 0
P Is it possible to write a macro to email to all addresses of selected contacts? Using Outlook 1
D How Would I Write This Filter? Using Outlook 3
F Can I write a macro that triggers off an Outlook alert Outlook VBA and Custom Forms 1
M how do I write a plug in to send messages to a web app? Outlook VBA and Custom Forms 1
E RE: How do i write a letter to a business contact BCM (Business Contact Manager) 1
P Possible to write a macro to print all attachments with specific . Outlook VBA and Custom Forms 1
P Write a tool to generate a PST file with the same structure as old Outlook VBA and Custom Forms 1
B Write code for a button on New Form Outlook VBA and Custom Forms 1
S write and format a piece of text in the body using vba Outlook VBA and Custom Forms 7
J How to write a macro to search inbox for certain numbers Outlook VBA and Custom Forms 2
S Write custom text in outlook infobar Outlook VBA and Custom Forms 1
S Macro to Write Rules Outlook VBA and Custom Forms 4
A How to write into outlook status bar. Outlook VBA and Custom Forms 1
Q Outlook become non responsive if i write outlook item in bulk Outlook VBA and Custom Forms 20
V Outlook 2007: How to read/write Out-of-Office settings Outlook VBA and Custom Forms 3
M What is the recommendet way to read/write a user defined Field (Named Property) in the MailItem Obje Outlook VBA and Custom Forms 1
M What is the recommendet way to read/write a user defined Field (Named Property) in the MailItem Obje Outlook VBA and Custom Forms 5

Similar threads

Back
Top