Search results for query: *

Paul Edstein, Seems your mind is totally negative about my work regardless of what I am doing here. As a result, I prefer to respect your mind and to stop asking more questions in this thread. Thank you for the opportunity that I have experienced in this forum to get my answer. SkipVought...

SkipVought, No unfortunately, it is a long process because of security purposes. do you have any substitution for sConn = "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};" in your mind? so I don't have to use the ODBC driver.

Paul Edstein, If you take a look at your answer, you told me "I am not going to waste my time... a simple web search would turn up lots of code for exporting content from Excel to Word tables." How you expect to receive an reply when you kick me out? I asked my question since I've never found...

Please find the attached file. As you will see there are 4 tables in the Excel file (A1-C46, A48-C75, A77,-C104, AND A106-C133) imported from 4 Word-tables. Those ranges are actually table1, table2, table3, and table4. My question is how to replace word tables with the excel ranges? for example...

Thank you very much for your explanations and the details. 1. WorksheetFunction.Clean removes all nonprintable characters from text. 2. resultRow is not equal to iRow since “For icol” acts under “For iRow” 3. Copying the ref table into I:K on Sheet1 is just for visualization purposes. When I...

SkipVought, I requested to install the Connector/ODBC driver since 9/5/2017 but unfortunately it takes time to approve by all managers. Until then I would like to show you my Excel VBA as we discussed already. Attached. I hope you still have the Word file including the tables, so you can test...

Nice! I am an electrical engineering major at Drexel. Here is my LinkedIn profile: www.linkedin.com/in/atamodiri In case of excel I'm using a Word VBA to paste all tables in excel, then I use my own Excel VBA to revise the pasted data based on the ref table. Then I have to replace (manually)...

Thank you! I'm glad to have a professional friend like you :)

Actually, my experience in writing word VBA is almost nothing. But in case of excel although I'm not professional, I did a lot of Macro (record/VBA) to facilitate some processes(data analysis). I'm not sure how much symbols, objects, methods,... are common between excel and word. However, I do...

That would be great, thanks!

You are awesome!!!! Worked finally[afro2][thumbsup2] I hope it works at my office too after installing the driver. Finger crossed.

At home I get this error, do you think I need to try the drivers? My system: Windows 10 home, 64x, Microsoft Word 2016.

thank you for your help, first of all I see two files to download for Windows(x86, 64-bit), which one you mean? second, unfortunately it's after business time and I cant get the permission to install the deriver. Also I'm getting ready to go home and I will back on Tuesday. However, I will check...

I just mailed that to you.

I also went to the C:\Program Files (x86)\Common Files\microsoft shared\OFFICE16 to find the ACEODBC.DLL, but there was nothing. Then I downloaded a ACEODBC.DLL from the website bellow and I put that into the location. Now I get the following error instead...

didn't work :(

I did. I still get the same run-time error.

I cant select any of Microsoft ActiveX objects, I get the following error after click on OK. this is my last update which accepted

there are hundreds of references to check, if you think that should be done, so I'm starting to do that. Here is what I checked before:

I did, now I get another error