InfoPath Dev

Many thanks, this now works. Is it possible to use this with a do loop for a range of cells i.e. b14:014?

Hi guys, I am using VBA in Excel with imported data, can anyone tell me why this code won't work: Sub Test() Dim mycomment As String mycomment = Range(''a1'') Range(''a1'').Comment.Text.mycomment End Sub I want it to show the contents of a cell in a comments box. Any help would be most appreciated?

Hi guys, I am using VBA in Excel with imported data, can anyone tell me why this code won't work: Sub Test() Dim mycomment As String mycomment = Range(''a1'') Range(''a1'').Comment.Text.mycomment End Sub I want it to show the contents of a cell in a comments box. Any help would be most appreciated?

Is it possible to export a Form which I have designed to a specific MS Excel file i.e. one which i have already designed? Please help!

Could you possibly paste in the full code, doesnt seem to work on mine, I have probably got in it the wrong order! many thanks for your help!

Form template: file:///\\CN3RFIL049\WIP_DOCS$\cooka838\BR93\STORES%20T1.xsn The form template is trying to access files and settings on your computer. InfoPath cannot grant access to these files and settings because the form template is not fully trusted. Really stuck!

Thanks guys, could you tell me exctly where to put the code? Unfortunately when I give full trust I cannot reopen the form, I get an error code? any ideas?

Hi guys, I have just started using Infopath and have a deadline to meet! I am designing a form with ''yes'' / ''no'' answered questions, I want a comments (which the user can populate) box to appear if the user clicks ''No''. Is this possible? I also want to include a number of buttons on the form, such as ''Print Form'', ''Save Form''. Does ...