Problems automating inVBA

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Asp
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - The resource object with key 'InvalidUserName' was not found hey asp.net 3.5 I'm trying to localize a requiredFieldValidator, but I get this compile error: The resource object with key 'InvalidUserName' was not found The resource 'InvalidUserName' exists in .resx files in this project Project have 2 .resx files: WebResources.resx WebResources.nb-NO.resx <globalization uiCulture="nb-NO" /> When I created these resource files, I first created the WebResources.nb-NO.resx and then the WebResources.resx. I'm not sure the order I created these files should have anything to do with the error. (I'm a newbie)..... Here is the markup where I try to use the InvalidUserName key: <asp:RequiredFieldValidator ID="rfvUserName" SetFocusOnError="true" ErrorMessage='<%$ Resources:Resource, InvalidUserName %>' ControlToValidate="UserName" Display="Dynamic" ValidationGroup="PasswordRecovery1" runat="server" >*</asp:RequiredFieldValidator> any suggestins? Tag: Problems automating inVBA Tag: 511482
  - 2
    - Is using UserId guid outside of aspnetdb acceptable? Hi, I'd like to take a full advantage of built-in membership services and use aspnetdb's UserId in my app's database. For example, I'd like to establish some relationships between membership users from aspnetdb and rows in tables in my database. My app would be responsible for enforcing the cross-database 'referential integrity'. Does this sound as a good/acceptable practice? Thanks, Bogdan Tag: Problems automating inVBA Tag: 511477
  - 3
    - Missing TextChnged event on the page Here's what I have: environment: .NET 2.0, ajax extensions. UserControl and an aspx page where it's used. UserControl has one Repeater control displaying a grid like data with one column displayed in asp:TextBox (ID='txtDelivery') controls. I added event onTextChange for this control with a handler: 'txtDelivery_Changed' on the back end. I have MyTest.aspx page where this UserControl is used. It's used inside of UpdatePanel tags. When I debug, I change text in grid provided inside UserControl, it asynchronously sends to back end to my event handler function 'txtDelivery_Changed'. Values recalculated and rebinding is called. So far so good. My sample page works in a small sample project. Now, I moved my UserControl with my tested code from MyTest.aspx into and an 'existing project' on a preexisting web page, and event 'txtDelivery_Changed' is never called now! What happens in debug is 'Page_Load' is called on text change and process finishes without ever going to 'txtDelivery_Changed' handler. (In MyTest page Page_Load is called and then 'txtDelivery_Changed' is called). When I ask for value Request.Form["__EVENTTARGET"] (in Watch window) it returns proper text box name (which is a modified name from 'txtDelivery'). So, the server knows who triggered event, but process never moves to the 'txtDelivery_Changed' handler! Notes: This existing project and 'existing' page is rather involved and has some Ajax already implemented using old way of ICallbackEventHandler. Also the page has numerous <form tags. I also added attribute for @Page: EnableEventValidation="false" in order for my other LinkButton to work in my UpdatePanel on the 'existing' page. I tried to use in my UserControl: protected override void Render(HtmlTextWriter writer) { Page.ClientScript.RegisterForEventValidation(MyRepeater.ID); base.Render(writer); } with no avail. (it was supposed to make sure the event is registered) Question: How do I get my event handler 'txtDelivery_Changed' being called? Thanks, Oleg Tag: Problems automating inVBA Tag: 511476
  - 4
    - q; Search engine; Dynamic pages Search engine; Dynamic pages I was reading a few articles that search engines do not support dynamic pages, is there any reference that talks about how we can overcome this issue? Tag: Problems automating inVBA Tag: 511469
  - 5
    - QueryString Not Accesible from the Server (Please Respond) Hi. I have HTML on my form that was constructed on the server. The "browser" is a PopUp that was previously fired from another page. This popup is a standard browser pop-up, nothing fancy or unique. There are two forms inside the pop-up: They both have javascript buttons on them that submit the form. The submit constructs a querystring that gets sent to the server. When i look at it on the server, Length is always 0. What am i doing wrong? I have tried this using an input button with type=submit also and i still get length = 0. One of the two forms is as such: <form action='view_webinar_free.aspx' name='view_webinar_free' id='view_webinar_free'><div class='formButtons'><a href='javascript:submitviewer();' class='textBtnRed formBtn'><span>View Webinar</span></a></div></form> Bot forms and enclosing HTML is below: <div class="mod1Col"> <div class="shbox"> <div class="sh1"> <div class="sh2"> <div class="box">  <div class="modHeader deepPurpleBG"> <h2>View webinar</h2> </div>   <div class="modBody modHeight160"> <div class="modCopy"> <p>Click on the button below to access the webinar.</p><form action='view_webinar_free.aspx' name='view_webinar_free' id='view_webinar_free'><div class='formButtons'><a href='javascript:submitviewer();' class='textBtnRed formBtn'><span>View Webinar</span></a></div></form> </div> </div>  </div> </div> </div> </div> <div class="shbox"> <div class="sh1"> <div class="sh2"> <div class="box">  <div class="modHeader deepPurpleBG"> <h2>Login to the presenter</h2> </div>   <div class="modBody modHeight360"> <div class="modCopy"> <p>Click on the button below to access the presentation interface.</p><br /><form action='presenter_interface.aspx' name='presenter_interface?music=love&travel=love&sports=love' id='presenter_interface' ><ul><li><label>Email:</label><input type='text' class='input_small' id='oEmail' /></ li><li><label>Password:</label><input type='password' class='input_small' id='oPass' /></li></ul><div class='formButtons'><a href='javascript:submitpresenter();' class='textBtnRed formBtn'><span>Login</span></a></div></form> </div> </div>  </div> </div> </div> </div> </div> Tag: Problems automating inVBA Tag: 511458
  - 6
    - 2 projects, but only 1 login Hi, I have 2 projects on a domain, like this: www.example.com/ www.example.com/community/ I am using .net membership so they will only need 1 login. BUT, since /community is a seperate IIS virtual folder, how will it know to use the same login cookie (forms authentication) from the other virutal application (i.e. www.example.com ) ? Tag: Problems automating inVBA Tag: 511456
  - 7
    - Linq and sql Hi all I have the following xml file : <?xml version="1.0" encoding="utf-8" ?> <root> <persons> <person> <firstname>Mark</firstname> <surname>Jones</surname> <age>33</age> </person> <person> <firstname>Adbul</firstname> <surname>Khan</surname> <age>30</age> </person> <person> <firstname>Bob</firstname> <surname>Smith</surname> <age>31</age> </person> </persons> </root> I have the following expression XElement myXml = XElement.Load("Sample.xml"); var allPersonsInOrderOfAge = from person in myXml.Descendants("person") orderby person.Element("age") select person; However when I run this - I get an error saying "At least one object must implement IComparable" Can anyone shed any light on this? Is my expression wrong... How can I correct this problem? Many thanks Tag: Problems automating inVBA Tag: 511455
  - 8
    - Properly using directorysearcher to find a user in an AD Group I'm trying to do a check to see if a specific active directory user account exists in active directory AND a specific group. I can't seem to get the filter down right. I can do this to find a matching name in active directory: ================================================ Dim oroot As DirectoryEntry = New DirectoryEntry("LDAP://my.domain.local") Dim osearcher As DirectorySearcher = New DirectorySearcher(oroot) Dim oresult As SearchResultCollection Dim result As SearchResult osearcher.Filter = "(&(sAMAccountName=jsmith))" oresult = osearcher.FindAll For Each result In oresult If Not result.GetDirectoryEntry.Properties("SAMAccountName").Value Is Nothing Then Response.Write(result.GetDirectoryEntry.Properties("SAMAccountName").Value & "<br />") End If Next 'This results in "jsmith' being printed to the screen (if jsmith exists in active directory) ================================================ I can do this to find a specific group name: ================================================ Dim oroot As DirectoryEntry = New DirectoryEntry("LDAP://my.domain.local") Dim osearcher As DirectorySearcher = New DirectorySearcher(oroot) Dim oresult As SearchResultCollection Dim result As SearchResult osearcher.Filter = "(&(objectCategory=Group)(sAMAccountName=Domain Admins))" oresult = osearcher.FindAll For Each result In oresult If Not result.GetDirectoryEntry.Properties("SAMAccountName").Value Is Nothing Then Response.Write(result.GetDirectoryEntry.Properties("SAMAccountName").Value & "<br />") End If Next 'This results in "Domain Admins' being printed to the screen ================================================ I can even change the osearcher.filter to just (sAMAccountName=Domain Admins) and get the same result. I'm trying to figure out how I can return the result (say, the user name (samaccountname)) if the search paramater is both in AD and in the specific group (or just the specific group). My goal is to do a check like this (pseudocode): ================================================ Dim strUser as string = Request.ServerVariables("AUTH_USER") Dim strADUser = osearcher.Filter = "(&(sAMAccountName=" & strUser & "))" If strUser = strADUser Then Page.Redirect(ToSomePage) Else Page.Redirect(ToFailedPage) End If ================================================ I Also need to check to see if they're in a specific group. I don't know how I'd go about that. If, for instance, they're in the Sales group in AD, then I could redirect them to the appropriate page. I could also, of course, keep them out of other pages if they don't belong. TIA, Jim Tag: Problems automating inVBA Tag: 511453
  - 9
    - Crystal and DataSet Hi, MySqlDataReader reader = null; MySqlCommand cmd = new MySqlCommand("Select from something", conn); reader = cmd.ExecuteReader(); How can I put: report.SetDataSource(ds); the Reader instead DataSert ? Is possible converting Reader to DS ? VS 2005 - asp.net C# 2.0 Thanks! Tag: Problems automating inVBA Tag: 511451
  - 10
    - catch{} butterfingers {} Hi all, I have a perplexing problem.... protected void ArticleFormView_ItemUpdating(object sender, FormViewUpdateEventArgs e) { try { //Next line is line 36 if (!ArticleDataSource.IsValidNewValues(e.Keys, e.NewValues)) e.Cancel = true; } catch (FormatException) { e.Cancel = true; Page.Validators.Add(new StaticValidator("Invalid price")); } } As you can see I am catching FormatException. I put a breakline on line 36 and when I hit F10 ArticleDataSource.IsValidNewValues will throw a FormatException. At this point I would expect my Catch to kick in, but as you can see from the following exception information it is not. Does anyone know why this is? Thanks Pete Input string was not in a correct format. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.FormatException: Input string was not in a correct format. Source Error: Line 34: try Line 35: { Line 36: if (!ArticleDataSource.IsValidNewValues(e.Keys, e.NewValues)) Line 37: e.Cancel = true; Line 38: } Source File: C:\OtherData\CapableObjects\docs\QuickStart\VS2005\SourceCode\07\QuickStart.Asp\Members\EditArticle.aspx.cs Line: 36 Stack Trace: [FormatException: Input string was not in a correct format.] System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +2755599 System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt) +138 System.Decimal.Parse(String s, NumberStyles style, IFormatProvider provider) +37 System.ComponentModel.DecimalConverter.FromString(String value, NumberFormatInfo formatInfo) +36 System.ComponentModel.BaseNumberConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value) +335 [Exception: 2.5sd is not a valid value for Decimal.] System.ComponentModel.BaseNumberConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value) +398 System.ComponentModel.TypeConverter.ConvertFrom(Object value) +54 Eco.Web.UI.WebControls.EcoDataSourceView.ApplyValues(IObjectInstance obj, IDictionary values) in c:\dev\fbuild\source\Public.CLR\Handles\Asp\EcoDataSourceView.cs:780 Eco.Web.UI.WebControls.EcoDataSourceView.IsValidNewValues(IDictionary keys, IDictionary values) in c:\dev\fbuild\source\Public.CLR\Handles\Asp\EcoDataSourceView.cs:750 Eco.Web.UI.WebControls.EcoDataSource.IsValidNewValues(IDictionary keys, IDictionary values) in c:\dev\fbuild\source\Public.CLR\Handles\Asp\EcoDataSource.cs:892 QuickStart.EditArticle.ArticleFormView_ItemUpdating(Object sender, FormViewUpdateEventArgs e) in C:\OtherData\CapableObjects\docs\QuickStart\VS2005\SourceCode\07\QuickStart.Asp\Members\EditArticle.aspx.cs:36 Tag: Problems automating inVBA Tag: 511450
  - 11
    - updateprogress over top of updatepanel Is there any way to get an updateprogress to entirely cover an updatepanel when it is displayed? Tag: Problems automating inVBA Tag: 511444
  - 12
    - ajax control toolkit AccordianPane display issue I have added an accordion control with 3 panes. However, when I view it in either IE or FF the panes are displayed to the right of the header, not underneath. Can anyone explain why this is? I know this is not the default behavior. Below is the relevant code: <cc1:Accordion ID="Accordion1" runat="server" AutoSize="None" ContentCssClass="collapsePanel" HeaderCssClass="collapsePanelHeader" FramesPerSecond="40" TransitionDuration="250" FadeTransitions="true" SelectedIndex="0" SuppressHeaderPostbacks="true"> <Panes> <cc1:AccordionPane ID="AccordionPane1" runat="server"> <Header> <a href="" onclick="return false;">Know what you need? &nbsp&nbsp &nbsp&nbsp &nbsp&nbsp</a> </Header> <Content>  </style>  </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> <p class=3DMsoNormal>Hello all!<o:p></o:p></p> <p class=3DMsoNormal><o:p> </o:p></p> <p class=3DMsoNormal>Is there any way I can have two different login = areas in one web application? I have user portal, to which customers can login and I = have admin panel. Using roles doesn=E2=80=99t really help here, cause = customers and admins are entirely different entities. Furthermore design of their login pages = will be different.<o:p></o:p></p> <p class=3DMsoNormal><o:p> </o:p></p> <p class=3DMsoNormal>I know that forms authentication doesn=E2=80=99t = support this natively, but probably there is a known pattern?<o:p></o:p></p> <p class=3DMsoNormal><o:p> </o:p></p> <p class=3DMsoNormal>Thank you!<o:p></o:p></p> </div> </body> </html> ------=_NextPart_000_0016_01C88461.FE78E890-- Tag: Problems automating inVBA Tag: 511332
  - 20
    - save 2005 sqldatabase as 2000 database Hi just wondering if anyone knows if you can save a 2005 database as a 2000 database so it can be opened and used in 2000? thanks. -- Paul G Software engineer. Tag: Problems automating inVBA Tag: 511316
  - 21
    - Localhost -Visual Web Developer 2005 I am trying to view a project using web developer 2005 on a vista laptop using this connection string in the web.config file. <add name="AmSoftMgt" connectionString="Driver={MySQL ODBC 3.51 Driver};Server=66.36.240.205;Database=AmSoftMgt;User=AmSoftWeb;Password=AmS0ftW3b;Option=3;"/> But every time I debug (with no errors) or preview a page, the project loads at http://localhost:50977/root/login.aspx I have searched my entire solution for any other references to localhost and none exist. Why does it keep loading in localhost? Tag: Problems automating inVBA Tag: 511315
  - 22
    - ListBox populated with Javascript shows no members upon Callback Hi all, I was wondering if what I am seeing is to be expected or maybe I'm setting things up wrong with the Update Panels. I am programming in VS 2008 with VB. I have a page with multiple update panels. At the bottom of the page I have an update panel with UpdateMode="Always" where I store hidden fields. I use them for communication with the server and maintaining state upon Callbacks. The fields appear to be always Read/Write accessible at the server during the page callback. One of the other update panels is set to UpdateMode="Conditional" ChildrenAsTriggers="false" and I have defined some trigger buttons (AsyncPostBackTrigger) that are clicked from within JavasScript functions. There is an asp listbox (Id = "lstSelected") in that panel which I populate clientside using the JavaScript DOM, depending on what the user selects from a Grid . Upon callback with the Trigger defined for the update panel, I discover that in Page_Load Me.lstSelected.Items.Count = 0. There are no Items found in the lisbox even though they were clearly there in the Browser document having been placed there with JavaScript. Is this to be expected that listboxes populated in this manner show as empty at the server during callback? I have resorted to populating some hidden fields with delimited strings representing the contents of the listbox. These are populated at the same time as the listbox entries are created via JavaScript...but as I said, for some reason they persist. Can anyone tell me why I might be seeing this type of behavior? Thanks for any replies. Tag: Problems automating inVBA Tag: 511314
  - 23
    - Need help with dynamically loaded user control losing changes... I have been struggling with this for weeks. Each time I thought I had it figured out, it has reared its ugly head again! :) Any help is SO appreciated since my project deadline is Friday!!!! ************What I am trying to do: I have a bunch of user controls that are loaded and unloaded one at a time. Before one control is loaded, a SaveControl method is called to save any changes the user made in the previous control. ************What is happening: I am dynamically loading a user control in a place holder like this: Control ctl = new Control(); ctl = LoadControl("AssessmentDemographics.ascx"); The control loads fine. A user is able to change values of controls in the user control. Once they have made their changes, they click on the next control they want to load. However, when the SaveControl method in the usercontrol is triggered the first time, the changes are saved. But then any other changes made are lost! I have stepped through the code and watched the new values entered by the user disappear. For example, a patient has been entered with the first name of "John". The user changes the name to "Jack", but when the SaveControl method is called and the first name property is being set to the text box's text, it says the text box text still says John. I am not sure what I am doing right the first time and doing wrong every other time! I don't know what I am missing. I will post some code to give a better idea of what I am doing. Hopefully it isn't as confusing as I am feeling right now. :) TIA, Rosemary //*****************CODE TO FOLLOW****************************** //---------------------------MAIN PAGE------------------------------------------ //I have link buttons that a user can click to change which form they are working on. //Each time a link is clicked, the current form is saved, and the new one loaded protected void lnkDemographics_Click(object sender, EventArgs e) { //Utility is just a class I created to help me convert values without having null errors, etc.... AGP.Utilities.Utility utility = new AGP.Utilities.Utility(); SaveCurrentControl(); //Form Order is simply an enum letting me save which Form ID is currently loaded. //I save that form id to a cookie. SaveCurrentControlID(utility.GetInt32(AGP.Common.FormOrder.AssessmentDemographics)); LoadCurrentControl(); } protected void lnkAssessmentMain_Click(object sender, EventArgs e) { AGP.Utilities.Utility utility = new AGP.Utilities.Utility(); SaveCurrentControl(); SaveCurrentControlID(utility.GetInt32(AGP.Common.FormOrder.AssessmentMain)); LoadCurrentControl(); } private void LoadCurrentControl() { int controlID = GetCurrentControlID(); //If controlID = 0 then no control needs to be loaded, so exit the method if (controlID == 0) { return; } //Load the requested control AGP.Utilities.Utility utility = new AGP.Utilities.Utility(); Control ctl = new Control(); placeHolder.Controls.Clear(); if (controlID == utility.GetInt32(AGP.Common.FormOrder.AssessmentDemographics)) { this.lnkDemographics.BackColor = System.Drawing.Color.AliceBlue; ctl = LoadControl("AssessmentDemographics.ascx"); } else if (controlID == utility.GetInt32(AGP.Common.FormOrder.AssessmentMain)) { this.lnkAssessmentMain.BackColor = System.Drawing.Color.AliceBlue; ctl = LoadControl("AssessmentMain.ascx"); } placeHolder.Controls.Add(ctl); } private Boolean SaveCurrentControl() { //If the control to save is empty, then this is a first load and no control needs saving yet int controlID = GetCurrentControlID(); if (controlID == 0) { return false; } AGP.Utilities.Utility utility = new AGP.Utilities.Utility(); if (controlID == utility.GetInt32(AGP.Common.FormOrder.AssessmentDemographics)) { UserControls_AssessmentDemographics currentControl = (UserControls_AssessmentDemographics)placeHolder.Controls[0]; currentControl.SaveControl(); } else if (controlID == utility.GetInt32(AGP.Common.FormOrder.AssessmentMain)) { UserControls_AssessmentMain currentControl = (UserControls_AssessmentMain)placeHolder.Controls[0]; currentControl.SaveControl(); } return true; } private void SaveCurrentControlID(int controlID) { Session["CurrentControlID"] = controlID; } private void ClearCurrentControlID() { Session["CurrentControlID"] = null; } private int GetCurrentControlID() { if (Session["CurrentControlID"] == null) { return 0; } else { AGP.Utilities.Utility utility = new AGP.Utilities.Utility(); return utility.GetInt32(Session["CurrentControlID"]); } } //-------------------------DEMOGRAPHICS USER CONTROL---------------------------- //The second user control is very similar to this one, //just uses a different class to update different properties. protected void Page_Load(object sender, System.EventArgs e) { OpenAssessment(); } private void OpenAssessment() { Patient patientToEdit = GetSelectedPatient(); Contract contract = GetSelectedContract(); AGP.Utilities.Utility utility = new AGP.Utilities.Utility(); this.txtFirstName.Text = utility.GetString(patientToEdit.FirstName); } public void SaveControl() { Patient patient = GetSelectedPatient(); Utility utility = new Utility(); patient.FirstName = utility.GetString(txtFirstName.Text); //Save the patient id for later retrieval SavePatientID(new Patients().AddPatient(patient)); } Tag: Problems automating inVBA Tag: 511313
  - 24
    - Exception handling source line number I am using global.asax to handle my web application exceptions and have configured it to create event log entries for errors that occur and to display an error page advising the user to contact the helpdesk. I have an intermittent uninitialised object error that I am not able to reproduce in test and for which I really need the source line number. I believe this information is contained in the PDB but am not sure if one is created if I set the debug="true" flag in the compilation part of the system.web section of the web.config when the application is recompiled. Anyone any idea? Regards, Major. p.s. Major is my Christian name ;-) Tag: Problems automating inVBA Tag: 511310
  - 25
    - Drill through in Report Viewer Control - Urgent Hi, I have a strange issue with the report control viewer. I am using "Report Viewer Control" to display SSRS 2005 reports in an ASP.NET site(aspx page) which is integrated with a sharepoint 2007(MOSS) site.The problem is that the main report is displaying properly.But when I drillthrough to another report from the main report,the drillthrough report is not displayed instead I get a standard X placeholder. But the reports are working fine in both "ReportServer" as well as in "ReportManager" and there are no issues in passing parameters as well. The most funniest thing is that when I call the report by clicking on the button in the aspx page which is meant to call the report the drillthrough report appears all of a sudden with no problem. I have absolutely no idea as to why this problem is occuring. Is there any workaround for problem.Is there something which I am not doing which is to be done in order to get this working like some "configuration settings" or "property settings" etc. Any solution to this problem is appreciated. Thanks in advance. -- Regards, ArvindRavish Tag: Problems automating inVBA Tag: 511301

I'm attempting to automate input to an ASP/AJAX web-page using VBA, however,
I've encountered a couple of problems:

1) when selecting from dropdown A manuallly, dropdown B is populated with a
series of options depending on the option selected in drropdown A. While I
can select from dropdown A in VBA, dropdown B never gets updated. Prsumably
I need to trigger some event on the page, but how do I accomplish this in
VBA?

