Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 31st, 2007, 03:33 AM
Registered User
 
Join Date: Oct 2007
Location: chennai, tamil nadu, India.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Linker error.help

I have linked an excel sheet which label,button, combo box etc.(code is vba written) While linking this excel to access it shows error excel is not in correct format. If i keep the excel sheet open i am able to link.Is there anyway to over come this error as i have so many excel sheet(12)...

vidhya
Reply With Quote
  #2 (permalink)  
Old October 31st, 2007, 06:37 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

It sounds like Access will not work with a closed Excel spreadsheet here. In that case, you need to open the spreadsheet (without making it visible) in order to expose the objects you want to work with, when you want to work with them.

Do you need help with that code?

mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote
  #3 (permalink)  
Old November 1st, 2007, 12:58 AM
Registered User
 
Join Date: Oct 2007
Location: chennai, tamil nadu, India.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

yes i need help, regarding code.At present i have opened all excel sheet(12),link it and then queried. If i close the excel sheet after linking, at the time of query again shows error "excel sheet is not in correct format". It seems i have to keep the excel open all the time. Thanks a lot for replying.



vidhya
Reply With Quote
  #4 (permalink)  
Old November 1st, 2007, 07:37 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Well, since Excel can't be updated while you are in it, and I think it takes a snapshot of the data only, even if the application persists, why don't you import the data you need as you need it, and forget the whole Excel management issue? Every time you want to run a query, bring the data in to a local table, and then query it from within Access. Be sure to create the necessary delete query to remove all the data from the table before you do each import.

How do you want to proceed?


mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote
  #5 (permalink)  
Old November 12th, 2007, 02:54 AM
Registered User
 
Join Date: Oct 2007
Location: chennai, tamil nadu, India.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, since Excel can't be updated while you are in it, and I think it takes a snapshot of the data only, even if the application persists, why don't you import the data you need as you need it, and forget the whole Excel management issue? Every time you want to run a query, bring the data in to a local table, and then query it from within Access. Be sure to create the necessary delete query to remove all the data from the table before you do each import.

How do you want to proceed?


mmcdonal


If i bring the data to local table, i cant refresh the data each time using linked table manager....

As u said i want help regarding making the excel open without visible... I want to proceed in this way...help me

vidhya
Reply With Quote
Reply


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 Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linker Error, Chapter 18 Spasticus BOOK: Ivor Horton's Beginning Visual C++ 2005 4 February 20th, 2008 05:04 AM
Compiler linker error raja_welcomes Visual C++ 1 June 6th, 2007 11:17 AM
[Linker error] undefined reference philArmstead BOOK: Professional C++ 7 October 9th, 2005 05:40 PM
linker error while calling fortran from c rony C# 0 August 2nd, 2005 07:52 AM
linker error smukher Visual C++ 2 July 2nd, 2003 06:10 PM



All times are GMT -4. The time now is 11:28 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.