Search results for query: *

Thank you for the streamlining of the code and advice on proper place to post, I will do that in the future. Thanks.

Thanks, I've modified it and here is the entire code. The error message is the one about copy/paste area not being same size and shape, to click on a single cell then paste. I tested it on a smaller dataset and realized I believe the rows I am copying to transpose will exceed the number of...

Thank you - getting closer, that helped, and now it is stopping on below line. It's copied the column, moved to the cell I need, but not pasting. What have I done wrong? Thanks again for your help. Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _...

Thank you - xSheet is dimmed As Worksheet. I am not sure how to answer, so sorry. I've gotten this far with a mix of recording macros and help menus and googling to find code. In this case I used the macro recorder to see what would happen if I copied a column from the top of the data to...

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...

Just a follow-up to see if anyone has ever tried this or has a way to import the xml and somehow create the ID field that's needed to tie all the tables together when you import a complex/nested xml file. Thanks.

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...