0

I am really only used to using VBA for scripting so this is a very new world for me. With that being said I am trying to write a script out that will be able to find a .txt file based on a user input and then import said file from my C: drive into a blanksheet in the workbook. Is this a capability that Apps script has?

Tyler Ashmore
  • 1
  • 2
    If you perform the file upload from a dialog or web app with an html element – Cooper May 24 '21 at 19:17
  • 1
    Google Apps Script is built around Javascript and many people that know javascript are familiar with web development so it's a natural thing for us to build interfaces with html, css and javascript. And google makes it even easier to access the server with google.script.run – Cooper May 24 '21 at 19:21
  • The "based on user input" bit suggests that the import is done interactively. What is stopping you from simply using **File > Import**? – doubleunary May 24 '21 at 20:23
  • Finding the file on your computer is your computer is not a google apps script capability since it runs on Google Servers. – Cooper May 24 '21 at 20:27
  • Cooper- thank you for the insight here I am trying to go down the html path you suggested. I understand the capability is not there for the exact solution I am looking for and am trying to redesign this system. – Tyler Ashmore May 24 '21 at 20:32
  • doubleunary- the reason that I am looking to automate this process is because the tasks after the import requires alot of data manipulation. I do understand that I will be able to write a script to do what I need post import. With how green I am to javascript and sheets I was unaware of its capabilities and wanted to see how complete I could make the macro. – Tyler Ashmore May 24 '21 at 20:35

0 Answers0