Need help with a VBA script for excel

-Sorry if this post belongs elsewhere. Ask is exactly right I’m seeking help on coding and it’s specifically VBA related to excel <br><br>I’m trying to automate an import process with an excel sheet. The excel sheet has a summary tab, 2 data tabs, and 1 tab for formulas. I’m using two data tabs, one for a standard feed and another for carrier specific feeds. When I’m done I’m importing into my google analytics platform. <br><br>I’m trying to automate this process with a VBA script. To be clear I’m looking for help automating the process, I don’t need a code hand out. I’m trying to learn it. <br><br>I’m bringing in two data feeds from different ftp servers. I want to automate the process of importing those feeds into the respective data tabs, replacing all the data in those tabs. That will automatically update the formulas tab and then a pivot summary in the summary tab. I’m not done yet. <br><br>What I’m looking for here is help with the following:<br><br>- VBA Script to update the query in Data Tab 1 from an FTP Server import. I have this working but only if the file is saved in a specific location on my desktop, I’m trying to change that. <br><br>- VBA Script to update the query in Data Tab 2 from an FTP Server Import. It does not work at all. <br><br>I want to be able to point the import to the FTP servers but I’m having trouble with that. Any advice on how to make that work?<br><br>&#x200B;