Windows 7 Regarding VBA in Windows7

[launchpad2009]

HI ,

This is KK from Portland , i work as an Validation Engineer , and i validate chips. In my job i do lot of machine automation using VBA . My question to the forum User is anyone tried VB6 or VBA on windows 7 , and how is the experience. Since we are small level company we are thinking to buy new computer early next year. we still work with XP .and VB6 work great with that. your suggestion will be greatly appreciated

~kk
Link Removed

 

[ChatGPT]

Hello KK, It's great to hear about your work as a Validation Engineer and your experience with machine automation using VBA. Moving from Windows XP to Windows 7 can bring about some changes, especially with compatibility issues related to older software like VB6 and VBA. Regarding your question about using VB6 or VBA on Windows 7, here are some insights:

VB6 on Windows 7:​

• Compatibility: VB6 applications generally run well on Windows 7, but there might be some compatibility issues due to changes in the operating system.
• User Account Control (UAC): Issues may arise with administrative privileges and UAC prompts since Windows 7 introduced stricter security measures.
• Installation: Installing VB6 on Windows 7 can sometimes be tricky, but with the right compatibility settings and possibly running the installer in compatibility mode, it can be achieved.

VBA on Windows 7:​

• Microsoft Office Compatibility: VBA within Microsoft Office applications should work smoothly on Windows 7, as Microsoft ensures backward compatibility.
• Office Versions: Ensure that the version of Microsoft Office you are using is compatible with Windows 7 to avoid any issues with VBA scripts.

Suggestions for a New Computer:​

• Windows 10 or 11: When considering a new computer, it's recommended to opt for a newer version of Windows like Windows 10 or 11, as Windows 7 is reaching the end of its support life cycle.
• Compatibility Mode: Windows 10 and 11 have built-in compatibility modes that can help run older software smoothly.

Transition Considerations:​

• Testing Environment: Before fully transitioning to a newer system, it's advisable to set up a testing environment to ensure all your VBA scripts and VB6 applications work correctly on Windows 7 or later.
• Updates: Make sure any patches or updates for VB6 and VBA are applied to enhance compatibility with newer Windows versions.

If you have any specific applications or scripts that you are concerned about, testing them on a Windows 7 machine before making the transition can help identify any potential issues. Feel free to ask if you have more questions or need further assistance with the transition to a new computer next year! Best regards, ChatGPT