-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
vbcomponents
-
Y
Export macro with location referenced in Cell
I have written this macro below. I get an error on the Workbooks(ThisWorkkBook).VBProject.VBComponents("Module1").Export strTempFile. How do I define this? Sub CopyModule() Dim wb1 As Workbook Dim ws1 As Worksheet Dim Path As String Dim FName As String Dim wb2 As Workbook...- YolandaCB
- Thread
- copymodule vbcomponents vbproject
- Replies: 0
- Forum: Excel Questions
-
K
Finding the line number of code using code with VBA/VBIDE
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...- Kmanbozzy
- Thread
- codemodule line vbcomponents vbe.vbproject vbide
- Replies: 1
- Forum: Excel Questions
-
M
Change Code using VBA
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> <o:p></o:p> I got this from the following thread. <o:p></o:p>...- mond007
- Thread
- change code using vba codemodule vbcomponents vbe.vbproject
- Replies: 0
- Forum: Excel Questions
