Edit ALREADY OPENED Excel by Access VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-3337079%22%20slang%3D%22en-US%22%3EEdit%20ALREADY%20OPENED%20Excel%20by%20Access%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3337079%22%20slang%3D%22en-US%22%3E%3CP%3ENot%20sure%20if%20here%20is%20the%20best%20place%20to%20ask.%20Due%20to%20a%20recent%20company%20policy%2C%26nbsp%3B%20I%20no%20longer%20have%20access%20to%20%3CSTRONG%3E%3CU%3EExcel%3C%2FU%3E%3C%2FSTRONG%3E%20VBA%2C%20but%20still%20have%20access%20to%20%3CU%3E%3CSTRONG%3EAccess%3C%2FSTRONG%3E%3C%2FU%3E%20VBA.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20I%20want%20to%20edit%20Excel%20by%20%3CSTRONG%3E%3CU%3EAccess%3C%2FU%3E%3C%2FSTRONG%3E%20VBA.%20I%20have%20learnt%20that%20I%20can%20do%20it%20to%20a%20%3CU%3E%3CSTRONG%3Eclosed%3C%2FSTRONG%3E%3C%2FU%3E%20Excel%2C%20thanks%20to%26nbsp%3B.theDBguy%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Foffice%2Fen-US%2F6d140614-5f00-4a05-af7a-65cc509dff83%2Feditingcreating-excel-file-through-access-vba%3Fforum%3Daccessdev%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Foffice%2Fen-US%2F6d140614-5f00-4a05-af7a-65cc509dff83%2Feditingcreating-excel-file-through-access-vba%3Fforum%3Daccessdev%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20if%20I%20want%20to%20edit%20an%20%3CSTRONG%3E%3CU%3Ealready%20opened%3C%2FU%3E%3C%2FSTRONG%3E%20Excel%20by%20Access%20VBA%2C%20is%20there%20a%20way%20to%20do%20that%3F%20Thanks!!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3337079%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Not sure if here is the best place to ask. Due to a recent company policy,  I no longer have access to Excel VBA, but still have access to Access VBA.

 

Now, I want to edit Excel by Access VBA. I have learnt that I can do it to a closed Excel, thanks to .theDBguy https://social.msdn.microsoft.com/Forums/office/en-US/6d140614-5f00-4a05-af7a-65cc509dff83/editingcr...

 

However, if I want to edit an already opened Excel by Access VBA, is there a way to do that? Thanks!!!!

0 Replies