Search results for query: *

Hi, Haven't been on here in a while. Have a slight problem(at least i suspect it is) which i would like some help with: I have a macro thatopens a userform on which a button is clicked to copy and paste data into sheets 2 and 3 of the excel control worksheet. Right after that a RUN button is...

Hello to everybody, Havent been on here in a while. Have a slight problem(at least i suspect it is) which i would like some help with: I have a macro thatopens a userform on which a button is clicked to copy and paste data into sheets 2 and 3 of the excel control worksheet. Right after that a...

Hello I have a GetOpen Filename program that works for two workbooks being copied into 2 sheets of a destination workbook. However, i want a situation where I can say that if user chooses a file in a specific folder, then do a set of instructions, However if the file chosen is in another...

I have got a code for opening a file and copying data into another sheet.I have two files that I need to open and copy data from their only sheets into a workbook with two destination sheets. In short, two workbooks (each with a sheet) copied into one workbook(2 different sheets). Currently, my...

Hello , Wondering if anyone out there could come to the assistance of a vba newbie. I have a getopenfilename program that opens a dialog box and enbles me to choose a file that opens up. From there.I copy a sheet to another worksheet. However, how do I close the file retrieved through the...

Hello To all, How are ya?/ I have a slight problem with this code. Sub mnuFileOpen_Click() Dim FullFileName As String FullFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls", False) Application.StatusBar = "Opening " & FullFileName Workbooks.Open FullFileName...

Hello Everyone, I am writing a program whereby I will be able to click on a form button I have designed and have an open dialog box open,whereby I choose a file and basically have contents within that file copied into another file.I would prefer themacro to do it automatically.However,I am not...

Hello Everyone, I am writing a program whereby I will be able to click on a form button I have designed and have an open dialog box open,whereby I choose a file and basically have contents within that file copied into another file.I would prefer themacro to do it automatically.However,I am not...

Hello ALL, Hope you'v all had a good day doing all that you do. Need a little assistance with this problem Just written a code in VBA and upon clicking the user form I created for the program to run I get a compilation error in the fff code: Cannot jump to "txtYear" because it is in the...

I have 2 columns in a control worksheet that is a refernce to my macro.. First column has 90 files relating to departments. the 2nd col. has 5 of these 90 files.Basically, my code is supposed to look at each of the five entries in column 2 and if it matches to any of the 90 columns, then go on...

Hello VBA Techies, I have a slight problem that i need help with.I have a source worksheet where i pull data and put them into ninety odd destination worksheets The destination worksheet has an outlay as ffs. A B E H K Items 2000 2001 2002 2003...

Can anyone please explain to a VB Newbie what a Chr is and when it is used??Also how do I know which numbers to use if selecting a specific colour.To make it easy here's a piece of code that's got me baffled!! Cells(65, txtPeriod + 1).Formula = "=" & Chr(65 + txtPeriod) & 9 & "/" &...

Hello, I have written a macro that copies arange of worksheets from one workbook to another, however there seems to be a problem with getting the workbook to open even though the pathway has been specified and everything seems to be alright. Not sure what the problem is,but I did delete the...

Hello All, I am trying to execute a VB program that will copy worksheets in a workbook into another workbook with some calculations done to it. However, after writing basic code and trying to debug I came across the message"Error 1004- Application or Object-defined error" at line 6(when opening...