That clarifies things - thanks.
You could, of course, get by with just one procedure (which you call a macro). You could download the Excel file first and then have a single procedure prepare the data, open the Excel file, save it as a text file, import that file and process the data. But if what you have works, stay with it.
Vic, what app(s) are you using to “prepare” and “manipulate” the Excel file?
Perhaps my original question was not worded as carefully as it should have been.
I have a Pan6 file, with some pre-existing data in it. There are two macros in the file.
Macro 1 within the file prepares the data - basically some sorting, grouping, and coloring of records. There are some calculations also. After that macro ends, from my browser I manually download an Excel file from a website, and save that file as a tab-delimited text file.
Then Macro 2 is actuated, which imports the data from the text file, and “manipulates” the data in a certain way. It is easy to distinguish newly imported data from pre-existing data because the previous data records are colored. Certain records in the combined file are deleted, and the remaining records become the “pre-existing” records for the next time the macros are run.
My objective was to automate the entire process, so that running one macro would “prepare”, download, save as .txt, and “manipulate” final records. Many years of Pan6 spoiled me into thinking the program could do everything except brew morning coffee. What a bummer that it can’t to this!