Windows 10: How to write macro code in Access 365

I want to open an Excel file from a form in Access.I can't find the macro tools to do this. When I use the Create Tab and select macro all I get is the following form.The drop down list does not include anything about opening other programs like Excel, Word, PPTThis used to be such a simple process but now with the new improved versions I don't what to do.Any Ideas

:)

 

Safely enable Word 365 Macros?

I need to write some macros for Word 365. But apparently, macros are disabled, and my only option is "enable all macros," which is unsafe.

Is there some way I can enable only specific macros, especially the ones I write?


Win 10 ver 20H2

 

macro to print from a list of numbers which correspond to a tab

Hi,

I need to write a macro to print invoices from a single excel file.

First page I have the list of invoice numbers 1701.1702.1703.1704 etc, this list is on a tab called sales. I then have a tab per invoice, so there will be a tab called 1701 and then another named 1702 and then another named 1703 and so on.

How can I write a simple macro to look at the list to establish which invoice tabs to then print off?

Very frustrating, anyone recommend some dummy guides to writing VBA code?

Thanks

 

Ez Macros or any other Macro program

Hi Brian,

The issue is quite unclear and too broad for us to distinguish the main reason why you are having challenges/issues in Macro. To have a better understanding of your concern, we'd like to ask you some questions:

• Are you referring on using macros on Excel? If yes, what is the version of your Office?
  
• What exact application are you using when using macros? Where did you download it?

• What were the recent changes made on your computer before you experienced this issue?
• What troubleshooting steps have you done so far?
• Did you receive any error message?

Your response will be much appreciated.