Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Need Help with getting DAO to work in VBA Project in Excel 2013-64 Bit

05 Jun 2017   #1
kleaverjr

Windows 7-64
 
 
Need Help with getting DAO to work in VBA Project in Excel 2013-64 Bit

0 down vote favorite


I have searched using google to find a specific answer with no luck. I keep getting error code 429 when trying to use DAO language "OpenDatabase" so I can use SQL Language to search various worksheets in one Excel 2013 Workbook. I am running Windows 7-64 and Office 2013 64-bit. From what I have read, it would appear DAO is not supported anymore by Microsoft, and even ADO doesn't look like it is looked favorably by the folks at Microsoft anymore. I really don't care if I can't use DAO anymore as long as if there is a method where I can use similar functionality to find specific records based on specific criteria, amend certain records, create other records, and move amongst records (i.e. .movefirst, .movelast, etc.). If there is a different VBA language that is usable for 64 bit versions of my software, I will learn it.
I rather not use the workbook, worksheet functions and using IF-THEN statements going through the entire table trying to find certain "records" that match the criteria I am looking for. It works, but its tedious and I much rather use SQL type language.
I realize using MS Access would be more appropriate, but I prefer using the Spreadsheet format. What I am trying to do is write a VBA program that converts certain cell values into a certain format to be converted to a csv file to upload to a website for my web-store. The file is my inventory sheet, with tons of calculations/formulas in it. I rather not use MS Access if I don't have to.
Thank you for any help that can be provided!
Thanks.
Ken L.


My System SpecsSystem Spec
.
07 Jun 2017   #2
HiTechCoach
Microsoft MVP

Windows 7 Ultimate x64
 
 

FYI: Access can link to the Ecel workbooks as tab;es. Youc an easily query and export to do what you need with Access using the excvel data.\

Note: I use Access are a Report Writer for Excel data.
My System SpecsSystem Spec
07 Jun 2017   #3
HiTechCoach
Microsoft MVP

Windows 7 Ultimate x64
 
 

Ken L.,

FYI: Access can link to the Excel workbooks as tables. You can query the excel data easily. With Access, tou probaly can do it what yu need with only aquery and NO VBA code.

Note: I use Access are a Report Writer for Excel data.

Quote   Quote: Originally Posted by kleaverjr View Post
If there is a different VBA language that is usable for 64 bit versions of my software,
No.

AFAIK, Micosoft is the sole owner/provider/creator of Visual Basic for Applicatoins (VBA). There is only one core VBA engine for 32-it (mature) and one for 64-bit (new). Each Office Applicaiton has the same core VBA with additional functionalityadded based on the application's object model needs.
My System SpecsSystem Spec
.

Reply

 Need Help with getting DAO to work in VBA Project in Excel 2013-64 Bit




Thread Tools




Similar help and support threads
Thread Forum
[HELP] Programming in Excel 2013
Hi Guys, Let me start off by stating that I'm still trying to learn all the juicy functions you can do with Excel, and I've just gotten myself a little project where I think I can learn but I need some kind of help from you guys. Basically what I'm trying to do is somehow automate a creation...
Microsoft Office
Office 2010 Pro compatible with Project 2013
Hi, I've checked the archives but can;t find a relevant thread. I currently have Office 2010 Pro on my laptop and am going to be purchasing MS Project. But am unsure which version is the safe bet. Can I install Project 2013 on a laptop running Office 2010 or is that going to be a problem and...
Microsoft Office
Excel 2013 - how to keep a formula consisten
Hi I am trying to tie one cell into a formula that is being pasted into multiple rows. I know you can use $ to keep the cell consistent but it doesn't seem to be working. So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the...
Microsoft Office
MS Project 2013 Installation/Deinstallation Menu appears on every boot
Hello all! I have MS Office 2010 installed and additionally MS Project 2013 Professional. Both are working fine, except that the installation/deinstallation menu of project 2013 is appearing on every system start. (I use windows 7 Professional by the way.) I had some similar issues with visio...
Microsoft Office
OFFICE 2013 X-64 some EXCEL addins don't work
Hi there I have some EXCEL addins mainly for getting stock data in real time (or almost real time) from places like CBOE (chicgago board of options Exchange etc). Use a lot for Options trading etc. When I try and install I get message : EXCEL IS NOT INSTALLED. Major Showstopper for me...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 14:54.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App