Inserting records from Excel directly into a SQL database
I have very little experience with the more advanced features of Excel and
I'm hoping that some of you can provide me with a little guidance and
What I'd like to do is use macros or VBA (or anything else that might work)
to insert data entries directly into a database (specifically, Interbase).
So, I need to:
1. Populate the columns in my datasheet.
2. For some columns, generate additional information. For example, if I had
three columns for First Name, Last Name, Room number, I would need to
generate the value: First name + Last name + " lives in room &quo...How can I alphabetize re-named tabs on Excel?
How can I alphabetize re-named tabs on Excel?
see this site...
> How can I alphabetize re-named tabs on Excel?
...Can an excel workbook be printed two-sided?
I have a two sheet excel workbook that I can not get to print two sided. Can
this be done? I am working on a Mac and using a Xerox Phaser 8400DP laser
printer. Also some of the borders to the cells show up in print preview but
do not appear when I actually print.
This is dependent on the printer and it's abilities. Worse case scenario --
print 1 sheet, then flip it, put it in bin and print sheet on other side
"Janika" <Janika@discussions.microsoft.com> wrote in message
: I have a two sheet excel wo...creating an Excel chart using a map of a country?
How can I create an Excel chart using an image of a country? I would like to
color states depending on certain results.
...Excel combobox question
I have a worksheet (which is created from a template) which has
several comboboxes on it, and when you open the boxes there is data.
However, I do not see any code behind it - I right click on it and I
get what looks like regular choices e.g. copy,paste. They are all
named ranges. Do anyone have any idea what these are and how to get
access to the data and/or the code?
...Display Excel/Access windows
I am running VBA in Access which opens and modifies an Excel workbook. How
can I control which application (Access or Excel) is visible to the user? I
want to sometimes show the Excel and sometimes the Access.
Set the Application object's Visible property. Make sure you use error
handling so that you do not leave the Access application invisible.
Public Sub AccessingExcel()
On Error GoTo Handle_Error
Dim appExcel As New Excel.Application
' Make Excel visible
appExcel.Visible = True
' Make current Access invisible
Applicat...How to keep colunm headings when scrolling down in excel
When using an excel worksheet I put my own headings for columns in row #1.
When I scroll down too far I lose those headings. Is there a way to keep them
at the top of the screen?
Highlight the 2nd row and click on WINDOWS --> FREEZE PANES.
Hope that helps
Message posted via OfficeKB.com
select row 2 and do Window=>Freeze panes
with any cell selected you can do Window=>UnFreeze panes
to reverse it.
if you selected B2 and then did it, row1 and column 1 would be "frozen"
it freezes to the left ...Convert excel file to xml
I need to convert excel data into an xml file.
I use Excel 2003. Most help I can find suggests using an existing xml file
to create an xml map, and then taking things from there.
Since I haven't got as far as creating an xml file, I can't do that.
Is there a simple way to convert excel data to an xml format?
...How can 2 people add data to the same Excel file at the same time
Is there a way to have more than 1 person keying into a excel sheet at the
"Dough50" <Dough50@discussions.microsoft.com> wrote in message
> Is there a way to have more than 1 person keying into a excel sheet at the
> same time?
...Exporting a Report to Excel 11-12-07
We use Access's built-in function for exporting reports to Excel quite a bit
and have been very happy with it. However, there are a couple reports that
we'd like to export to Excel and have more control over the formatting of
the produced spreadsheet.
Can anyone make any suggestions as to what the best way would be to do this?
(Our client is using Access 2000 and Excel 2000.)
Thanks in advance.
...Where can I find some good Excel spreadsheet for managing my bank account
and tracking my daily expenses? I thought about downloading some
applications for this
purpose, but none of them satisfy me and they are not free, ;)
you can design your own in spreadsheet something like this
DATE my ch# DETAILS BANK CH NO. WITHDRAWAL DEPOSIT
1-Jan-04 SBI RELF BOND ECS
5-Jan-04 IDBI FLEXI BOND 9 ecs
05-Jan-04 ch uti mepus 35335 utibk 065820/19,12,.03
07-Jan-04 ch k gilt d...Dynamic chart generation: Run time Error '1004: Method 'Cells' of object'_Global' fai
I am trying to generate a chart with multiple series. The number o
series is not fixed and can be any number. I recorded a macro and the
modified the code. 'Counter' refers to the number of the series and
have referenced it in a worksheet. I am getting the error in the lin
that is bold. Thank you for your help.
The code is as follows:
Dim Counter As Integer
Dim i As Integer
Counter = Cells(38, 13).Value
ActiveChart.ChartType = xlLine
With Sheets("VP_Wit...Change the default cell size in Microsoft Excel?
I've been trying all morning to figure out how to change the default
cell size in Microsoft Excel so that each cell is the size of four
cells normally. Is this possible?
I realize I can select four cells at a time and then merge them but I
need page after page of cells this size and its not very efficient to
do it this way.
Thanks in advance,
Open an excel sheet and click on
then put in the width you need
simonc's Profile: http://www.excelforum.com...EXCEL polynomial trendlines
I have been generating trendlines to a number of data set's using a
polynomial fit. If I do not set the intercept to zero the equation indicated
on the graph is correct when I re-generate the trendline curve using second
data set inputing x to obtain y.
However, if I set the intercept to pass through zero the equation given does
not give the correct trendline when I regenerate the curve using a new input
data set for x to obtain y.
Doe anyone have any suggestions of comments as to why this is happening and
what can do to stop it?
I am sure your post makes sense to you but it leav...Generating cell content based on user input -HELP!!
I'm throwing myself on the accumulated power of the forum and hope there are
people out there that can help me with this please?!?
I am trying to predict the age of outstanding work to the month end. I have
set up a table that has the population of cases in house at start of month.
In columns to right of this I have end of month date for each month I am
projecting to. Following this is a calc field for each date to work out age
of case at each month end.
This data is used through the indirect function to calculate the average age
of cases at the end of each month. To get it to wo...How do you entr data in a form (scanned) document?
I have a printed form I need to fill out by entering data. How do I ues Word
to do so? I can scan the form to creat a (picture) document. How do I enter
data in this document (by overlay) to enable printing it with entered data?
You could use text boxes for your info.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Filling in preprinted forms" <Filling in preprinted
email@example.com> wrote in message
>I have a printe...Excel Count
I have a interesting question.
I have a worksheet with A1:E1 having headings of a certain table.
A2:E2 have the details as columns. This is continued in A3:E3 as well
I need to find the occurances of a value in these rows and display the
heading for the same in a result column. (say F2 trough F5)
Could any one please help me out with this.
Take a look at the MATCH and INDEX functions in XL Help.
Hope this helps.
On Feb 10, 10:56=A0am, Anoop <anoopsanth...@gmail.com> wrote:
> Hi All,
> I have a interesting question.
> I ha...Convert Publisher document to a .pdf file
I create a multi-page newsletter using Publisher. How does one convert this
to a single .pdf file? My first attempts (copy/paste into Acrobat) only
produce page 1. Is there a way to capture the whole document which includes
photos and clipart so that I can paste it into Acrobat?
You don't paste into Acrobat, you print the document to Acrobat. File, print, select
the distiller or Adobe PDF, depending on the version of Acrobat.
Mary Sauer MSFT MVP
"Ed C" <econgleton@snet....Excel xls files open as Machine Code
Recently I created 11 Spreadsheets with Office 2003 on Machine 1. Using a USB
Drive I copied all 11 files to Machine 2. On Machine 2, with Office 2003, 7
files open correctly with data in tact. The remaining 4 files open with what
appears to be Machine Code, which is unreadable. The files extensions are
..xls in all cases.
Is there any way of converting these files back to readable data or
recovering the data by some means.
I have never experienced this before and do not know how it could happen to
only some files of the set.
Any assistance will be most appreciated.
...does Excel 2007 still support patterns in graphs?
We loaded a chart created in Office 2003 into Excel 2007 and wanted to change
the black and white patterns we used to fill the bars, but cannot find a
similar function in the new version. Is the pattern fill still available?
If so, where?
This is no UI to the patterns fill any more.
You can try this addin.
Andy Pope, Microsoft MVP - Excel
"Mark" <Mark@discussions.microsoft.com> wrote in message
> We loaded a chart ...chart dates and times (excel 2007)
I have 2 columns of data. One is a series of dates. The second is a
series of times when a particular event happened on that date. To
make it troublesome on a few of the dates the event didn't happen.
I have been asked to create a chart (line) with dates on x-axis and
event times on y-axis where the y-axis is measured off at 15 minute
To be frank I didn't even know where to begin.
I tried selecting both columns and then INSERT a Line chart but it
gave me two horizontal lines parallel to each other with the first
line running along the x-axis and that too starti...make excel files executable
Is there a utility available that would make an excel file an executable?
Specifically, I want to share my spreadsheet with people who don't have
Horatio, if they just need to view the files there is an excel viewer here
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Horatio J. Bilge&...Copying worksheet from hidden instance of Excel
Is it possible to open multiple worksheets in a hidden instance of
Excel and copy worksheets to a workbook in the original visible
instance? I want to open multiple files and would prefer to not see
all the files being opened in the windows task bar?
wb was opened in a hidden instance of excel. An error occurs at the
The error is: "Method 'Copy' of object '_Worksheet' failed"
Is there another option avoid seeing the files being opened in the
application.screenupdating = false
Set wb1 = ActiveWorkbook
Set wb = xlApp.Work...Excel Cells appear to "Stick" When working
Good morning all,
Can anyone help me on a little matter regarding what seems to be sticky keys
We use both Excel 97 and 2000 here, and I just had a couple of problems from
When a user tries to make changes to an excel spread sheet, they select one
cell, then when they move the mouse around, more cells are selected.
Now we have had something like this before, and the resolution is to depress
Shift+Tab then Ctrl. Or another problem can be solved by the F8 key, or the
Extensable option I think it is.
In this instance non of these works. Everytime you start up excel, t...C:\Documents and Settings\user name\.thumbnails\normal
With Windows XP Home edition:
I have notice that under C:\Documents and Settings\user
name/.thumbnails\normal that there are a lot of recent thumbnail photos.
What's this all about????
Any knowledge on this?
Thanks in advance,
No! Fill us in on just what websites you have been visiting!
"H.B." <firstname.lastname@example.org> wrote in message
> With Windows XP Home edition:
> I have notice that under C:\Documents and Settings\user
> name/.thumbnails\normal that there are a lot of recent thumb...