How to Loop through all open Workbboks

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to Loop through all open Workbboks

FAQ

Thread Tools

Display Modes

09-08-2018, 06:41 AM

NoSparks

Windows 7 64bit How to Loop through all open Workbboks

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Quote:

Yes my code is located in Book.xlsx

No it isn't... it can't be.
Code can only be saved in an .xlsm (macro enabled) file.

Quote:

Also, just a quick question. I'm new to VBA and want to know when to use the "With" command.

While in the VBA environment, if you put the cursor in a word and hit F1 Excel will bring up the help page for that word.

A quick Google search for "VBA when to use with" returned this as one of the top items.

Last edited by NoSparks; 09-09-2018 at 06:05 AM. Reason: spelling

Tags

copy, for each loop, for loop

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Do Loop bug	donlincolnmsof	Word VBA	11	09-07-2017 10:07 PM
Macro Loop Help	Twizzle008	Word VBA	15	09-18-2015 03:20 PM
What's wrong with my loop?	Irrma	Word VBA	2	06-17-2014 06:25 AM
How to a For loop in VBA	Jennifer Murphy	Word VBA	1	01-29-2013 03:30 AM
Continuous Loop	cksm4	Word	6	01-06-2011 09:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:29 AM.