Hi, I have some VBA macros in Excel that builds very long SQL strings and the code is very difficult to read because of all the string concatenations.
I was thinking to build the SQL query in a Worksheet and then read it into a VBA string. This way my code would be easier to read and also I could quickly cut&paste the query into my favourite DB client and execute it against the Database for testing purposes. However whenever I try to paste the string I get the error "Formula is too long". Can anybody suggest another way to achieve the same result? Thank you. --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
