Macro or script to auto fill fields

**Benjamin2008** · 06-29-2010, 04:21 PM

Hi all,

I need a script or macro, for doing data entry work, also is there any script to read data on PDF file?

Many thanks
Ben

**Domski** · 06-29-2010, 04:40 PM

I've used this before to convert pdf's to excel with varying results: http://www.pdftoexcelonline.com/

As for your data entry script your going to need to provide quite a bit more information. The layout of your data, do you want to use userforms or key directly into the sheet, what do you want the script to do?

Dom

**Benjamin2008** · 06-29-2010, 05:03 PM

Originally Posted by Domski

I've used this before to convert pdf's to excel with varying results: http://www.pdftoexcelonline.com/

As for your data entry script your going to need to provide quite a bit more information. The layout of your data, do you want to use userforms or key directly into the sheet, what do you want the script to do?

Dom

Hi Domski

Data entry, needs to be done in to internal web based tool.(attached) sample
Thanks
Ben

**Domski** · 06-29-2010, 05:19 PM

Not into Excel then?

Dom

**Benjamin2008** · 06-29-2010, 05:21 PM

Originally Posted by Domski

Not into Excel then?

Dom

Hi Domski,

No not in to excel , :-(

**Domski** · 06-29-2010, 05:28 PM

I'm a little confused about what you want to achieve anyway. Are you saying you want to strip information from the displayed pdf and then automatically enter it into the web based form using VBA?

I'm assuming the invoices that you are processing are not all in the same format for a start. Even if what you were asking was possible it's not going to be something someone here is going to want to take on as a challenge for nothing unless they're a little short of something to do for the next 12 months

Dom