How to enable macros in xlsx Videos

• 1. Microsoft Excel 2010 - Compiling All Macros - Automating Report 4 of 4
• 2. How to Turn PDF into Excel (XLSX, XLS Formats) on Mac OS X?
• 3. How to make a button, and assign a macro to it in Excel (Excel tips #1)
• 4. Set Field Properties for an Access Database Table
• 5. Record and Edit an Excel Advanced Filter Macro
• 6. New workbook 1. New file 2. Page layout 3. Quick Access toolbar 4. View settings 5....
• 7. How To Use Excel XLS and XLSX To DBF Converter Software

Microsoft Excel 2010 - Compiling All Macros - Automating Report 4 of 4

User Comments

Chesed Mercado commented on 09 May 2013

hi I'm a noob. but i wanna ask. soo testfile is just there to get some data from a workbook and then create a public report readonly file. is that it? what's the purpose for this?

How to Turn PDF into Excel (XLSX, XLS Formats) on Mac OS X?

How to make a button, and assign a macro to it in Excel (Excel tips #1)

Set Field Properties for an Access Database Table

User Comments

TheBulletproof357 commented on 27 Aug 2014

Do you have a video explaining how to create a login and switchboard for access 2007?

Record and Edit an Excel Advanced Filter Macro

User Comments

McKenzie Lockhart commented on 05 Feb 2015

What if, in the macro, I want it to filter for more than one value. For instance, I have a list containing data for 62 cities (criterion) and need data copied weekly from each city. How could I copy the advanced filter in the macro for those 62 criterion. Each time I've tried, the macro records all my scrolling through the data and it's tough to find which part of the HTML is the filter. I want to delete the excess as Contextures did in the video. PS: I'm an excel newbie and an HTML dummy. Any help would be greatly appreciated.

Sandeep Singh commented on 20 Jan 2015

Hey Guys i found the solution to error Run time error 40036 (application defined or object defined error) I have given the macro name TopOrders and also the sheet name is TopOrders. I have changed the name of macro and tried again. Now its working for me.. Thank you again for sharing this video.

Sandeep Singh commented on 20 Jan 2015

Thank you for the video..Its working fine if we record it... after making changes like current region.. adding the sheet name TopOrders, the code is giving error like Run time error 40036 application defined or object defined error. Any help on this will be great. Thank you.

Eager Beaver commented on 24 Oct 2011

after I change type in CurrentRegion and I got everything like yours but there's this error 1004 that says my extract file region is wrong or something like that. don't know what to do

Joseph Rinaldi commented on 30 Apr 2015

SO Helpful, I was using dynamic formulas to auto extract, and with 20,000 records it was a big slow workbook! Now its very lean and quick, thank you so much!

Un Watch commented on 28 May 2015

Hi there if are using share folder. Any ways we could find out last person edit?

KenTara John commented on 21 Jan 2012

You are good but need to slow down a little :)

Ronald Ryland commented on 30 May 2012

Chrystal clear, as always ;) Thx, Debra ;)

prashant shinde commented on 15 May 2015

Excellent Video ...thanks a ton

S paul commented on 24 Oct 2013

Very good video. Keep it up.

aad11 commented on 05 Apr 2013

EXCELLENT! TNX, Debra :)

New workbook 1. New file 2. Page layout 3. Quick Access toolbar 4. View settings 5....

How To Use Excel XLS and XLSX To DBF Converter Software

User Comments

shbug01 commented on 13 Aug 2015

Useless without sound