Summary: Hi I need to know how to give value to cell from another cell in VBA . Now the value is a date and it needs to be counted up until the end of the mont...
Summary: Need help with VBA and excel. I'm trying to write a macro for excel, with multiple combo boxes. When populating these boxes, I would like to store the...
Summary: I'm trying to save an excel spreadsheet with the filename of K&N.csv but when I try and do this from within my macro, excel crashes when the workbook ...
Summary: Hi There, I have a simple request but since my programming knowledge in VBA for excel is limited I don't really know where to start. In excel, I have ...
Summary: Hello, i have programmed a code in VBA for Excel, wass running smoothly on my old machine, now new computer it says when i run the macro, it says cant...
Summary: i am new to VBA and need a VBA program that i can call in excel. this program would solve an equation such as one of time dilation: t = t0/sqrt(1-(v/...
Summary: Hi, I am trying to reach an Excel document from C# but i take the error message System.Runtime.InteropServices.COMException Additional information: O...
Summary: I am quite enamoured with VBA in excel, love it for creating macros but the process of the programming seems limited, only allowing me to use Excel as...
Summary: i have been given the following questions if anyone could help with a solution to each i would be most greatful because i am new to using vba in excel...
Summary: Try these two lines: Rows("1:1").Copy Windows("Book2").Range("A1").PasteSpecial Paste:=xlValues, Transpose:=True The operation to convert between hori...
Summary: I'm working with VBA in excel and am wondering if you can select multiple sheets. Manually you can select multiple sheets by holding down ctrl. I kn...
Summary: Hi I am in the analysis stage of writing a very complex database, im proberbly going to use a oracle or SQL server backend. I am not sure whether to u...
Summary: Can anyone tell me how to run an exe, with parameters (eg. C:\cmd.exe p1 3), in VBA for Excel 97. Up until now I've been putting the command into a ba...
Summary: Hope someone can help me with this... I'm a newbie.. so please understand... :) I have an excel workbook that uses macros... I added a code each time ...
Summary: Hi guys, Im new to VBA and I want to create a Macro so I can extract especific lines or paragraphs from a MS word file and import them to excel. I hav...
Summary: As an example for Word 97 and Excel 97: You can display the VBA object editor from the menu by: Select View Select Toolbars Control Toolbox With it yo...
Summary: yes, everythin is possible in this field. you have to understand how to work or acess onjects (in this case and excel spreadsheet) and be able to mani...
Summary: Hello, I would like to use vb.net to take an excel file, convert specific data into variables and then write the data out to certain parts of another ...
Summary: Why bother. If all the processing is being done in VB why not display the data in a Grid Control. Make your own mini spreadsheet in fact. Not that ...
Summary: HI THERE IM HAVING TROUBLE PRODUCING SOME VBA CODING IN MICROSOFT EXCEL THAT WILL IMPLIMENT THE FOLLOWING CODE, I WOULD BE GREATFULL IF ANYONE COULD H...
Summary: i am using visual basic 6 (not visual basic script or VBA) and i wrote a program that writes texts to an excel sheet.I need to make these texts hyperl...
Summary: Hi, I'm trying to create a function that allows me to put in two different months (either as text or numbers it doesn't matter) and then tell me the d...