Write VBA Code to automate Excel for $25

Hello, I will help you SAVE Hundreds of Hours for Excel Tasks Why choose me? 1. You will receive Professional Excel Workbooks. 2. You will be working with Professional Excel Programmer and is Professional to work with. 3. You will enjoy how incredibly fast and convenient my process from pre-ordering to after sale service. 4. I provide Extra Fast Delivery Service. 5. My service is available 24/7. 6. Life-time support. I still support you even when your order is finished. 7. I always offer you Unlimited Revisions until you’re 100% Satisfied or Money Back Guarantee Feel Free to contact me if you have any concerns or questions Come with me to experience One of The Best Services on SeoClerk Thank you and Look forward to working with you.

by: Tommy1003
Created: —
Category: Coding
Viewed: 210


Using Selenium to automate data entry

We have a report that generates ~100 rows daily and our customers have to enter the data into third-party software. We hoped that the software allows some kind of data upload so that our customers don’t have to do the tedious data-entry, but it’s not happening. So, we are thinking to provide a solution to our customer by implementing an automated data entry system utilizing Selenium (I’m very new to Selenium). To achieve this, we have to use a real user’s credential for login and a SQL connection credential and we came up with these two ideas:

  1. Use Python/Selenium, credentials hardcoded in a separate file, schedule a SQL Server Agent to automatically run this script daily.
  2. Implement a web user interface with C# in Visual Studio, credentials hardcoded in an encrypted web.config file, let user click a button to run the Python/Selenium script. (this will be a semi-automatic option but it gives users flexibility in choosing what to enter)

(We could take user’s credential as a parameter to run the tool in order to avoid hard-coding a user’s credential.)

I know it can be done but should Selenium be used to automate data entry in the security standpoint?

How to Automate Unit test for HMI application?

I have the requirement like this: . Write python script, which run on the test Machine and interact with HMI Application.

· Automatic test can trigger the command from HMI (Button click action) / take the screen short of widget / screen for the status indication and compare it with expected results (compare with expected value/ pixmap) .

· Automatic test run every night and generate the test report of executed test cases.

Please, suggest some good solutions as this is very urgent.

Thanks, Aniprada

Magento 2.3 How to automate custom cron job from custom module?

I am working on Cron from custom module to send email from custom cron job, I created it as below but the cron job is nor working on the server.

