Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Loop Through a folder, and clear all word documents formatting from Excel.
Hello Fellows, I want to Loop through a folder and remove all formatting of MS Word documents from Excel. I am using below attached code, but it's not working. I am stuck with actual command execution. Please help me in this regards Thanks Sub clrfmt() Dim wdapp As New Word.Application...- umxir
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Getting MS Word file name along with Paragraphs into Excel
Hello Fellows, Using below attached VB code to extract few starting paragraphs from Word into Excel. Working great. Now, I also want to include the word file name to be extracted from where the paragraphs has come. Please help me as I am totally newbie here. Sub getWordData() Dim wdApp As...- umxir
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Loop through a folder, Copy (first few lines) data from .docx, Paste into individual rows (Excel)
Hi, Totally newbie here, please bear with me. I need to copy a specific data from multiple word documents/files. All files are in a single folder. The contents of the Word Documents are not in a specific format. No specific marks or anything to distinguish required data from the rest of the...- umxir
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
