library

i have been using the below code to set the refererence to the scripting run time library - Application.VBE.ActiveVBProject.References.AddFromFile "C:\Windows\System32\scrrun.dll" Is there a way to remove the reference with a code?

I have copied data contained 4 columns from Adobe Acrobat Reader into Excel, while pasting into excel its showing all data in single column, please help me to bring data into columns in excel or give other solution. <tbody> Adobe Acrobat Reader Table Name Description System...

Why is it so difficult to just add this to the library?

I created a new macro the other day and it was working fine. Today when I attempted to open it, i received the error "Can't find project or library" immediately when opening the sheet. I found the support on the microsoft website indicating to: Open your database. Press ALT+F11 to switch to...

I am using Excel and Word 2013. I have the reference library with these references active (checked): Visual Basic for Applications, Microsoft Excel 15.0 Object Library, OLE Automation and Microsoft Word 15.0 Object Library. My problem is when I run the code: Dim wordApp As Word.Application...

Hi, I believe I am using office 16, when looking up the above library in the reference library, I can find no mention of outlook at all. Is it called something different?

I am getting message that I am missing a library when I open one of my reports. I never got message before and very similar older report I do not get message. Does anyone know how I would find out what library I am missing? Need to send report out this morning. Really grateful to anyone who...

Hello everybody. I'm navigating IE via VBA to reach a web site and download a file. No problem about navigating the site, neverthless I can't interact with the popup “Do you want to open this file?” (I use IE9). So, I've tried to travel the API road for the first time in my life in order so...

Afternoon all, I have several files that open perfectly on my machine but when a few others open, it causes theirs to crash. The file is set up in office 2016 and the person who is having the problem is using Office 2015. I notice in my project library that I have Microsoft Office 16.0...

Hi All, I currently am tasked to find out from a SharePoint library which consists of thousands of Excel documents, the names of the files that contain a phrase "Fail" in one of the columns. The files are very large (contain a lot of rows of data inside them), and hence instead of opening...

Hi, My Personal.xlsb file was working absolutely fine yesterday, now today it doesn't automatically open when opening Excel although it's in my xlstart folder and when I try to manually open it, it brings up a Can't find project or library error message and then crashes. I've tried to locate...

Hello. I'm triyng to use Excel connected with Firefox. I've already downloaded Selenium Ide 2.9.1, but I can't find the library (ALT+F11, Tools and then References). I use Microsoft Office Excel 2007 and Firefox 46.0 Any ideas? Thank's.

Hello I've been experiencing a tricky vba problem to which I can't find the solution on Mr Excel or anywhere else... I have an Excel file which opens an Outlook session and builds an email with the TO, CC, and BCC names populated dynamically based upon my selections in the Excel file. 50% of...

I got some solid advice on setting up data connections and using late binding; I've had almost no issues since then. However I have one user who is unable to run a small section of code that basically INSERTS into a database. The error message is: Run-time error '-2147024770 (8007007e')...

I have 2 sets of data that I need to compare, each set is roughly 500,000 rows. I tired to do a vlookup but it was taking far too long to complete (30+ minutes before I cancelled it) I've been reading that I want to use a scripting library to accomplish this, but I cant quite figure out how...

Hello everybody, This is my issue below. I created a macro that creates files. These files are uploaded to a SharePoint library. In this library, 2 variables have a mandatory required field: "Code_File" et "Codes_Countries" : * "Code_File": one-dimensional variable with type of files values...

Hello I have an document with modules locked and i have to share it. Other users have to add some references but when modules are locked, "VBA > Tools > References" is not available. Can you help me please ? Thank you G

Hi all, I have an Excel spreadsheet which has an option to send certain data from it via an email in Outlook simply by clicking a user form button. I have set the Library Reference to "Microsoft Outlook 15.0" and tested the code and all works OK. I have three questions though:- 1. If I send...

Hi everyone. part of my job is to deliver training to new starters and we have lots of different training we can offer. each training session needs various documents containing training material, to which i need to physically open and print for each new starter. it's sometime difficult to...

Not sure what title to put on this, because the macro I was using was working just fine, until all of a sudden it wasn't. Go figure. Basically I have a workbook with several pages of spreadsheets. The first page is titled "Reporting", the rest are titled by Month and Year ("August 2013"). I also...