Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 01-28-2014, 11:01 PM
BobBridges's Avatar
BobBridges BobBridges is offline Workbook data Names in VBA are string only? Windows 7 64bit Workbook data Names in VBA are string only? Office 2010 32bit
Expert
Workbook data Names in VBA are string only?
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Quote:
Originally Posted by execelledsoftware
Wow this was certainly informational.
LOL. I remember a comic translation of womamspeak into manspeak and vice versa. One of the entries was a woman saying "You certainly are...manly." The translation is "you're sweating and you smell a lot". I get the feeling that "informational" may mean "boy, you sure churned out a lot of words, there".

Yeah, of course the way you suggested is the obvious way to do it. But I have a sort of mania about putting frequently-used routines inside smaller routines, to make them easier to use; and I not only call NN five times in this function, but I also call in from the function immediately above. As soon as I saw I needed to do it more than once, that was it; I assumed I'd want it again in yet other routines, sooner or later, so I put it in a separate function.

Quote:
Originally Posted by Catalin.B
Have you tried [Application.Evaluate]?
I'd never even heard of it. And now that I look it up, it seems to me I've been ignoring the methods of the Application object far too long. I think I have some reading and experimenting to do. Thanks, Catalin; I don't know that I'll end up using it—what I have now seems to work—but even if I don't, I'll have learned about Evaluate and those other useful-looking methods and will probably use some of them on another occasion.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Workbook data Names in VBA are string only? Way to search for a string in text file, pull out everything until another string? omahadivision Excel Programming 12 11-23-2013 12:10 PM
Replace contents form 1 workbook with another based on simular data shabbaranks Excel 1 12-05-2012 11:11 PM
Workbook data Names in VBA are string only? macro to transfer data from one workbook to another workbook virsojour Excel Programming 5 02-01-2011 08:58 PM
inserting a string of data into an MS Word table??? matto Word VBA 0 07-16-2010 09:35 AM
Workbook data Names in VBA are string only? How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft