Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Working from data converted from a pdf file

040480-00 HOLLON #26-1@ OK WOODWARD
09/15 G 1562 1.22 2.49 3,895.79 3,649.51 1.0000000 WI 3,895.79 3,173.26
TOKER -3.42 FEXMPP -476.25
TOKEX -3.25
TOKMR -0.24
TOKPR -239.37
09/15 G -1562 1.22 .0000 -3,895.06 -3,614.57 1.0000000 WI -3,895.06 -3,138.32
TOKER 3.90 FEXMPP 476.25
TOKEX 3.70
TOKMR 0.24
TOKPR 272.65

The above data is an example of how a converted pdf file gets parsed as if gets converted and is resaved as an xlsx file. The next 6 or 7 rows are basically a record that has to be joined together to form one row in a table. I can do that one with =match formulas. The problem comes with the second occurrence starting with "09/15 G -1562" and this group continues on the next 6 or 7 rows below that.

The problem I am asking for help on has to do with the top line identifier information. I need to be able to create a formula for the 2nd record say from rows 9 to 15 to also pull the identifier found on row 1 to also associate this line with it as well as with the first row.

The simplified table below is what I am after. The headers were created as desired and are not part of this particular file I brought in but are part of the table structure I am looking to create

Sales Month Meter Well Name Mcfs Gross
09/15 040480 HOLLON #26-1 1562 3,895.79
09/15 040480 HOLLON #26-1 -1562 -3,614.57


Can this sort of thing be done with combinations of index and match, or is it easier to create a looping marco? Either way, there are thousands of such rows, and the top record information on this page will be changing in some variation but it will not be in a predictable patter, and sometimes that record contained in meter and well name in the example table above will not show up consistently in the same excel column when it gets parsed by pdf converter,

Can someone get me started on this please?

Thanks,


Bruce

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Working from data converted from a pdf file

Firstly, which PDF converter are you using?
Is the 1st indented row ("TOK?") placed in col "C"?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
Default Working from data converted from a pdf file

Hi Bruce,

Am Wed, 6 Apr 2016 08:23:17 -0700 (PDT) schrieb B Roberson:

Sales Month Meter Well Name Mcfs Gross
09/15 040480 HOLLON #26-1 1562 3,895.79
09/15 040480 HOLLON #26-1 -1562 -3,614.57


in your expected output you have in row 1 below Gross the value that is
behind WI in your source table. In row 2 you have a value that is in
front of WI.
Which value is correct?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
Default Working from data converted from a pdf file

Hi Bruce,

Am Wed, 6 Apr 2016 18:24:27 +0200 schrieb Claus Busch:

in your expected output you have in row 1 below Gross the value that is
behind WI in your source table. In row 2 you have a value that is in
front of WI.
Which value is correct?


I hope iseparated your data into the correct columns. Your data in
Sheet1.
Try:

Sub NewTable()
Dim varData As Variant, varOut() As Variant
Dim Cnt As Long, LRow As Long, i As Long, n As Long
Dim WName As String, Meter As String
Dim myRng As Range

With Sheets("Sheet1")
LRow = .Cells(.Rows.Count, 1).End(xlUp).Row
Set myRng = .Range("A1:A" & LRow)
Cnt = Application.Evaluate("=SumProduct((MID(" _
& "Sheet1!" & myRng.Address & ",3,1)=""/"")*1)")
varData = .Range("A1:G" & LRow)
ReDim Preserve varOut(Cnt - 1, 4)
For i = LBound(varData) To UBound(varData)
If InStr(varData(i, 2), "@") Then
Meter = Split(varData(i, 1), "-")(0)
WName = Split(varData(i, 2), "@")(0)
End If
If InStr(varData(i, 1), "/") Then
varOut(n, 0) = Split(varData(i, 1), " ")(0)
varOut(n, 1) = Meter
varOut(n, 2) = WName
varOut(n, 3) = varData(i, 2)
varOut(n, 4) = varData(i, 7)
n = n + 1
End If
Next
End With
Sheets("Sheet2").Range("A2").Resize(Cnt, 5) = varOut
End Sub


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Working from data converted from a pdf file

