Thanks in advance.

Thanks for the quick response.

I think you mean that you want to post a script or something to the forum here ?

If yes, copy your text into the post and "wrap" it in code tags, like this:

[code]

your stuff ...

[/code]

and it will look real purdy, like this:

code:

---

hi, hows it going ?

---

else, if you really want to post a file, try the new kixscripts.org site, which if i'm not mistaken, has the ability to actually attach scripts to a post. Then maybe provide a link from here - to there ?

kixscripts.org

-Shawn

[ 18 December 2001: Message edited by: Shawn ]

I tried uploading an Excel file but it told me that file type was not allowed.

I'm trying to post a InputSelect function that accepts an array and displays the contents of the array in a InputBox() like interface and the .xls file contains the form definition for the interface. Is there any way this file can be put in my posting?

Thanks

[ 18 December 2001: Message edited by: d.adams ]

You can export the form definitions and code via the VBA editor and save as .frm extention and post that too !

Then the user will have to reassemble (import) the two pieces back together ... never tried it but it might work ?

Maybe you just want to post the VBA code ?

-Shawn

-Shawn

Thanks for the idea to recreate the .xls file. It's kind of a hassle, but it shouldn't be much trouble to reconstruct.

InputSelect() UDF

This does look very promising ... and it might get even better because something tells me we might be able to get rid of the external xls file altogether (frm and bas) and programatically program (for lack of a better term) the form and function using VBA automation itself ... in other words, the VBA code can be embedded in the KiXtart UDF itself (as strings - kinda like the way we encode and write HTML for IE Automation).

I don't recall ever seeing any examples of this anywhere (web or otherwise) might want to do a search ... but it sounds plausible (possible) if your up for a challenge

-Shawn

btw, was it much trouble to recreate the .xls file?

Don

-Shawn

It sounds like COM to me, so you can put it on Shawns forum

[ 18 December 2001: Message edited by: DrillSergeant ]

I was going to put it there, but the file attachment would not allow .xls files. Also, there seemed to be a problem with posting code. In the preview window, any plus (+) signs would not show up and there seems to be a limit to the length of the post. It was cut off in the middle of the .frm code. I don't know if it is a preview window problem or not.

Thanks anyway,

Don

Thanks for your comments.

hmm, yeah we're still playing around with the board, so we're not really sure of what it can and can't do.

1. it is only allowed to put .txt or .kix files as attachments... so if you do, file.xls.txt it will work. You're also only allowed to add files no bigger than 512K. We were thinking of letting go of the extension and the filesize.
To do this however will (i think) create an opportunity for wrongdoers to post nasty vbs stuff...
What we can do is have all posts moderated, which means that all posts must be approved of by an admin or moderator before it is shown to the public...
Are the moderators (Shawn, JPols, CJ) up for this task?

2. the plus sign is new to me... I will check that asap.

3. I'll check the post size asap too.

[ 18 December 2001: Message edited by: DrillSergeant ]

If you have a really big post, the preview will only show a part of it, but the post itself can be very large.(I don't know the top limit but it should be enough for all kinds of posts)

The + sign isn't shown in the preview, but it does appear in the real post, I think it has something to do with HTML code...

I have added a post to the COM forum that points to the InputSelect() function in the UDFs forum and uploaded the .xls file with the .txt extension. I agree this is a security risk that should be considered.

A couple of things to note:

- I accidentally posted my first time and went back to edit and it would not allow me to attach a file at all (i.e.:no controls displayed on screen)

- the post and download URL's would not display properly in the post until I removed the [url] [/url] tags for the post URL. I removed the tags from the post URL and it fixed both.

Just thought you'd like to know.

Don

kixscripts post

Ok - having difficulty porting this over to me. The functions ported good ... no problems there !

The form is giving me trouble:

1) Looks like there's a hard ref to a resource file:

OleObjectBlob = "InputSelect.frx":0000

VBA won't let me import this ( i tried removing the line). Plus, i think you may have posted the wrong frm anyways because I don't see the definition for your combobox anywhere - no ???

Anxiously waiting your reply, lets keep trying ...

-Shawn

[ 19 December 2001: Message edited by: Shawn ]

[ 19 December 2001: Message edited by: Alex.H ]