Recent content by VBAva

Hello all i was wondering if there is a way to list all the files in a folder into an excel spread sheet using VBA? what i would like to do is get all the filenames into a spreadsheet (one column) before having to do some editing on the files i have not really worked with external files...

oops, i always post questons and figure out the answer soon after! it is very easy to get the accelerator keys in for a menu item eg (this is just and excerpt so it wont work on its own) Set ctlPopUpFile = EditBar.Controls.Add(msoControlPopup) With ctlPopUpFile .Caption =...

hello i know this is probably a simple question but i cant seen to find the answer :-( i have user forms and a custom menu bar and i would like to have accelerator keys or shortcut keys for the buttons, but i cant figure out how to do it. i cant find it in the excel help either. thanks for...

Interesting... i seem to have fixed the problem but i have no idea why it works now... When the file is exported as .bas instead of .txt it works fine. it used to work in the german version with .txt but not anymore. .txt or .bas works in the english one does anyone know why?? this has me...

Thanks, that works great, have a star :-)

Hi Cambo thanks for the code but i cant seem to get it to work :-( i have the Microsoft Visual Basic for Applications Extensibility 5.3 reference added but i get 'User-defined type not defined' error i am not too sure how to get it working, sorry

hello. i have come pretty much to the end of my project but encountered a problem when running it on a different machine. My computer is set up in English with English Excel, but my co-workers have German versions of windows and Excel. The little application ( i konw its technically a macro)...

Hello I was just wondering if anyone has a handy bit of code that would export the code from a VB project in Excel into Word to make it easier to print?? between modules and forms there are about 30 different parts to the code so if i exported then imported them all manually it could take some...

Kein Problem! As i need to refer to sheets in another workbook ill have to keep using the Namp property of the sheets instead of the code name. would there be a way to stop the user from changing the sheetname? hmmm, that might be just as good, then i wont have to worry about getting errors...

hello Mike i have been away from the office for a few days so was not able to explain the problem i was having properly. ill give it another go and hope that there is a way around it. As i said before the code works great for changing the name of the activesheet, but then i run into problems...

hey John You cannot have a public static variable, statics are a special type of Local variable. unfortunatly i dont know a way around this problem, sorry :-( Ava

Just incase anyone was looking for the answer to this, i though i would post the code that i use ..... Call basTest.CheckOpen(FileToOpen) ..... Sub CheckOpen(ByVal FileName As String) Dim wksht As Workbook FileIsOpen = False For Each wksht In Application.Workbooks If...

Hhmmmmm interesting.... In a message box, if you have vbYesNo or vbAbortRetryIgnore the X button is automatically disabled (never noticed before) but for all the other button combinations ( vbOKCancel, vbOKOnly, vbRetryCancel, vbYesNoCancel, vbSystemModal) it is enabled! So what if you want...

morning all :-) i think this much be pretty easy but mornings and thinking dont really go together. i have a message box with yes and no on it, and the user HAS to pick yes or no, how can i desable the little X in the top corner to force then to pick something?? i know with user forms you can...

Mystery solved :-) The Fourier calculation function is part of the 'Analysis ToolPak' Add-In. It can be called using Application.Run "ATPVBAEN.XLA!Fourier", ..... in VBA code, BUT the 'Analysis Toolpak - VBA' Add-In must also be, well, added in. I hope this helps some one other than...