Tagged Questions
3
votes
1answer
187 views
Export Access Table to dBase file from Excel VBA?
I have an Excel "Application" where users add/edit/etc. data. When ready, they export this data, the final deliverable needing to be a dBase file. Since Excel 2007 no longer has the Save As dBase ...
0
votes
1answer
23 views
Stopping NULL Rows and Columns to get imported from excel to access
I am importing some table from excel to access.Sometime some blank columns also are imported as field13 or field-x .
Whats the reason for that.
Also sometimes some blank rows are imported also.Is ...
0
votes
0answers
69 views
Visualize relationships between entries in a database
I'm looking for a way to visualize the relationships between our suppliers by drawing a dynamic graph.
Our suppliers may have one or several addresses (branches). Each branch may have one or several ...
0
votes
1answer
23 views
How to assign Single cell to range?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim TxtRng As Range
Set TxtRng = ActiveCell
If Not Intersect(Target, TxtRng) Is Nothing Then
------------Statements ...
0
votes
0answers
180 views
Checking if a access table exists in Excel vba( dlookup or using sql)?
how to check if table exist and if it doesnt exist create table in sql server 2008
The link above I think shows what I am trying to do using sql in excel vba. I should say I don't really know sql, ...
6
votes
3answers
11k views
Connection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect
I'm trying to connect various VBA projects to an Oracle 10g back end using ADO (2.8) and no TNS. After various attempts, we've decided that the simplest series of steps for a clean installation ...
0
votes
2answers
183 views
Setting range properly in DoCmd.TransferSpreadSheet (VBA Access in Excel)?
For Each Page In Worksheets
PageName = Split(Page.Name, " ")
If UBound(PageName) > 0 Then
Worksheets(Page.Name).Activate
LRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
...
1
vote
1answer
51 views
VBA to insert embeded picture excel
I have seen lots of posts about us xlApp.activesheet.Pictures.Insert(strImagePath) to insert pictures into a spreadsheet with VBA, which works great. The only problem is it inserts it as a linked ...
0
votes
1answer
100 views
VBA error on PageSteup.PrintArea when using Excel 2007, works fine in Excel 2003
I've inherited responsibility for a web app that uses Access for the database and Excel for the reporting (lucky me, I know). Everything has been working fine with Office 2003, however the company ...
13
votes
2answers
39k views
Loop through files in a folder using VBA?
I would like to loop through the files of a directory using VBA (Excel 2010). In the loop, I will need the filename and the date at which the file was formatted.
I have coded the following which ...
1
vote
1answer
516 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 = baza.CreateQueryDef("", ...
0
votes
1answer
39 views
Cannot save file after upgrade to 2007 VBA
I have a sub which I call to save a file
Sub SaveToFile()
maxr = Worksheets("List").Range("H1")
Worksheets("List").Range("G1:AE" & maxr).Copy
Part of the code which is failing after ...
0
votes
0answers
250 views
Use file name variable to open Excel 2010 file from Access 2010
I need to open Excel 2010 files from Access 2010 by using a variable for the Excel file name. I can't quite figure out how to format the variable names for the file and sheet that need to be opened.
...
0
votes
1answer
147 views
Complex Import/Export Data Access/Excel
Our organisation has been given a spreadsheet template to do batch imports to a website.
It's quite a faff for users to update as it's structured all on a single page in the following way:
| ...
0
votes
1answer
516 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 ...
