|
by: murl |
last post by:
Is it just me or is there no easy way to open an excel file, and get
the column names that are usually in the 1st row? I would like to be
able to do this for a import tool im writing in vb.net and c#. I need
to be able to list what columns are available in the excel file, so
the user can map these to a ms sql table.
Dim oExcelApp As New Excel.Application()
Dim oWorksheet As Excel.Worksheet
Dim i As Integer = 0
|
by: Jim Hubbard |
last post by:
http://www.eweek.com/article2/0,1759,1774642,00.asp
|
by: bilalbajwa2336 |
last post by:
I want to make a program in visual basic. When i put my salary data in VB (like: Time In , Time Out, DAte, DAy) VB automatically (in the back ground) input this data in the Excel and Show out puts of excel back in Visual Basic (Hours left , Total Hours and Total sALARY). How to do it. My project summary is I want VB to work like a dummy that saves and puts my inputs in Excel and then shows me back the result calculations in excel and finally...
|
by: William Foster |
last post by:
Good morning all,
I want to password protect a Microsoft Excel Workbook containing all my
reference tables for a program, so that I can place the workbook in a
central location that is accessible by all, but so they can not wreck
it.
I am accessing the workbook via an OleDbConnection through the
System.Data.OleDb framework.
|
by: yansong1990 |
last post by:
well ok, im pretty new to c++, i have -a lot- of exp in programming in
VBA (visual basic for app) for excel to make macros
so i picked up a new course for computing which handles c++ only, i
tried it in school and know how to work it more or less
sadly, my dad got me the visual studios 2005 while i only used visual
c++ in school and im at a TOTAL loss to wat to do and how to go around
to only using c++ (no c# etc)
|
|
by: Mihov |
last post by:
Hi Everybody,
My name is Miho. I have developed number of macros using Visual Basic for Excel. Many of them use FileSearch which worked perfectly before Excel 2007.
With Excel 2007 this is no longer possible, although the same text exists in the Help menu.
Is there a way to solve this problem?
Any suggestions will be highly appreciated.
|
by: Donovin |
last post by:
Hi all,
I am looking at writing new software to replace an existing old DOS based
package our company uses for project cost estimating. I have downloaded and
started to learn the in's and out's of microsoft's visual c# but, as I get
more into it, I'm not sure whether it will be able to do all that I'm
looking for.
Basically what I need is:
|
by: girlswannahavefun |
last post by:
Hi!
I am developing an ASP application on a local machine with MS Office 2003 while the server we are testing it on has MS Office 2007.
In visual studio i have added a reference to Microsoft Excel 2003 Object library.
I am having some problems with ASP trying to open or save Excel files on the server. Could this be due to me not having the correct reference?
Is there any way to add the reference to Excel 2007 without installing Office...
|
by: chrspta |
last post by:
I am new to Visual basic. I need a program using VB6 that converts txt files to excel file.Description is in the below:
The form should have the Drive list, Dir list, file list and cmdConvert button. Once pulling down the drive list and clicking to the specific drive, folders will be shown in the dir list. When clicking the folders in the dir list, files in that certain folder should apprear in the file list, but this program should limit...
|
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...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
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...
|
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...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|