How to Open Excel from Access Using VBA

[@kannannable]

Hi Sean, Thanks for the Guide. I cannot see the Tools or any options in the module window. Could you please help me how get those menus in the Module window?

[@kannannable]

Due to that I cannot able to select the reference for Excel application. Pls help me. Thanks.

[@seanmackenziedataengineering]

That's a strange one! Do you mean in the VBA coding window?

[@kannannable]

@@seanmackenziedataengineering Yeah, yes Sean.

[@kannannable]

Is there any short cut to enable the menus in module window? It is showing plain window and I can able to edit only the code. No options of project explorer and others.

[@seanmackenziedataengineering]

@@kannannable Press the Alt key and you should see the drop down menu appear. Then drag the menu under the title bar.

[@ramiraghat8496]

Thanks for the video Sean. Could you make a video focused on how to merge selected pdf files into one in Access? Just an idea.

[@seanmackenziedataengineering]

Thanks, that is a good idea for a video!

[@RM-cu2xb]

Hi Sean, can you explain how to switch between tabs in excel using access vba?

[@seanmackenziedataengineering]

Great question! You can simply use .Activate ie. Set objSheet = objBook.Worksheets("MySheet") objSheet.Activate

[@jonjcapps]

Currently I use Access to open edge, and search for an Excel file then click the file. Is there a way to open edge, search for the Excel file and then open Excel from OneDrive browser with VBA?

[@seanmackenziedataengineering]

Great question.. That is going to be a stretch. If you can log into OneDrive in your Windows session, it might be easier to search and open it using the file system instead.

[@marthaestrada890]

Would this format work for .xlsm files as well?

[@seanmackenziedataengineering]

Should work fine! You can open xls, xlsx, xlsm

[@SAMYTAHER]

Any news Regarding the inquiry

[@seanmackenziedataengineering]

On this video?

[@dbdata9836]

thanks

[@seanmackenziedataengineering]

You're welcome!

[@dbdata9836]

very very good

[@seanmackenziedataengineering]

Thanks!

[@SAMYTAHER]

thank you We need I need code that will compare two different databases (ACCDB split database) The purpose is to update the old customer database with new updates without deleting the old database data The tasks of the codes are: * If a table exists in the new database and does not exist in the old database, a copy will be made * It compares the fields for you table in the event that a field is found that does not exist in the old database, it creates the right * It compares the properties of the fields for each field and the properties of the fields in the old database are modified * Modifies the relationships between tables to be like the relationships in the new database

[@seanmackenziedataengineering]

Great question, and would be a good idea for a video. Or videos! There is quite a few operations there. You can start with this: kzbin.info/www/bejne/r6i3l36jms5oh8U You can cycle through each database and make comparisons. Thanks!

[@SAMYTAHER]

@@seanmackenziedataengineering Thank you for waiting for making videos

[@SAMYTAHER]

Any news Regarding the inquiry above

[@dbdata9836]

10/10

[@seanmackenziedataengineering]

Thanks again!