Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


HTML Form value into excel Macro

  		Logged in as: Guest
arrSession:exec spGetSession 2,2,61983
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> HTML Form value into excel Macro
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
HTML Form value into excel Macro - 6/29/2008 11:26:03 PM   
  Ravage

 

Posts: 2
Score: 0
Joined: 6/24/2008
Status: offline 		Hello  all,

i've got an issue.
I made a HTA (<HTML>) Form with a ComboBox, which contains the building numbers of my company, and I got a Excel spreadsheet which contains the buildings and available DHCP scopes.

I created a VBA macro in this Excelsheet to AutoFilter on buildingnumbers (a building could have more DHCP Scopes)

Is it possible to send the ComboBox value to the Excel Macro so I can Filter with my HTA Form

Thanks in advance

Ravage
 
 
Post #: 1
 
RE: HTML Form value into excel Macro - 6/30/2008 4:06:28 AM   
  ehvbs

 

Posts: 2078
Score: 50
Joined: 6/22/2005
From: Germany
Status: offline 		Hi Ravage,

wouldn't it be easier to avoid the .hta and do the user interaction in a Excel user form?

Regards

ehvbs

(in reply to Ravage)
 
 
Post #: 2
 
RE: HTML Form value into excel Macro - 7/1/2008 7:37:46 PM   
  Ravage

 

Posts: 2
Score: 0
Joined: 6/24/2008
Status: offline 		Problem Solved!

I create a dumpfile with the data and i recorded a macro to import this data into the auto filter

(in reply to ehvbs)
 
 
Post #: 3
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> HTML Form value into excel Macro Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI