LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 216
Default Loading Excel Data into PeopleSoft

Thanks in advance for any help.

I work in a group responsible for entering invoices into
PeopleSoft. For some invoices we have 20 distribution
lines we need to input from an Excel spreadsheet.
Currently we can save the Excel spreadsheet as a text
file and upload it into PeopleSoft.

What I would like to do is be able to copy the data
straight from Excel into PeopleSoft without saving as a
text file and doing an upload. Is there a way to control
Internet Explorer with an Excel macro that would load the
data straight into PeopleSoft? Let me know if this is in
any way possible. If not possible with VBA would it be
possible with another programming language?

I am using Excel 2000. Thanks again for any help.

Mike
 
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
VLOOKUP not working with data from PeopleSoft Celia[_3_] Excel Worksheet Functions 3 April 6th 10 04:30 AM
Loading data from Excel to Oracle Dr Sanjay New Users to Excel 1 May 26th 06 03:06 PM
Loading Excel Data into a Form DLayne Excel Programming 2 November 4th 04 10:35 AM
Problem Loading Data from SQL to Excel poppy Excel Programming 0 July 26th 04 01:08 PM
Data loading more than once into excel columns poppy Excel Programming 0 July 22nd 04 09:55 AM


All times are GMT +1. The time now is 08:10 AM.

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

About Us

"It's about Microsoft Excel"