Am getting an 'object variable or With block variable not set' error on below part of my code to transpose a column of data in Excel. The error is happening on this line:
.Range("D1").Select
Any ideas what I'm doing wrong? Thank you.
With xSheet
Range("A1").Select
Range(Selection...
I am following the instructions in this link to Bind an Access Form's Record Source from an XML File at Runtime, http://msdn.microsoft.com/en-us/library/aa167814%28office.11%29.aspx#footerLink, but after creating the form and destination table, the results don't seem to be binding to the form...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.