I think it is nuance and its on our company webapp page.

On Wednesday, April 6, 2016 at 11:21:55 AM UTC-5, GS wrote:
Firstly, which PDF converter are you using?
Is the 1st indented row ("TOK?") placed in col "C"?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion




  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Working from data converted from a pdf file

I hope iseparated your data into the correct columns. Your data in
Sheet1.
Try:

Sub NewTable()
Dim varData As Variant, varOut() As Variant
Dim Cnt As Long, LRow As Long, i As Long, n As Long
Dim WName As String, Meter As String
Dim myRng As Range

With Sheets("Sheet1")
LRow = .Cells(.Rows.Count, 1).End(xlUp).Row
Set myRng = .Range("A1:A" & LRow)
Cnt = Application.Evaluate("=SumProduct((MID(" _
& "Sheet1!" & myRng.Address & ",3,1)=""/"")*1)")
varData = .Range("A1:G" & LRow)
ReDim Preserve varOut(Cnt - 1, 4)
For i = LBound(varData) To UBound(varData)
If InStr(varData(i, 2), "@") Then
Meter = Split(varData(i, 1), "-")(0)
WName = Split(varData(i, 2), "@")(0)
End If
If InStr(varData(i, 1), "/") Then
varOut(n, 0) = Split(varData(i, 1), " ")(0)
varOut(n, 1) = Meter
varOut(n, 2) = WName
varOut(n, 3) = varData(i, 2)
varOut(n, 4) = varData(i, 7)
n = n + 1
End If
Next
End With
Sheets("Sheet2").Range("A2").Resize(Cnt, 5) = varOut
End Sub


Cool beans Claus, this macro is working.. I have other fields to populate. This was a sample. Now it's time to expand the test and make sure I can figure out how to bring in other values to the table.

Thanks for your help...

Bruce
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
Default Working from data converted from a pdf file

Hi Bruce,

Am Wed, 6 Apr 2016 11:23:47 -0700 (PDT) schrieb B Roberson:

Cool beans Claus, this macro is working.. I have other fields to populate. This was a sample. Now it's time to expand the test and make sure I can figure out how to bring in other values to the table.


if you need further help, please upload a workbook with example data and
the expected output.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Working from data converted from a pdf file

Apparently I am going to need some more help. I will post back here once I figure out how to upload. It looks like I need to post a link out of dropbox to you can access it?

I loaded this macro into the full file which has some 4,700 rows. The reason I can't tell exactly what is happening is it appears this look goes through all the rows before it copies anything to the sheet2. I stepped through a lot of the iterations of the loop and it passes through those just fine.

I guess what is happening is when the loop ceased to find anymore rows, it threw up an error message when it encountered the following line.

varOut(n, 0) = Split(varData(i, 1), " ")(0)

After that, it doesn't write anything. Am I close on my guess and would it just need something like an onerror statement to get it to pass on down to where it writes what it did? If I can figure that out, maybe I can build on it to add more fields.

On Wednesday, April 6, 2016 at 1:26:06 PM UTC-5, Claus Busch wrote:
Hi Bruce,

Am Wed, 6 Apr 2016 11:23:47 -0700 (PDT) schrieb B Roberson:

Cool beans Claus, this macro is working.. I have other fields to populate. This was a sample. Now it's time to expand the test and make sure I can figure out how to bring in other values to the table.


if you need further help, please upload a workbook with example data and
the expected output.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional


  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
Default Working from data converted from a pdf file

Hi Bruce,

Am Wed, 6 Apr 2016 11:39:47 -0700 (PDT) schrieb B Roberson:

Apparently I am going to need some more help. I will post back here once I figure out how to upload. It looks like I need to post a link out of dropbox to you can access it?

I loaded this macro into the full file which has some 4,700 rows. The reason I can't tell exactly what is happening is it appears this look goes through all the rows before it copies anything to the sheet2. I stepped through a lot of the iterations of the loop and it passes through those just fine.

I guess what is happening is when the loop ceased to find anymore rows, it threw up an error message when it encountered the following line.

