![]() ![]() Choose This PC or Browse to find the web page you just saved, and click Open to. Then open Microsoft Excel and click File Open. After finishing editing it, click File Save or directly hit the Save button to save the document as Web Page (.htm. If you don't want the blank line, then remove or comment out the line just before the Next statement. As an example, I open a new document in Word and create a new table. (The source document is whatever document was active when you ran the macro.) The macro places a blank line between each table in the Target document. Or add custom functions, menu items, and macros with Apps Script. The macro, once run, creates a brand-new document (Target) and copies the tables from the original document (Source) into the new one. While there is no built-in option in Excel to convert an entire Excel file to Word, you can easily copy and paste the data from an Excel document to Word. Sub GetTable4() ' ' Dim XLSheet As Object Dim Wbook As String ' Create Sheet object Wbook ThisDocument.Path
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |