I have a macro which theoretically works perfectly but I think it is creating unnecessary processing and calculation requirements which then crashes the file. I
I am a newbie to vba code but have had some marginal success with basic macros for changing the format of tables, text and photos within Word documents. I have
I built a VBA Sub that matches an input string with the equivalent string within a large array and returns a specific string which is bounded to the matched str
I am new to the forum and VBA codes. I have been searching for an answer to this question and am completely lost. I have a workbook that contains around 36 work
I have a VBA User defined function which takes multiple range references for using it in the code. My problem is when I try to use a particular range reference
so i'm trying to use a macro to look in sheets one code and paste the information of that code , I'm trying to use a simple macro with advanced filters to do th
I was using selenium with VBA and there is the current webpage. I was trying to get the bot to select the "exportbutton" ID, but I have already tried Findelemen
I'm a VBA NewBe (this is my first post asking a question on any VBA help site) working on a Property/Expense Management application in excel. the ComboBoxes in
'For the most part, I understand how arrays work but apparently not multidimensional ones in VBA. Below is a simple subroutine in which I want to debug.print/ac
I have downloaded some data from Sharepoint in *.iqy format (this is the only format in which the data can be downloaded). Post this, I perform the following st
My aim: I have a subform in a form and I want to pick up the value of one field in a user selected record in the subform and populate a field in my form using t
i want to make a connection with a DBF file through VBA, i have installed all the drivers but i get this error message every time i try to run it Object variab
I'm trying to mark messages, copied from within an Outlook subfolder to Inbox into a file system folder, as read. Sub demo1() Dim objNS As Outlook.NameSpace
I am a real novice at VBA, so any help would be welcome. I am trying to convert certain ranges across multiple sheets into only one file. I have written code fo
I am trying to generate some code that will open up an excel file on Sharepoint and copy data into another spreadsheet. I have been using the below code when th
I'm trying to make a button in Access, that will open Visio and launch a Data Wizard to create a diagram. I've tried various solutions, but all I get is opening
Im working on creating an macro that will pull data from a specific group of ranges across many files in one folder and feed that data into a master file in the
I have an Excel sheet that has a connection to SQL server to generate some table data into the spreadsheets. There is a strange issue where the spreadsheet get
I have an Excel sheet that has a connection to SQL server to generate some table data into the spreadsheets. There is a strange issue where the spreadsheet get
I have 1 workbook with multiple sheets and I am running into an issue copying over data from one sheet to another. Sheets - "ALL CONTACTS" & "MAA DATA" Ther