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
Sub Copy_Worksheets_Columns_Rows_to_ALL_D2() 'PURPOSE: To loop through all Excel files in a user specified folder and perform a set task on them 'Task:
Sometimes I need to open a file that is already open, and I would like to close it. For that I need to know which machine on the network has it open. How would
Thank you in advance, I need help in completing the below code, the code currently works to add the number of rows in the Table(3) of my word template as per th
I have a project with a number of instances of DoCmd.Hourglass -1 <various code> DoCmd.Hourglass 0 <other code> Any time there