Tagged Questions
1
vote
1answer
155 views
Importing data from Excel into Access using DAO and WHERE clause
I need to import certain information from an Excel file into an Access DB and in order to do this, I am using DAO.
The user gets the excel source file from a system, he does not need to directly ...
1
vote
1answer
175 views
System Information via VBA code
I was wondering if there is any way to retrieve System Information via VBA code?
Is there such a class as - SystemInfo Class in Excel VBA to do this task?
thanks
1
vote
1answer
384 views
VBA to write data into excel used by multiple users on a network?
Basically i have a master workbook on a network drive which is used by many to update the sheet,i want to automate this , through my research i found there are many complications with it if i automate ...
0
votes
1answer
254 views
MS Access VBA linking data and updating records from excel
What is the best approach to updating records that are saved in an excel file. For instance I have a MS Access database with a table in it that has Product ID, ProductName, and ProductAge. I have this ...
0
votes
1answer
132 views
slow exporting array from access to excel
I have a similar performance issue to that in slow exporting from access to excel, exporting data to MS Excel by setting individual cell values looping on:
objSheet.Cells(table_1_row_no + intcounter, ...
0
votes
1answer
339 views
Comparing fields between excel and access and fill
What i wanted to know is how do i get a vb application reading an excel file and a access database at same time, make them compare the fields and fill fields that are null.
for example:
Excel has ...
0
votes
1answer
772 views
Copying data from a MS Access form into Excel
I have code that takes fields from a MS Access form and copies the data into a saved Excel file. The first record in Access in imported to Excel with a range of A2:I2. The second record in Access is ...
1
vote
0answers
23 views
VBA Excel - UPDATE record in ACCESS
I got a problem.
I want to update an existing record in table in Access Database using VBA in EXCEL.
My code:
sqlik = "UPDATE query which works in access"
Set ZAP_QUERY2 = ...
1
vote
0answers
423 views
Adding a format condition in Excel through Access VBA
So currently i got these lines in my code,
.Range("C2").Formula = "=IF(B2 = """"," & """REQUIRED""" & "," & """""" & ") "
.Range("C3").Formula = "=IF(B3 = """"," & """REQUIRED""" ...
0
votes
0answers
44 views
Unable to connect to Access database with ADO
I need to import a bunch of tables stored in .txt files into an Access database. When they are done importing, I use an ADO connection to communicate between the database and an Excel workbook. I have ...
0
votes
0answers
97 views
How to read (query), format, and export a sheet to a existing XLS, in a Access/VBA application?
I have an introductory (?) question about Access/VBA to xls exporting.
Here is my scenario:
We have an Access database and a form (created in the Access environment) with some buttons where the user ...
0
votes
0answers
163 views
how can I control an Excel OLE object from access with vba
I would like to have an access vba procedure to write in an embeded Excel sheet.
I've added an Excel Ole Object to my Access form, but I'm unable to address it.
How shoud I do that ?
0
votes
0answers
251 views
Link cells in Excel to Access table fields
Consider I have a macro in access 2003 that uses the transferSpreadsheet function to export a Union query to a excel 2007 spreadsheet; the exported data depending on a date range input by the user.
...
0
votes
0answers
84 views
ADOX.Catalog.GetObjectOwner => VBA vs. DB2
I'm using VBA to query a DB2 database. I would like to get the Object owner of a couple of tables using the ADOX Catalog object. This doesn't seem to be supported? Would anyone be able to confirm that ...
0
votes
0answers
886 views
Automate sending emails in VBA via Outlook Web App
Is there a way to send automated emails in Excel/Access VBA using Outlook Web App?