varOut(n, 0) = Split(varData(i, 1), " ")(0)

After that, it doesn't write anything. Am I close on my guess and would it just need something like an onerror statement to get it to pass on down to where it writes what it did? If I can figure that out, maybe I can build on it to add more fields.


yes, upload the workbook to DropBox and post the link here.
This error occurs if there is no other char in the column with the date.
Therefore it is necessary to see the data.
The macro works into the memory and writes the data in Sheet2 when all
data is done. If it would write row after row it would be slow.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Working from data converted from a pdf file

I think it is nuance and its on our company webapp page.

On Wednesday, April 6, 2016 at 11:21:55 AM UTC-5, GS wrote:
Firstly, which PDF converter are you using?
Is the 1st indented row ("TOK?") placed in col "C"?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Ok, thanks! This tells me what was used as the col delimiter. While
your sample data 'appears' tab delimited, it's better to be sure. Of
course, this means nothing if the data is already imported into the
worksheet. It means a lot if the data is stored in a text file rather
than PDF because that way it can be read into an array, parsed as
desired, then 'dumped' into a worksheet; -all quite easily. That means
the file that your PDF was created from might be a better source if
available!!!

Meanwhile, I'll also take a look at your sample file as your data
layout is similar to how my menu-builder routine reads in its data. In
this case working code for this already exists and just needs tweaking
to suit your usage!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


  #11   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Working from data converted from a pdf file




Ok, thanks! This tells me what was used as the col delimiter. While
your sample data 'appears' tab delimited, it's better to be sure. Of
course, this means nothing if the data is already imported into the
worksheet. It means a lot if the data is stored in a text file rather
than PDF because that way it can be read into an array, parsed as
desired, then 'dumped' into a worksheet; -all quite easily. That means
the file that your PDF was created from might be a better source if
available!!!

Meanwhile, I'll also take a look at your sample file as your data
layout is similar to how my menu-builder routine reads in its data. In
this case working code for this already exists and just needs tweaking
to suit your usage!

--
Garry

Garry and Claus, here is my link. https://www.dropbox.com/s/aguedei0jq...2016.xlsm?dl=0

Sheet1 contains all the data that nuance parsed just the way it parsed it, pretty messed up but then it looks like the check stub does.

On sheet2, I just put in 4 records so you could see where I was getting the information starting at the top of sheet1.

I also included the total of the check at the bottom of sheet2 as it appears on the sheet1. What makes this really messy is that it has 92 pages in here of pdf data it had been printed out as shown. That is a lot of mess to process manually, so that is why I am trying to help out an accountant in our office by tabling it so it can be mapped into where it needs to go.

Bruce


  #12   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Working from data converted from a pdf file

See notes below to Garry, here is the link.

https://www.dropbox.com/s/aguedei0jq...2016.xlsm?dl=0


On Wednesday, April 6, 2016 at 1:53:10 PM UTC-5, Claus Busch wrote:
Hi Bruce,

Am Wed, 6 Apr 2016 11:39:47 -0700 (PDT) schrieb B Roberson:

Apparently I am going to need some more help. I will post back here once I figure out how to upload. It looks like I need to post a link out of dropbox to you can access it?

I loaded this macro into the full file which has some 4,700 rows. The reason I can't tell exactly what is happening is it appears this look goes through all the rows before it copies anything to the sheet2. I stepped through a lot of the iterations of the loop and it passes through those just fine.

I guess what is happening is when the loop ceased to find anymore rows, it threw up an error message when it encountered the following line.

varOut(n, 0) = Split(varData(i, 1), " ")(0)

After that, it doesn't write anything. Am I close on my guess and would it just need something like an onerror statement to get it to pass on down to where it writes what it did? If I can figure that out, maybe I can build on it to add more fields.


yes, upload the workbook to DropBox and post the link here.
This error occurs if there is no other char in the column with the date.
Therefore it is necessary to see the data.
The macro works into the memory and writes the data in Sheet2 when all
data is done. If it would write row after row it would be slow.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional


  #13   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Working from data converted from a pdf file



