Nov 1, 2008 · So if you want to read the vba of an excel file, the file has to be opened. You can use Excel for that and look at the code the normal way, or if you know the structure of a spreadsheet than you can write your own application to just extract the vba. Or you can look at it with a hex editor.

Dec 13, 2010 · I have tried view code, Double clicking on the module, Right click view code. When I double click the VBA project title nothing happens either which is strange (Normally you get a box appear where you can lock the project). Hopefully someone has a way that I can get the code back as there is quite a lot of it. Thanks Dean

Feb 28, 2003 · Double-click on the folder called MICROSOFT EXCEL OBJECTS. You will see a FULL list of ALL the worksheets in the workbook. Locate the sheet called "dsheet" and click on it. Make sure that the PROPERTIES window is visible (if it isn't, go to VIEW in the main menu and have it checked.) Look at the VISIBLE property for the worksheet.

Jul 21, 2002 · click the view , project explorer. Look for the directory module and double click it. However, if it is password protected, you will not see your module. trying double clicking the vbaproject and type the appropriate password. If you don't know the password, i can't help you.

Apr 28, 2010 · I copy code from one macro to the other macro in a different workbook. However, I can't open VBA editor windows for the two different workbooks side by side simultaneously. I need help

Aug 26, 2023 · Option Explicit Dim wksSource As Worksheet Dim rngData As Range Dim rngCell As Range Dim LstItem As ListItem Dim RowCount As Long Dim ColCount As Long Dim i As Long Dim j As Long 'listViw Initialize Private Sub UserForm_Initialize() With Me.ListView1 .Gridlines = True .View = lvwReport End With pData End Sub 'Loading Data to listView Sub pData() Set …

May 23, 2010 · Thanks, Dave. When I do that, I can see the VBA Project for the workbook. Under that are the Microsoft Excel Objects (14 sheets plus This Workbook) and Modules (Module1 through Module5). As I click each one, I'd expect to see the macro appear on the right, but each of the Objects and Modules appear to be empty.

May 28, 2018 · Hi, using Office 365. I have a workbook I am building and the macro I wrote isn't showing up in the view macros box. I've tried viewing by name and by "this workbook". The Personal workbook and all it's macros show up just fine. And, if I go to the VBA editor I can see (and run) the macro from there.

Jul 6, 2005 · Sub MakeXLS() Dim wsNew As Worksheet Dim strCopyNode As String Dim i As Long With frmTreeView.TreeView1.Nodes For i = 1 To .Count If .Item(i).Selected = True Then strCopyNode = .Item(i).Text '<-- returns node value Exit For End If Next i End With Application.ScreenUpdating = False Set wsNew = ActiveWorkbook.Worksheets.Add With …

Feb 12, 2003 · In the VBA window how can I check the current value of one of the variables in my code? ... Open the View ...