Search results for query: *

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...

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...

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...

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...

Morning :) to prevent errors in my program i need to use my own procedure to check if a file selected to open is already open (the normal excel one causes problems). i have the code below, but i will not know the name of the file. the file name comes from GetOpenFileName so it is the complete...

when recorded in a macro, the command to run a fourier calculation is Application.Run "ATPVBAEN.XLA!Fourier", ...... but when this is played back it gives the error Run-Time Error '1004': 'ATPVBAEN.XLA' could not be found. Check the spelling of the file name, and verify that the file...

Hello ok i found the RefEdit control but am not quite sure how to do what i need so i require a little help please. 1. Make sure that only one cell is selected 2. Check for a value in a cell relative to the one selected Offset (4,0) thank you all

Good morning/afternoon/evening to everyone When doing fourier calculations on data, the number of input values must be a power of 2 (2,4,8,16....) sometimes it is awkward to select the correct number or cells so i would like to create a little box where you select the first cell, the number of...

hi all, i have a little problem, probably just syntax error or something but i cant figure this out. i want to select a few adjacent cells in a row. i cant use xlToRight as it effects some formatting later on. so what i want is something like this ( but that works) Sub Macro4() ' Macro4 Macro...

i have a sheet with some sets of data, and i want to plot some of them. the sheets columns are like this Time X Y X RSS at different times i want to plot different columns( X Y or Y Z RSS etc) but always using the time along the X axis. i have created a form with a check box for...

Is it possible to close the VBE by using code?? i have a macro that runs and inserts code into a new workbook that is opened up, but when the code is inserted into the new workbook, the VBE opens and shows the code. i dont want this to happen. is there anyway to either stop the editor opening...

Hello i keep getting a subscript out of range error for a public variable in my program. the variable is defined in one module and called from another. when i use a message box to print the value of the variable it is empty when it previously had a value, so idont know why its now empty. a...

Hello i have a sheet that contains information about some buttons that i have created, the information is about which buttons should be enabled or not. for each button i have a named cell associated with it eg. Application.CommandBars("Worksheet Menu Bar").Controls("Custom...

Hello I am having a little trouble with opening up a template, well the template opens but then does not go on to the next line of code. i have simplified it down to this, the message boxes were to check if there are values in the variables. the first message box display is right (file path...

Hello all I am looking for a little advice... I am working on a VBA application at the moment but will be finished with it in a few weeks. The application will need to be changed later as the requirements change, but by a different programmer. I have quite a lot of comments in the code but it...

I have a file called EMFCalculator.vXX.xls containing the code for the program that i have written. i have a variable in the code which stores the name of this file, as the versions change, the name changes so with the variable i dont have to change the code for each version, eg...

I have created a custom excel workbook template and i want to use this when i open files. I need to open up delimited text files, but want them in the custom format. what is the easiest way to do this or do i just have to copy and paste the data into the template? is there some VBA command that...

hello, I have a chart with four series and i want to add a fifth. the x values for the new series should be the same as for the others. If i do not enter the range for the XValues for the new series, the line numbers are used. i dont know what the cells will be used for the XValues for the...

Any body know how to check if a command bar exists or not? i have a custom bar in my program that gets changed at different stages, but i the user deletes it then an error occurs when i try to change it because it does not exist. So i have tried the CommandBars.FindControl method but am not...