vba & excel to access

Hey All! I have an Access 2016 database that I want to use VBA in the database so when it opens it updates the table data with data in an excel spreadsheet in a different network folder. this has to be automated for the user. let's just start with a table named "Summary" and I can go from...

Hello Friend, Thank you for your willingness to help! I am new to VBA coding and I've been assigned a task to maintain a pre-developed access vba tool. while running the code is getting stuck at a particular line where the LDAP serch object is declared. (error msg: Runtime error 429, Active...

Hello I have an Excel sheet connected with controller, its not close (24 H running) and updated every some times with new data, i need to export all data as PDF or XPS automatically every day at 12:00 AM :confused::confused: without i close the original file or touch it:eeek:. so could any one...

I need to graph 2D stacked area graphs, so this is how I am trying to do it. I'm using Microsoft Access exporting with VBA into excel and trying to create a 2d stacked area graph based upon two different imported tables. The best part, is I need a separate graph for each row of data being...

I found this code that splits column data in sheet1 and creates a 2nd tab with the data. However I have spent all day trying to amend the code to include with the row data in that column that contains "Category" & "Store" & "SEL". I think this is the line of code that needs amending to factor...

I have an automated (VBA) Excel 2007 sheet to allow employees to enter parts request information. When they are finished, they click a <SAVE> button which does the following: 1. Saves the file by a specific filename based on user data entered in several cells. 2. Sends me an email with pertinent...