PDF Table to Excel Spreadsheet
This has been asked in numerous places all over the web but I have not
found a workable solution. We have a mainframe system that generates
PDF reports for billing. However, few people in our organization
these days speak mainframe. We need Excel to do calculations on the
data. I began working on a method for converting using UEdit Macros
and an Excel macro because the fields are fixed-width. My attempts
have been unsuccessful.
Here is what I want to accomplish:
-Copy a region of text from a PDF
-Paste into Excel
-Break the values out into the appropriate cells.
http://www.google.com/sea...Excel Drop Down Boxes #2
Question; does anybody know how to add additional data to a previous
drop down box? I have created a form that has several drop down boxes
a while ago, and due to some information that has been change I need to
input more info in the drop down boxes but for some odd reason I cant
remember how I executed these actions!! If it helps I am using Excel
CRS's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27444
View this thread: http://www.excelforum.com/showthread.php?threadid=46...Hiding records on reports by checkbox on form
Hi, I'm in the proccess of buliding a new database. Its purpose is to store
various organisation contact details and then to produce reports based on
this that can be printed onto sticky labels. This much or basically finished.
However, we naturally don't want to print the whole database every time, so
I'm using a checkbox on the interface form that will filter the report so
that only checked records are prepared for printing. Can anyone tell what
code I need to use to do this, and where? I've tried various methods, but
nothing seems to work. I'm using accesss 2003 by the w...When printing to large scale plotter, is there a max # of lines/pa
I am having problems with printing to my large plotter. Project seems to
have issue when printing 325 lines or more. The plot gets long horizontal
lines of different lengths running through my data. When I insert a page
break at, for example, line 323, the plot looks fine, but I am getting two
pages instead of just one. Has anyone else had this problem? I don't think
this is a plotter problem.
Almost always, problems related to printing are related to the system or
the printer driver. That is because Project is using the system to
print. The first thing to check is that...How can I access a public calendar from a custom form
I am trying to create a custom form that would allow a
employee to request a vactation time frame. This form
would then be mailed to a supervisor who could approve or
disapprove the request. I am having difficulty getting
the response posted to a public calendar vs. the managers
private calendar. Help! -Jeff
...Best way to design tables for cascading on my form
My company inspects damaged cars for insurance purposes. Up to now,
(relating to this issue) I've had tblDamageArea populate a list box on my
form where the user can select the various parts of the car that were
damaged. I've had this list include parts for multiple kinds of cars and I'd
like to make this list cascade to include only those parts relevant to the
car type inspected.
I've created a tblVehType to separate Sedan, Coupe, 4DoorTruck, SUV, etc.
which populates a cbo on my form where the user will select the type which
will then be used as the crite...How do I use excel names with INDIRECT with charts
I want to create a Chart that does not directly reference cell-ranges (i.e.
but excel-names that make the reference sheet-independent.
My aim is to be able to copy one chart to other worksheets, which have their
dataareas at the same places like the source-sheet.
Problem: This works fine in cells but not in charts
Excel name definition:
Any idea about this?
Thanks in advance,
You have to include the sheet name in the final formula that you want XL to
www.tushar-mehta.co...Distribution list creation policy (re-post)
I am reposting a message I submitted a few months ago. I find it hard
to believe that we are the only company with this problem...Please
help - thanks.
We have 5500 users and we are currently at 1400 distribution lists. We
migrated over from TAO email years ago and in that system, users were
able to create their own mailing lists, which they did and did it
I think that they are still used to this mentality and are always
requesting distribution lists to be created. This function is handled
by one of our two Exchange administrators, but not happily I must
Our lists situation ...Question Variation: Shading a portion of the space between two lines
I posted a question on March 21 about how to shade a small portion of
space between two lines and got an answer from Jon that helped
I have a slight variation on that question. I've tried manipulating
the data in several ways myself, and got close, but no cigar.
Here is my revised question. I have another chart with two
intersecting lines. I want to shade a small portion of the space
before the intersection and another small portion of the space after
the intersection. Specifically, there are 13 points on each line and
I want to shade the space between points 1 and 5 and a...Electronics Line USA Synchronizes Video with the IBM 4690 Retail POS
Electronics Line USA unlocks the IBM 4690 POS and provides real-time
exception reporting with video integration.
Boulder, Colo. - August 22, 2007 -Electronics Line USA is pleased to
announce the release of a new point-of-sale (POS) video integration
with the IBM 4690 which includes the Supermarket, ACE, GSA and Chain
The solution allows the Electronics Line ETV DVR Series to sync video
from security cameras with the point-of-sale transactions. Retailers
can then produce both real-time and after-the-fact exceptions reports
which help management make decisions that improve e...Excel
i use Excel with office xp. i have a form we have made that requires client
Name, Address, Phone, Fax etc etc etc...
currently i keep all those contacts within my outlook contacts...
is there a way i can type in the client business name in that cell, and have
excel do one of the following:
autofill with available address, phone, fax, PC, City/Town, contact...
give me a choice of available contact...
keep in mind, the Address, Phone, Fax, PC, City, Contact Name are all
different rows and colums...
Export your Contacts from Outlook as a *.CSV f...Excel VB Code Error
I am trying to create a .csv file from an Excel workbook
using a VB module and am wondering if someone can tell me
what's wrong with the below code:
Public Sub CSV2()
Application.DisplayAlerts = False
ActiveSheet.Name = "Temp_10001"
For Each ws In Worksheets
If ws.Name <> "Temp_10001" Then
x = ActiveSheet.UsedRange.Rows.Count
If x > 1 Then ActiveCell.Offset(x, 0).Select
ActiveCell.PasteSpec...Problems saving excel file from outlook
I have an EU that whenever he saves an excel file from
outlook, it will rename the file (by adding the number "2"
at the end of the file "file2.xls") and it also changes
all the embedding links in the document. (The embedding
link of F:\users\file.xls changes to c:\documents and
Are you setting a Hyperlink base for your links? See Menu
> File > Property > Summary tab. Put the original folder
location there and when you move or save the file the
links will not be renamed. Also assigning a letter to the
drive can cause problems (not ...Line Chart #13
The following is my data and I need to chart this. Is it possible to have a
range in one cell?
Thanks for your help in advance
Experience (Years) Large Medium Small
1 $90,000-$100,000 $75,000-90,000 $65,000-78,000
2 $92,000-100,000 $80,000-95,000 $75,000-85,000
3 $105,000-130,000 $90,000-100,000 $85,000-95,000
4 $117,000-150,000 $100,000-115,000 $90,000-110,000
5 $140,000-170,000 $115,000-130,000 $100,000+
6 $140,000-190,000 $135,000+ $100,000+
7 $170,000-250,000 $135,000+ $110,000+
...Posting onto great plain error
Can anyone help me with the Integration Manager 7.5?
The problem that I have is when I backup the folder "C:\Program
Files\Microsoft Business Solutions\Integration Manager". Once from a
workstation replaced with the same folder from other workstation. Three
folders that I backup previously on different days and different weeks
when I open the Integration Manager or missing the integration items to
All three folders came up the same thing missing integration items.
This error is before I was backup the folders.
Integration: ABC-Publishing (ID: 50)
Ac...Excel tab as windows
Is there a way while running Excel to be working on one tab and open another tab as a smaller window that is always on top. So I can enter information in both tabs without having to minimize, maximize, or switch back & forth?
you could align the windows so you can see both at the same time. But a
'always on top' option does not exist AFAIK
> Is there a way while running Excel to be working on one tab and open
> another tab as a smaller window that is always on top. So I can
> enter in...External smtp email to public folder shown as post, not shown as email
Exch2003 FE & BE servers, both running on w2k3 server, BE server also a DC &
Now config public folder at BE, mail enabled it. For internal users, if
sent email to public folder, it shown up as email. For external parties, if
sent email to public folder, it shown up as post.
Wondering how to tweak public folder so that external emails will shown as
email instead of post?
Try looking at the following KB:
"Zac" <firstname.lastname@example.org> skrev i en meddelelse
news:Og20iL...can cvs files be opened using excel viewer
i have a user who cannot open cvs files with excel viewer but can ope
with the full version of excel...anyone experienced this problem and i
so, can you pls post the resolution
darriel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2388
View this thread: http://www.excelforum.com/showthread.php?threadid=37522
There is nothing in the description of the Excel Viewer to suggest that it
can read anything other than true XLS files.
http://support.microsoft.com/default.aspx?scid=kb;...how do i search an excel sheet for links to another spreadhseet?
Is there a Find function that allows me to look for links in a sheet?
When I can't find links, I'll use Bill Manville's FindLink program:
> Is there a Find function that allows me to look for links in a sheet?
...Forms and Reports from CrossTab queries
I have read a few postings in this area, but they all seem to be very
specific to particular situations. Can someone please guide me towards the
best solution to my dilema?
I have a form with two list boxes which contain many variables (answers to
specific questions from a survey). When two different questions are slected I
run a cross tab query resulting in a dymanic result of rows and columns based
on the selections.
I now want to display the result as a datasheet on my form and in a similar
fashion as a report.
Any help is, of course, greatly appreciated.
John D...Hiding a field from a sub form.
I know that this looks easy (and it probably is) but this is what I need to do.
I have this code that I can hide a field within the same form
' NI.Visible = Not NB
And this works just fine.
what I would like to do is Hide a Field from a Sub Form and I am hitting a
I tried this, so please tell me where I am brain dead.
frmDateEntry!product.visible = not NB
Thanks in advance,
Learn Today, Teach Tomorrow
Great Success is ones ability to ask for Help.
On Fri, 18 May 2007 14:50:00 -0700, TheNovice
>I know tha...Excel Reader scroll bar???
I'm using an Excel viewer to read e-mail attachments from
my home office. I don't have Excel installed on my
machine, only the viewer.
Often I do not have the horizontal scroll bar. I have
tried maximizing the window and still no luck.
Any solutions for this?
...new to making forms on access
I have a table whihc has column name title and some survey question.
Now i want to create a form so that when i select Name ( I guess this will
be combo box) I dont know how to do that even where i can select name ? but
when i select name the person title auto populates and so does the relevant
answers to the questions
for example i choose John and the title should auto populate and question 1
should populate also and so on but if i pick adam then everything related to
Your help will be really appreciated
The table look like this
Name Title Qu...data extraction from excel
I need to pull information from one collumn. If the collumn is comprised of
yes's and no's, can excel create a list of just the yes's?
Try something like this:
Assuming your list is in A1:B100, with
D1: Question (the same col heading as A1)
E1: Response (the same col heading as B1)
Select your list (A1:B100)
List Range: (already selected)
Criteria Range: C1:C2
Click the [OK] button to filter the list in place.
To copy the matching records to another area:
Click: Copy to another location
Copy...batch importing of mailing lists to Excel
I've got a mailing list of around 1000 names, stored in both Word and
Entourage like this: First Name Last Name <e-mail address>
Once I’ve eliminated the < >, do I then have to individually copy & paste
(or type) all the info in three Excel columns? Or is there a simpler solution
for batch importing of mailing lists to the Excel spreadsheet?
> I've got a mailing list of around 1000 names, stored in both Word and
> Entourage like this: First Name Last Name <e-mail address>
> Once I’ve eliminated the < >, do I then ...