Search results
13 gru 2017 · I am new to vba and I have been trying to open a PDF file with MS word 2016 in order to copy the data and populate cells in Excel, I have been able to open the PDF and copy the data but I have found it tricky to get the data I need and to populate the cells in Excel.
21 paź 2019 · I am automating processing of PDF files via VBA, but the problem I cannot seem to resolve is Word helpfully showing a dialog box regarding file conversion. I am looking for a solution which doesn't require modifying the Registry, as this is not permitted in the work environment.
9 lip 2022 · SaveAs. This Word macro will save the ActiveDocument with a new file name that includes the current time: Sub SaveMewithDateName () 'saves active doc in current folder as a filtered html and named upon current time Dim strTime As String strTime = Format (Now, "hh-mm") ActiveDocument.SaveAs FileName:=ActiveDocument.Path & "\" & strTime, ...
11 sie 2024 · This article discusses how to open a word document, modify and save it as a PDF file or a new updated word file (.docx) with VBA in Excel.
12 wrz 2021 · This example opens Test.wp using the WordPerfect 6.x file converter. Sub OpenDoc2() Dim fmt As Variant fmt = Application.FileConverters("WordPerfect6x").OpenFormat Documents.Open FileName:="C:\MyFiles\Test.wp", Format:=fmt End Sub
25 paź 2021 · I list the "new" filenames in column E. What I want to do is get Word to open those files, format it, then save as a PDF. This is what I have so far. I can get the first document in row 2 to open and format but cannot do anything further. Where have I gone wrong?
18 sty 2022 · Saves the specified document with a new name or format. Some of the arguments for this method correspond to the options in the Save As dialog box ( File tab). Syntax
