Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Anyone know how to enter Info in a web page through VBA in Excel

My company is migrating to a new accounting system fromone with a text based
interface than emulates the "green screen" terminals to a system that has the
Explorer as its interface. I write macros that retrive information or repeat
tasks in the old system. Is there a way to enter keystrokes into a web page
so that I can get the information out of the new server. I do not want to
avoid the security by accessing the tables dirrectly. If it is complicated
is there a book that discusses what I would need to know?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default Anyone know how to enter Info in a web page through VBA in Excel

There are a number of prgrams that record key strokes and play them back.

They are ok for experienced users but sometimes are tempramental.

Do a serch for key stroke programs on winsite or simtel.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 860
Default Anyone know how to enter Info in a web page through VBA in Excel

Hi SWSmith,

SWSmith via OfficeKB.com wrote:
My company is migrating to a new accounting system fromone with a
text based interface than emulates the "green screen" terminals to a
system that has the Explorer as its interface. I write macros that
retrive information or repeat tasks in the old system. Is there a
way to enter keystrokes into a web page so that I can get the
information out of the new server. I do not want to avoid the
security by accessing the tables dirrectly. If it is complicated is
there a book that discusses what I would need to know?


You can do this through the XMLHTTP object, but it's not always easy. Look
here for some examples/discussion (watch URL wrap):

http://groups.google.com/groups?as_q...=2005&safe=off

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]


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
I cannot enter information in excel sheet, info bounces to top Ambitious Angela Excel Worksheet Functions 2 January 13th 10 09:20 PM
Enter info in one sheet, auto enter in another based on one field The BusyHighLighter[_2_] New Users to Excel 1 August 1st 07 10:54 PM
Can I enter info in Excel and have it display as an '*'? Mac6225 Excel Discussion (Misc queries) 1 November 21st 06 06:21 PM
Excel/Access template to enter/sort utility bill info LodRazor Excel Discussion (Misc queries) 1 October 20th 06 01:57 AM
Can I lock info in Excel 2003 and users in Excel 2000 enter info? Mimmsan Excel Discussion (Misc queries) 1 September 8th 05 12:12 AM


All times are GMT +1. The time now is 03:09 PM.

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"