2) clicking a button creates an "on the fly" dropdown depending on the
contents of a textbox. How do I access this dropdown and select an option?

Apologies if these questions seem naive and beginnerish, but I'm working
well outside my comfort zone.

Cliff.

Top

Re: Problems automating in VBA by Mark

Mark
Fri Mar 14 05:43:34 CDT 2008

"Cliff" <cliff.havard@virgin.net> wrote in message
news:u_qCj.3033$Ff4.2420@newsfe5-win.ntli.net...

> I'm attempting to automate input to an ASP/AJAX web-page using VBA

Please clarify which software you are using:

ASP or ASP.NET (AJAX works only in ASP.NET, not ASP)
VBA is Visual Basic for Applications, the programming language which comes
with Microsoft Office, not ASP or ASP.NET

--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Top

Re: Problems automating in VBA by Cliff

Cliff
Fri Mar 14 06:06:02 CDT 2008

Apologies for the lack of clarity, as I said, while I've got a fair bit of
experience using VBA to automate Excel, this project is at the limits of my
knowledge and experience.

I'm using VBA to populate the fields on a web-page from data held in Excel
using the Internet Explorer object via GetElementById. I think frm the
research I've been able to make, the page itself was developed iusing
ASP.NET. I hope this helps.

Thank you for taking the time and trouble to reply.

Cliff.

Top

Re: Problems automating in VBA by Mark

Mark
Fri Mar 14 06:39:04 CDT 2008

"Cliff" <cliff.havard@virgin.net> wrote in message
news:u_sCj.8358$jH5.5137@newsfe3-win.ntli.net...

> Apologies for the lack of clarity, as I said, while I've got a fair bit of
> experience using VBA to automate Excel, this project is at the limits of
> my knowledge and experience.

Hmm - OK...

> I'm using VBA to populate the fields on a web-page from data held in Excel
> using the Internet Explorer object via GetElementById. I think frm the
> research I've been able to make, the page itself was developed iusing
> ASP.NET. I hope this helps.

Please post your code...

--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Top