<?php namespace Name\Module\Cron;  use Magento\Framework\Mail\Template\TransportBuilder; use Name\Module\Model\MyModule; use Magento\Customer\Model\CustomerFactory; use Name\Module\Helper\Data;  class RfqCron {  protected $  _logger; protected $  customerFactory; protected $  transportBuilder; protected $  helper; protected $  _myFactory;  public function __construct(     \Magento\Framework\App\Action\Context $  context,     \Psr\Log\LoggerInterface $  logger,     \Magento\Framework\Translate\Inline\StateInterface $  inlineTranslation,     \Magento\Framework\App\Config\ScopeConfigInterface $  scopeConfig,     \Magento\Store\Model\StoreManagerInterface $  storeManager,     \Magento\Framework\Escaper $  escaper,     TransportBuilder $  transportBuilder,     CustomerFactory $  customerFactory,     Data $  helper,     \Name\Module\Model\ResourceModel\MyModule\CollectionFactory $  myFactory ) {     $  this->_logger = $  logger;     $  this->helper = $  helper;     $  this->_myFactory = $  myFactory;     $  this->customerFactory = $  customerFactory;     $  this->transportBuilder = $  transportBuilder;     $  this->inlineTranslation = $  inlineTranslation;     $  this->scopeConfig = $  scopeConfig;     $  this->storeManager = $  storeManager;     $  this->_escaper = $  escaper; } public function execute() {     try {         $  myCollection = $  this->_myFactory->create();         foreach ($  rmyCollection as $  myData) {             $  customer = $  this->customerFactory->create()->load($  myData->getCustomerId());             $  customerInfo = array(                 'name' => $  customer['firstname'],                 'email' => 'xxxxxx@gmail.com'             );              $  currentDate = date('Y-m-d');             $  myExpireDate = $  myData->getExpiryDate();             if ($  myExpireDate == $  currentDate) {                                     $  templateId = $  this->helper->getConfigValue('mysettings/my_customer_notification/customer_email_template_expire');                 $  emailTemplateVariables = array(                     'email' => $  customerInfo['email'],                     'name'   => $  customerInfo['name'],                     'msg'  => "email sent from cron"                 );                 $  storeScope = \Magento\Store\Model\ScopeInterface::SCOPE_STORE;                 $  this->helper->sendEmailToCustomer(                     $  templateId, //email template id                     $  emailTemplateVariables, //variables                     $  customerInfo //receiver                 );                  $  myData->setMyStatusId(4);                 $  myData->save();             }         }         $  this->_logger->addDebug( "Message sent" );         return;     } catch (\Exception $  e) {         $  this->inlineTranslation->resume();         $  this->_logger->addDebug( "Message not sent" );         return;     } }   <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Cron:etc/crontab.xsd">     <group id="name_module_cron_group">          <job name="mycron" instance="Name\Module\Cron\MyCron" method="execute">             <schedule> * www-data PHP /bin/magento cron:run</schedule>         </job>     </group> </config> 

How I automate the installation of an Ubuntu image using a usb device?

I have to automate the installation of a Linux image. The perfect behavior would be that I plug the usb, turn on the device and it runs the ‘dd’ command in order to flash the image stored in the usb into the device. Ideally only the USB port can be used. What I think maybe could be done is to launch a script from the usb that changes the configuration of the device and copies a .sh file, reboots it and uses that .sh file at the beginning to, using the dd command, flashes the image that is stored in the usb into the device.

How to automate read/download/upload files to SP365 with VBA

The old Sharepoint allowed to read, download and upload files automatically. We have automated processes that get daily files for SP, make calulations in Excel with the data from SP, and upload resulting reports back onto SP. With the new SP, these programs fail. I have spend most of the past two weeks in looking for ways or people who can write the VBA script to overcome this problem. Any help is appreciated.

How to automate the mounting of a Samba shared directory ith each reboot (fstab already created)

I have two Linux/Ubuntu boxes.

  • Box A (192.168.1.10): works as a file server, with Samba installed. It’s always switched on.
  • Box B: workstation with my office tools, which I reboot each time I need to work with it.

In Box B, I have ‘/etc/fstab’ modified:

//192.168.1.10/SambaSharedDirectory /mnt/SambaFiles cifs username=tom,password=foo,rw,iocharset=utf8,file_mode=0777,dir_mode=0777 0 0 

However, each time I reboot Box B, I have to do ‘sudo mount -a’ to mount the file directory of Box A.

Is it possible to automate it to avoid mounting it with every reboot? Thank you very much.

How do I automate my Pathfinder game?

Especially when running complex combats with lots of NPCs and especially when those NPCs have a lot of options, I constantly feel like I’m missing some.

Which problems did I encounter while running Pathfinder combat as a DM?

I’m going to give examples taken from my current run of Curse of the Crimson Throne, anniversary edition. I have changed the builds to suit balance needs and personal taste but the general composition of the encounters might be a spoiler to you. Hence the spoiler tags.

When life lets me, I ready .txt character sheets in advance for all characters I rebuild.

This helps me greatly because templates often exchange or change how class features work and it’s also helpful to have a list of all combat options sorted by action type.

The file also holds:

  • a counter of all per-day or per-encounter abilities
  • a tally of ki/grit/panache points
  • rounds of rage, bardic performance or similar abilities if it’s likely it will matter in a single combat
  • rounds of conditions applied by the party or by allies.

Yet I don’t feel like I’m in control of it all, and I’m not the kind of DM that likes to just swing with it.

Keeping track of every effect of PC attacks (usually damage + debuff + another debuff if I fail a save which I have to roll while taking notes and answering questions and checking character sheets and checking rules) is hard and I often forget to keep into account that tanglefoot bag, and what does staggered do anyways, and was this character prone?

So, from yesterday’s game:

So it looks like I’ve both been lacking in completing my character sheet (my list of things I can do with each action type was missing pieces), I was constantly referencing the list of feats, maneuvers and class abilities instead of the list of things I could do and basically forgot to use 3/4 of them anyway.

Let’s not talk about the undead. I have no idea what the undead subtype entices. I have no idea what some of the monster’s class features (especially domain powers) or racial features do. I mean, I didn’t rebuild that character so I just ran it by the book. The statblocks are lacking and D&D 4e pampered me with its complete statblocks and limited list of conditions.

Luckily the other human NPC got paralyzed early and did nothing the whole fight and the outsider went well despite forgetting to take an AoO due to the threatened range.

The actual question

What can I do to streamline and automate most of these things, with the aim to make less of a mess nad enjoy the game more?


Context: why am I asking?

(A.k.a. “don’t you have a plan of your own, Zachiel?”)

I’m currently thinking about using MapTools with a Pathfinder framework but I have no idea if the frameworks do what I need (keeping track of everchanging bonuses, listing all things a character can do possibly at the right time – like asking me if I want to use power attack or lunge when I declare that I want to attack – and possibly applying buffs according to where characters are on the map, being compatible with Path of War material).

On the other hand, readying characters in MapTools looks a worse hassle than my current method, so I’m asking this question in order to see if there’s any alternative.