The code works OK when I use the commented out “xlBook” variable but errors when I use the longer one. Are you aComputer / IT professional?Join Tek-Tips Forums! The time now is 12:15 AM. Microsoft Access Help General Tables Queries Forms Reports Macros Modules & VBA Theory & Practice Access FAQs Code Repository Sample Databases Video Tutorials Sponsored Change permission of file Could mollusks become extremely large? http://sortoutlookemail.com/vba-error/vba-error-20-resume-without-error.html
The time now is 04:15 AM. kjspear (Programmer) (OP) 8 Jul 05 19:50 I have a question about an error I received using VBA in MS Word XP . Join our community for more solutions or to ask questions. OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. http://www.tek-tips.com/viewthread.cfm?qid=1089487
Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We Join & Write a Comment Already a member? TonyJollans (Programmer) 9 Jul 05 13:42 Hi kjspear,I believe the Connection String can be a maximum of 255 characters - and yours is 260.
Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. Run-time error ‘9105’: String is longer than 255 characters The issue appears to be that the string value for the “Connection:=” property is more than 255 characters. Dim sFullPathAndName As String sFullPathAndName = fldrTarget.Path & Application.PathSeparator & fTarget.Name Word.Application.Documents.Open sFullPathAndName, ReadOnly:=True Sometimes when I then pass this string to Word.Application.Documents.Open and it is greater than 255 chars I Whats going on!??!?
VB: With wdApp.Documents("O:\Accounts\Gamma\GiftAid\GiftAidLettersTest.docx").MailMerge .OpenDataSource Name:= _ "O:\Accounts\Gamma\GiftAid\GiftAidTestingCSV.csv" _ , ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _ AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _ WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _ Format:=wdOpenFormatAuto, Connection:= _ "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=O:\Accounts\Gamma\GiftAid\GiftAidTestingCSV.csv;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLEDB:Registry For Bob, what is the full path/name of the DB? Login with LinkedIN Or Log In Locally Email Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find A Forum Thread Number Find An Expert Resources Jobs http://www.vbaexpress.com/forum/showthread.php?42199-Mail-Merge-String-is-longer-than-255-characters Find More Posts by boblarson
No, create an account now. vba ms-word share|improve this question edited Feb 23 '15 at 19:19 Deduplicator 28.8k63468 asked Sep 25 '09 at 9:33 Mongus Pong 7,85652968 add a comment| 3 Answers 3 active oldest votes It appears to be working fine now. You may have to register before you can post: click the register link above to proceed.
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. VBA Visual Basic https://www.experts-exchange.com/questions/25137721/Merge-from-a-Command-button-RunTime-Error-9105-String-is-longer-than-255-characters.html My sample code snippet below: '**Calling routine passes strDocName and queryString parameters** Set objApp = CreateObject("Word.Application") With objApp .Visible = True 'Make it visible - NB images in document header are i'm very keen on getting the 1st stage working, but any advice would be greatly appreciated. Find More Posts by boblarson 02-14-2008, 07:02 AM #4 Moniker VBA Pro Join Date: Dec 2006 Location: Dallas Posts: 1,567 Thanks: 0 Thanked 9 Times
It merges a letter in Word to an excel spreadsheet. http://sortoutlookemail.com/vba-error/vba-error-handling.html Please try the request again. Similar Threads copy cells with more then 255 chars... I rewrote my code to split the querystring into two parts but it still fails if the entire statement exceeds 255 chars (according to MSDN it _should_ accept up to 510
Excel Video Tutorials / Excel Dashboards Reports Reply With Quote March 21st, 2014 #6 snb View Profile View Forum Posts Banned Join Date 8th March 2010 Posts 1,651 Re: Trying to If you're having a computer problem, ask on our forum for advice. It looks like you've tried dropping the unneeded ones already, which is why I'm thinking the CurrentProject.FullName is going to be the culprit. Check This Out To start viewing messages, select the forum that you want to visit from the selection below.
boblarson View Public Profile Visit boblarson's homepage! Alien number systems - Are decimals special? So, maybe anyone have ideas? __________________ Free tools, code and samples here: To view links or images in signatures your post count must be 10 or greater.
Login. You currently have 0 posts. Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search ALWAYS run an up-to-date virus scan and disable macros.
Thank you !!! More About Us... If not, then I'll look in the morning when I'm more awake and caffeinated. __________________ ~Moniker (If you've been helped by me or anyone else, please add to their reputation by this contact form kjspear (Programmer) (OP) 11 Jul 05 16:11 Hello,Yes, I've shortend the string by eliminating some code as per Trevil and the others.
Thanks in advance for any ideas. Can someone help how to fix my macro with the provided solution ? Ian posted Dec 7, 2016 at 11:12 AM WCG Stats Wednesday 07 December 2016 WCG Stats posted Dec 7, 2016 at 8:00 AM MISSING what would you ? Now I need to figure out a workaround as the clients need this ASAP.
thread707-1089487 Forum Search FAQs Links MVPs Run-Time '9105' String is longer than 255 characters. Module2 is just an example from a search above which has parts you can use. If you don't like Google AdSense in the posts, register or log in above.