viswadevan
06-13-2011, 06:33 PM
Hi Guys,
I've been working on a userform for days,
I want to use the input given in the userform to run a certain macro.
How do i activate it.
Scenario.
Userform Select Date and Shift
With given date and shift i need it to open an excel file from my desktop.
The following is the VBA command i'm using for manual run
Workbooks.Open Filename:= _
"C:\Documents and Settings\Viswa Devan Nair\Desktop\Macro Trail\New\Cell 2 Harddown Tracking File_June.xls"
Sheets("C Team 12-Jun").Select
Range("B22:P150").Select
Selection.Copy
Windows("HD tracking.xls").Activate
Sheets("Raw Data").Select
Range("A1").Select
ActiveSheet.Paste
I need the userform to select the following sheet that has been underlined.
Sorry can't include an image of the userform...
Gurus of macro... please help me...
thanks
I've been working on a userform for days,
I want to use the input given in the userform to run a certain macro.
How do i activate it.
Scenario.
Userform Select Date and Shift
With given date and shift i need it to open an excel file from my desktop.
The following is the VBA command i'm using for manual run
Workbooks.Open Filename:= _
"C:\Documents and Settings\Viswa Devan Nair\Desktop\Macro Trail\New\Cell 2 Harddown Tracking File_June.xls"
Sheets("C Team 12-Jun").Select
Range("B22:P150").Select
Selection.Copy
Windows("HD tracking.xls").Activate
Sheets("Raw Data").Select
Range("A1").Select
ActiveSheet.Paste
I need the userform to select the following sheet that has been underlined.
Sorry can't include an image of the userform...
Gurus of macro... please help me...
thanks