I have written this macro below. I get an error on the Workbooks(ThisWorkkBook).VBProject.VBComponents("Module1").Export strTempFile.
How do I define this?
Dim wb1 As Workbook
Dim ws1 As Worksheet
Dim Path As String
Dim FName As String
Dim wb2 As Workbook...
Basically i want to use a macro to search another macro to return the line number of the particular code i'm looking for. The problem is, codemodule.find() has no other valid qualifiers to tag on the end such as .line or .row (codemodule.find().line) This is the general concept i would like to...
I am trying to change hundreds of workbooks using VBA. I have a main drivers workbook with the following code.. in a simple file processing loop.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
I got this from the following thread. <o:p></o:p>...