PDA

View Full Version : [SOLVED] Testing help wanted!



mvidas
08-17-2004, 10:14 AM
Hi Everyone,

Attached is an add-in I made for exporting to text files. Testing/Finding Errors/Suggestions much appreciated!

Thanks!!
Matt

mvidas
08-17-2004, 10:16 AM
Also, if something doesn't look right or is mispelled or anything else (even minor), please let me know as well

sebastienm
08-17-2004, 10:55 AM
Hi Matt,
Just a quick note: if there is no active workbook, the following line fails:


Private Sub UserForm_Activate()
If Left(Right(ActiveWorkbook.Name, 4), 1) = "." Then

You could check for 'ActiveWorkbook Is Nothing' before that line.
I haven't had time try the tool yet.

Regards,
S?bastien

mvidas
08-17-2004, 10:59 AM
Good point... consider it fixed, thanks!

mvidas
08-17-2004, 11:16 AM
By the way, I'm using excel 2000 sr1, if anyone gets any errors please let me know what version you're using

On top of the no-activeworkbook thing Seb mentioned, I also fixed the msgbox text for when no delimiter is entered and fixed width is not checked (was missing a space).

Anyone know offhand how to make it so the escape key hides the userform?

sebastienm
08-17-2004, 11:47 AM
There is no direct ESC for the Userform. The way it works is that you set the Cancel's button property called Cancel to True. That is, pressing ESC triggers the cancel_Click and runs that code.

Regards,

mvidas
08-17-2004, 11:54 AM
Perfect!

Revised add-in attached

Thanks Seb!

mvidas
08-17-2004, 12:47 PM
quick update, fixed an error in ExportButton_Click sub, changed ActiveSheet.Close to ActiveWorkbook.Close (for fixed width exports)

mvidas
08-18-2004, 06:28 AM
I have made a few minor aesthetic changes, as well as an added functionality for the fixed width exports. Most recent version attached. All comments are appreciated!
Thanks
Matt