Looking to build a solution...

[Tourless]

Hi Folks,

I'm looking to build a solution whereby I check a folder via a unc path and take the newest file and import it into excel. The file in questions will be a .csv file BUT the delimiter is a semicolon (I have no control over that). Not sure if that complicates things. I've been playing around with Excel 2016 and where I can import the file, it fires off some sort of queries and connections wizard which excel does a poor job of capturing into a recorded macro that is then reusable. Part of the recorded macro that generates speaks to the delimiter, number of columns, and encoding of the source file, which may be useful if I'm going to try and attempt this using ms.
I already know how to pick a folder and find the newest file using ms, it's the import into excel that leaves me scratching my head. Any pointers in the right direction would be greatly appreciated.

thanks as always!

[Marcus Tettmar]

You can continue to use the macro in Excel and call it from Macro Scheduler, or rewrite the macro's VBA code to VBScript to run within your Macro Scheduler macro. See:
http://help.mjtnet.com/article/19-conve ... o-vbscript

[Tourless]

Thanks for the idea Marcus. But I'm not sure that's the right way to go... So I'm trying to work with TeamViewer to remote into a PC and perform a few clicks or tabs to accomplish running and saving a report. To that end I'm working with a free version of TeamViewer and at the end of a session (not every session mind you) there is an annoying little pop-up titled Sponsored session.

I know I could simply look for the presence of this popup on my local machine (where my script is running) but when I connect to the remote machine through TeamViewer, is there a way I can search for the existence of that pop-up, and if it exists, give it focus and click it's OK button? I'm thinking this is a good case for image recognition but I'm not sure how that's going to work on a remote session. I guess trial and error will be my guides. But if anyone has any other ideas how I can account for and eliminate the pop-up, I'm all ears!