OberonPlace.com Forums  

Go Back   OberonPlace.com Forums > Developer Forums > VBA > CorelDRAW/Corel DESIGNER VBA

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 16-03-2013, 20:16
olympiatr's Avatar
olympiatr olympiatr is offline
Junior Member
 
Join Date: Oct 2009
Location: izmir
Posts: 14
Send a message via ICQ to olympiatr Send a message via MSN to olympiatr Send a message via Yahoo to olympiatr Send a message via Skype™ to olympiatr
Default x6 vba 7.1 excel connection problem

hi all,

it was workin on x5, codes are like that;

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & ExcelAdi & ";" & "Extended Properties=""Excel 8.0; HDR=YES;"""

but now in x6 x64 v. (x64 win 7 based machine) not workin. any idea?

regards
Reply With Quote
  #2  
Old 17-03-2013, 13:23
SteveDude SteveDude is offline
Senior Member
 
Join Date: Dec 2005
Location: Salina, Kansas USA
Posts: 149
Default jet

It's my understanding Microsoft's Jet Engine is not supported in x64. I'm not that familiar with its use in VBA, but in other languages it can only be used when apps that are built as 32 Bit.

There are alternatives in .NET, but I am not familiar with what VBA supports.

May be wrong but my guess is it will work fine in the 32 Bit version of X6 along with the 32 Bit version of office.
Reply With Quote
  #3  
Old 18-03-2013, 14:07
olympiatr's Avatar
olympiatr olympiatr is offline
Junior Member
 
Join Date: Oct 2009
Location: izmir
Posts: 14
Send a message via ICQ to olympiatr Send a message via MSN to olympiatr Send a message via Yahoo to olympiatr Send a message via Skype™ to olympiatr
Default thnx

hi Steve,

thnx for interesting. i will try over x64 (i have to)
Reply With Quote
  #4  
Old 19-03-2013, 10:05
SteveDude SteveDude is offline
Senior Member
 
Join Date: Dec 2005
Location: Salina, Kansas USA
Posts: 149
Default 64 Bit Driver

You might take a look at this link...

http://www.altova.com/Access-Databas...bit-64bit.html

I can say that you will need to work with x64 to x64 Excel. Not really a way for a 64 Bit app to connect to a 32 Bit one.
Reply With Quote
  #5  
Old 19-03-2013, 19:31
shelbym's Avatar
shelbym shelbym is offline
Senior Member
 
Join Date: Nov 2002
Location: Cheyenne, WY
Posts: 1,782
Blog Entries: 11
Send a message via ICQ to shelbym Send a message via AIM to shelbym Send a message via MSN to shelbym Send a message via Yahoo to shelbym
Default Excel Connection

Using 64bit CorelDRAW and 64bit Excel you can use:
Code:
    cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
             "Data Source=D:\Temp\Sample.xlsx;" & _
             "Extended Properties=""Excel 8.0; HDR=YES;"""
-Shelby
Reply With Quote
  #6  
Old 20-03-2013, 15:30
olympiatr's Avatar
olympiatr olympiatr is offline
Junior Member
 
Join Date: Oct 2009
Location: izmir
Posts: 14
Send a message via ICQ to olympiatr Send a message via MSN to olympiatr Send a message via Yahoo to olympiatr Send a message via Skype™ to olympiatr
Default thnx

Thnx dear friend, i will try over it. Thnx for interest.
Reply With Quote
  #7  
Old 20-03-2013, 15:47
SteveDude SteveDude is offline
Senior Member
 
Join Date: Dec 2005
Location: Salina, Kansas USA
Posts: 149
Default The only bummer...

Quote:
Originally Posted by shelbym View Post
Using 64bit CorelDRAW and 64bit Excel you can use:
Code:
    cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
             "Data Source=D:\Temp\Sample.xlsx;" & _
             "Extended Properties=""Excel 8.0; HDR=YES;"""
-Shelby
The only real bummer about this is, if a user has a 32 Bit version of office installed, it has to uninstalled for the 64 Bit OLEDB driver to work or even be installed. The only way around this I have found is by using SQL Server.
Reply With Quote
  #8  
Old 20-03-2013, 15:48
olympiatr's Avatar
olympiatr olympiatr is offline
Junior Member
 
Join Date: Oct 2009
Location: izmir
Posts: 14
Send a message via ICQ to olympiatr Send a message via MSN to olympiatr Send a message via Yahoo to olympiatr Send a message via Skype™ to olympiatr
Default hi again

Quote:
Originally Posted by shelbym View Post
Using 64bit CorelDRAW and 64bit Excel you can use:
Code:
    cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
             "Data Source=D:\Temp\Sample.xlsx;" & _
             "Extended Properties=""Excel 8.0; HDR=YES;"""
-Shelby
appears error:

couldn't find provider. may not installed correctly (surely i changed the excel address in your code. my corel v x6 and machine W7 x64)

Dim cnn As New ADODB.Connection
cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=c:\Tunc\Knorr.xlsx;" & _
"Extended Properties=""Excel 8.0; HDR=YES;"""
Reply With Quote
  #9  
Old 20-03-2013, 15:50
olympiatr's Avatar
olympiatr olympiatr is offline
Junior Member
 
Join Date: Oct 2009
Location: izmir
Posts: 14
Send a message via ICQ to olympiatr Send a message via MSN to olympiatr Send a message via Yahoo to olympiatr Send a message via Skype™ to olympiatr
Default hi Steve,

Quote:
Originally Posted by SteveDude View Post
The only real bummer about this is, if a user has a 32 Bit version of office installed, it has to uninstalled for the 64 Bit OLEDB driver to work or even be installed. The only way around this I have found is by using SQL Server.
i think office is 32 bit. i will try over x64 office then. thnx for interest.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Working with Excel nic CorelDRAW/Corel DESIGNER VBA 3 03-05-2010 09:00
msgbox over network connection... bprice CorelDRAW/Corel DESIGNER VBA 4 29-08-2008 07:20
Embedding 2007 EXCEL Flow_FX Feature requests/wishlist 0 27-03-2008 13:35
Excel worksheet Seelenquell CorelDRAW/Corel DESIGNER VBA 2 02-02-2004 09:28
connection string - access database diwin CorelDRAW/Corel DESIGNER VBA 2 23-11-2003 19:52


All times are GMT -5. The time now is 00:46.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright © 2011, Oberonplace.com