Ok, thanks! This tells me what was used as the col delimiter. While
your sample data 'appears' tab delimited, it's better to be sure. Of
course, this means nothing if the data is already imported into the
worksheet. It means a lot if the data is stored in a text file
rather than PDF because that way it can be read into an array,
parsed as desired, then 'dumped' into a worksheet; -all quite
easily. That means the file that your PDF was created from might be
a better source if available!!!

Meanwhile, I'll also take a look at your sample file as your data
layout is similar to how my menu-builder routine reads in its data.
In this case working code for this already exists and just needs
tweaking to suit your usage!

--
Garry

Garry and Claus, here is my link.
https://www.dropbox.com/s/aguedei0jq...2016.xlsm?dl=0

Sheet1 contains all the data that nuance parsed just the way it
parsed it, pretty messed up but then it looks like the check stub
does.

On sheet2, I just put in 4 records so you could see where I was
getting the information starting at the top of sheet1.

I also included the total of the check at the bottom of sheet2 as it
appears on the sheet1. What makes this really messy is that it has 92
pages in here of pdf data it had been printed out as shown. That is a
lot of mess to process manually, so that is why I am trying to help
out an accountant in our office by tabling it so it can be mapped
into where it needs to go.

Bruce


Who creates the PDF?
Can you inquire if the data is available as a text file?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #14   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Working from data converted from a pdf file

The other thing I forgot to mention about the drop file.... I went back and found that I had already stripped out the top row which had the meter and well name parsed together with some other header data. I copied the first record values out, being the meter number and the well name, and then deleted that header file. That probably doesn't matter in the scheme of things here though. I just thought I would mention it.
  #15   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Working from data converted from a pdf file

The other thing I forgot to mention about the drop file.... I went
back and found that I had already stripped out the top row which had
the meter and well name parsed together with some other header data.
I copied the first record values out, being the meter number and the
well name, and then deleted that header file. That probably doesn't
matter in the scheme of things here though. I just thought I would
mention it.


Well we need that so it reflects *exactly* how the data layout is in
order to properly code for it!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


  #16   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Working from data converted from a pdf file

Garry

Here is the link to the file as I got it out of Nuance

https://www.dropbox.com/s/3otad74nd7...df.xlsx?dl= 0

Nuance in this case wouldn't find any headings for me to cut those out, and of course those are just extra stuff to sift through.
  #17   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Working from data converted from a pdf file

One of the big challenges to me is that the well names tend to parse across multiple columns as you can see if you look down through there.

Bruce
  #18   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Working from data converted from a pdf file

One of the big challenges to me is that the well names tend to parse
across multiple columns as you can see if you look down through
there.

Bruce


Yes.., rather messy output IMO!

Can you put together 2 comma delimited strings; 1 for the original
order of headings, and 1 for those same headings ordered how you want
them.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #19   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Working from data converted from a pdf file

https://www.dropbox.com/s/xre6rh9f6g...aders.csv?dl=0

That is the csv file of the way I layed out how I wanted it. I can't find much of a pattern for how it was in the pdf file
  #20   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Working from data converted from a pdf file

https://www.dropbox.com/s/xre6rh9f6g...aders.csv?dl=0

That is the csv file of the way I layed out how I wanted it. I can't
find much of a pattern for how it was in the pdf file


There has to be a pattern in the source for proper coding or for a data
map to work. How is the PDF created? It must be a report generated by
some app that collects the data. Output from that app should be
consistent so find out if the report can be written/saved to a text
file rather than 'printed' to a PDF.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


  #21   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Working from data converted from a pdf file

https://www.dropbox.com/s/xre6rh9f6g...aders.csv?dl=0

That is the csv file of the way I layed out how I wanted it. I can't
find much of a pattern for how it was in the pdf file


You can probably assert blame for any inconsistency to the Nuance
converter app. Raw data is always going to be more accurately
structured and so better to work with if you want consistent
reliable/dependable results.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #22   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Working from data converted from a pdf file

On Wednesday, April 6, 2016 at 3:35:33 PM UTC-5, GS wrote:
https://www.dropbox.com/s/xre6rh9f6g...aders.csv?dl=0

