binding

  1. R

    Late Binding: extract Access to Excel with formatting

    Hi all Situation: I'm extracting an Access query to Excel with VBA. In this excel, I let VBA do a few things like formatting the cells. I made the code work and the sheet looks good, but I'm not sure if it's all versions proove. For my code I have put a check in the references at 'Microsoft...
  2. B

    What is early binding and late binding

    Hi I am new to these concepts. Not requesting for exact answers. You may also help me with useful links for these two. I know Google will help, but trying to seek help from experts here. Also, I have another question here. Not sure if I can merge it here only. How does early binding or late...
  3. C

    Error in Loading DLL while using late binding (Outlook)

    tl;dr - Converted from early to late binding to email a report using Outlook, now getting "Error in Loading DLL" Good morning! I developed a tool for our production operations that automatically generates an email when a report is run. It was working fine for me using early binding, but then I...
  4. T

    File System Object late binding

    This code works in early binding: Dim fso As Scripting.FileSysemObject Set fso = New Scripting.FileSystemObject Dim MyFolder As Folder Set MyFolder = fso.GetFolder("C:\MyData") Dim Num As Integer Num = MyFolder.Files.Count To change to late binding, how do I declare MyFolder? For...
  5. R

    Microsoft word Object Early/Late Binding

    I write code at home and work. Home computer needs Microsoft Word 15.0 Object Library. When I program at work the reference changes to Microsoft Word 16.0 Object Library. Then the program hangs when back at home. After searching I learned that I should use Late binding. The problem is that in...
  6. K

    Const values for late binding declarations

    Hello Everyone! I am looking for a complete list, if it exists, of all MS Office application function’s constants values. I want to be able to use late binding, but in order to do so, I need to declare all application specific functions as a Const like in the example below. Const...
  7. Dr. Demento

    CC'ing self

    Using early binding, I have automated a batch of weekly emails; however, since I won't always be the one sending them, I wanted to insert code that would automatically include the sender in the CC line. I've found the code below online, but all the examples seem to use late binding (or more...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top