Hi all,
please help me with the compile&correction of the following code.
On short:
(Done)1 - I am in the AR sheet (where I work, "FORM" workbook);
(Done)2 - press the "Update" command button;
(Done)3 - delete all records from the AR sheet (active sheet);
(Done)4 - WindowsExplorer opens to choose the .xls document;
(Pause)5 - the selected document opens;
(Done)6 - copy column A from the only sheet existing in this document (so the sheet is pre-activated);
(Pause)7 - the source document is closed;
(Pause)8- the AR sheet is reactivated (workbook "FORM" - I think, I hope) where it pastes only values in column A;
(Done)9- find and replace non-compliant characters;
(Done)10 - sort and filter the information according to the criteria;
Step 3 - they need 2 times because they are filtered
Step 4 - open WindowsExplorer for selecting the file( I don't know how to open the selected file, or rather in Worbook.Open I don't know how to integrate WindowsExplorer to select open file)
Step 6/8 - copy&paste values from/in Column A
Step 9&10 - like a charm
I appreciate any attempt and thank you in advance for your effort!!!
and a question of my level, noob:
do I write the code in the sheet code or in a separate module that I call with the Update command button?
Bookmarks