-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
addfromfile
-
P
VBA to Add Connection to Separate Workbook
I have 2 workbooks (Workbook A and Workbook B). Workbook A contains data and Workbook B has a series of pivot tables and pivot charts that are linked to that data. I'm trying to use vba to create the connection to Workbook A, refresh the data, then delete the connection. I'm running into trouble...- PGBrown
- Thread
- Replies: 1
- Forum: Excel Questions
-
H
Adding another VBProject as Reference
Hello! I have 2 files. File A will open FIle B at some point through code. I need file B to open and add the VBProject in file A as a reference. At the same time I need File B to remove that reference on the BeforeClose event. Both files are .xlsm and have their own VBproject I tried...- high42
- Thread
- Replies: 0
- Forum: Excel Questions
-
S
Coding for diff versions of "Microsoft ActiveX Data Objects" Library
I'm still having issues with an Excel spreadsheet with macro's... to make it multi-compatible for Office & Windows versions. In particular for ADODB in 'Microsoft Active X Data Object #.# Library' (C:\Program Files\Common Files\System\ado\msado*.dll) & mscomct2.ocx. I developed it in 2010 & am...- shell_l_d
- Thread
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Finding issue in If elseif else with For each Loop
- Started by Arunachaljois
- Replies: 57
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please... -
VBA to copy certain columns from multiple workbooks with multiple worksheet based on criteria into master workbook
- Started by nathanmav
- Replies: 51
Hi everyone, I would like to ask for help about the code I found and I tried to modify it but I'm not lucky to make it work. I have a total of... -
Frequent Text - Duplicates
- Started by SaraWitch
- Replies: 30
Hello all, I'm using the Index, Mode and Match array formula to show the most frequently repeated text. However, I wonder if there's a formula... -
Timer in VBA - Stop, Start, Pause and Reset
- Started by Anton1999
- Replies: 28
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub... -
how to updates multiple rows in muliselect listbox
- Started by jaym6939
- Replies: 26
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code... -
Multiple Case statements
- Started by davidausten
- Replies: 26
Im using a combo box to select the option. The thing I am having trouble with is that if you select the second case statement from the list (they...