Hi everyone, I'm very new to VBA and I have some code from a former employee but I need help fixing.
I'm trying to do the following with VBA Code.
1. Data will be entered into a row in a file that has been opened (Problem Tracking.xls)
2. A macro button will be clicked
3. The Macro will ask what row to copy data and the person will input the row number
4. Copy the selected columns in the row
5. open a file called "Supplier SQD Master.xls" and input the data into the cells.
6. Create A folder in Path F:\Copy Test\2015 SQD\Issued using Cell G4 and C5
7. Save the file as G4 and C5 to the created folder but remain open
8. Create a hyperlink in the Problem tracking.xls in Column "R" and the row selected from the input box.
I have it working up to item 6 but I can't seem to figure out how to save the file into the created folder and create a hyperlink into Problem Tracking.
Please Login or Register to view this content.
Bookmarks