473,778 Members | 1,759 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VB 2005 Express - Excel 2007 - how to?

I *did* have Excel 2003 on my office PC and was fiddling with a little VB
Express app that interacted with Excel - nothing complex, but it worked.

Since then IT has upgraded me to Office 2007 and the only thing I can import
is Microsoft.Offic e.Core, nothing with the Excel object at all. My earlier
code throws off errors whenever Excel is referenced.

Is this Microsoft's way of telling me that I can't access Excel 2007 from VB
Express, or do I need to download something to make this work?
Sep 11 '07 #1
2 2027
On Sep 11, 10:02 am, Duke Carey <DukeCa...@disc ussions.microso ft.com>
wrote:
I *did* have Excel 2003 on my office PC and was fiddling with a little VB
Express app that interacted with Excel - nothing complex, but it worked.

Since then IT has upgraded me to Office 2007 and the only thing I can import
is Microsoft.Offic e.Core, nothing with the Excel object at all. My earlier
code throws off errors whenever Excel is referenced.

Is this Microsoft's way of telling me that I can't access Excel 2007 from VB
Express, or do I need to download something to make this work?
Did you add a reference to the Microsoft Excel Object Library 12.0 com
object? You must add the reference to the dll before you can start
importing namespaces.

Thanks,

Seth Rowe

Sep 11 '07 #2
Well, that was simple. Thanks for the assistance.

"rowe_newsgroup s" wrote:
On Sep 11, 10:02 am, Duke Carey <DukeCa...@disc ussions.microso ft.com>
wrote:
I *did* have Excel 2003 on my office PC and was fiddling with a little VB
Express app that interacted with Excel - nothing complex, but it worked.

Since then IT has upgraded me to Office 2007 and the only thing I can import
is Microsoft.Offic e.Core, nothing with the Excel object at all. My earlier
code throws off errors whenever Excel is referenced.

Is this Microsoft's way of telling me that I can't access Excel 2007 from VB
Express, or do I need to download something to make this work?

Did you add a reference to the Microsoft Excel Object Library 12.0 com
object? You must add the reference to the dll before you can start
importing namespaces.

Thanks,

Seth Rowe

Sep 11 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
1868
by: sebas_cp | last post by:
I just downloaded VB 2005 Express and would like to create some financial functions to use within EXCEL through DLL´s but cannot manage to do it. ANy help would be appreciated. VB 2005 Express Excel 2000 Windos 2000 cheers, S
7
12240
by: ashley.ward | last post by:
We have been using VB6 to develop small custom apps that access an Oracle database, in order to extend a larger product that is developed by our colleagues in Germany (who use C++ and Java). As each app is small and simple, we have been distributing each to the customer in the form of a single EXE file. I have been attempting to build another one of these small custom apps, using VB 2005 Express Edition. It doesn't seem to be possible...
1
2387
by: Stephen Plotnick | last post by:
Where can I find all the excel commands available for VB 2005. I need the ones for Excel 2007. Thanks, Steve
3
3261
by: Lee T. Hawkins | last post by:
I am having a number of problems over the last two full days trying to get an ASP.NET 2.0 application to connect to a SQL Server 2005 database... First off, I built this application w/ Visual Studio 2005 SP1 and had it working perfectly on my Windows XP machine on SQL Server 2005 Express. I decided to publish this application to a test development server (with both the SQL and IIS servers on the same box) running on: Windows Server...
3
1402
by: qu4dman | last post by:
Hi all I would like to program an application with C# Express (for now, because I'll soon use VS.NET 2005 not in "express version") that would use Mysql 5 and Office 2007 in automation (Word, Excel, Access). I've read about the Mysql 5.1 connector and plugin so I'll try it tonight. I'd like to have your advice on the following ideas, please : - Could my application be easily packaged and deployed (with all that will be needed, such as...
10
7787
by: Stephen Plotnick | last post by:
I'm using VB 2005 and Excel 2007 and cannot figure out how to insert a page break before line 72. I've tried several ways but always get an exception error. Thanks in advance.
2
3087
by: Manikandan | last post by:
Hi, I have a program written in .Net Framework 1.1 using Visual studio enterprise edition 2003. I tried compiling the same program in visual c# express edition 2005. I'm getting following errors 1.Error 6 Cannot implicitly convert type 'mscomctl.Toolbar ' to 'mscomctl.Toolbar . An explicit conversion exists (are you missing a
2
1487
by: Matt | last post by:
I've coded using VBA on top of MS Excel for the last 2 years (40 hours a week). I've stepped up to VS C# 2005 Express / SQL Server 2005 Express a couple months ago, but the videos that I downloaded along with the software didnt really give me the kinds of examples I think I need to write the types of App's that I'm currently writing now in Excel/VBA? I write Time Card programs, Payroll programs, automated product pricing engines (they...
0
2067
by: silviu | last post by:
Hello I'm trying to install Microsoft SQL 2005 Server Express Edition but I'm getting the following error: SQL Server Setup unexpectedly failed... Then it says something about a log file. Here's the contents of that log: Microsoft SQL Server 2005 Setup beginning at Thu Nov 22 22:30:08 2007 Process ID : 3856 e:\6f695192a2be55cedd30e3868397bfd2\setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/10/22 22:30:8...
0
9628
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9464
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10292
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9923
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8954
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7471
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6722
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4031
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3627
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.