That is the csv file of the way I layed out how I wanted it. I can't
find much of a pattern for how it was in the pdf file


You can probably assert blame for any inconsistency to the Nuance
converter app. Raw data is always going to be more accurately
structured and so better to work with if you want consistent
reliable/dependable results.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Well, I know how to take a pdf file we received in email, and rather than run it in nuance, I can save it as a txt file.
I opened the pdf in adobe acrobat reader, and did a file saveas other.
Here that is, does that do any good?

https://www.dropbox.com/s/gldyhdckpf...02016.txt?dl=0
  #23   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Working from data converted from a pdf file

On Wednesday, April 6, 2016 at 3:35:33 PM UTC-5, GS wrote:
https://www.dropbox.com/s/xre6rh9f6g...aders.csv?dl=0

That is the csv file of the way I layed out how I wanted it. I
can't find much of a pattern for how it was in the pdf file


You can probably assert blame for any inconsistency to the Nuance
converter app. Raw data is always going to be more accurately
structured and so better to work with if you want consistent
reliable/dependable results.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Well, I know how to take a pdf file we received in email, and rather
than run it in nuance, I can save it as a txt file. I opened the pdf
in adobe acrobat reader, and did a file saveas other. Here that is,
does that do any good?

https://www.dropbox.com/s/gldyhdckpf...02016.txt?dl=0


Much, much better! Why can't this be created initially directly from
the app that printed to PDF? It certainly would improve your
productivity by orders of magnitude compared to having to decipher data
that was parsed using OCR technology. I highly recommend you *insist*
the data be sent as a text file *from the source* so you get it 'raw'!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #24   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Working from data converted from a pdf file

On Wednesday, April 6, 2016 at 3:35:33 PM UTC-5, GS wrote:
https://www.dropbox.com/s/xre6rh9f6g...aders.csv?dl=0

That is the csv file of the way I layed out how I wanted it. I
can't find much of a pattern for how it was in the pdf file


You can probably assert blame for any inconsistency to the Nuance
converter app. Raw data is always going to be more accurately
structured and so better to work with if you want consistent
reliable/dependable results.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Well, I know how to take a pdf file we received in email, and rather
than run it in nuance, I can save it as a txt file. I opened the pdf
in adobe acrobat reader, and did a file saveas other. Here that is,
does that do any good?

https://www.dropbox.com/s/gldyhdckpf...02016.txt?dl=0


At this point we now have 'structured' data in that it resembles
database output. Also, the values are not tab-delimited. It'll take a
bit of time to determine the most beneficial way to parse this how you
want. At least the fieldnames are included, which will be helpful.
Better, though, to get raw data directly to a txt!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #25   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Working from data converted from a pdf file

The pdf file is the only format option the purchaser offers apparently for this particular data.


  #26   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Working from data converted from a pdf file

For clarity...
Output to PDF includes pagination features not part of the 'raw data',
thus corrupting the structure of the data in a willy-nilly fashion
dictated by page breaks.

Output to txt results pure raw data. No manual deciphering is required,
and the pagination features do not have to be manually edited out.

It appears the raw data comes from an accounting app and so (unless
really ancient) it should be able to output directly to txt.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #27   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Working from data converted from a pdf file

The pdf file is the only format option the purchaser offers
apparently for this particular data.


See my recent post. Might be what they offer but this in all
probability is not the only option available! (Sometimes you need to be
persistent about getting people to evolve to better ways of doing
things!!)<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can a Excell File be converted to Access MIKEY Excel Discussion (Misc queries) 0 March 8th 10 05:01 AM
Formulas not working on converted file. FARAZ QURESHI Excel Discussion (Misc queries) 4 April 3rd 08 12:37 PM
excel 2003 file converted to .xlsm file when save to network drive Chris Excel Discussion (Misc queries) 3 January 23rd 08 03:56 PM
Can an Excel file be converted to a word doc? Donna Excel Discussion (Misc queries) 1 October 26th 05 09:43 PM
Can an Excel file be converted into Visio? jim314 Excel Discussion (Misc queries) 0 April 18th 05 06:34 PM


All times are GMT +1. The time now is 12:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"