-
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.
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
- add connections addfromfile vba
- 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
- add addfromfile code reference vbproject
- 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
- addfromfile addfromguid adodb msado15.dll reference
- Replies: 2
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
