This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have an online program that lets me export an excel file.
I then have to edit and manipulate this file further before I can be done.
This is tideous and is done about once a day if not more. I'm hoping to use a Power program to automate this. Please tell me which program is best to use and how i can manipulate the excel program in the best way.
This is my process:
Every file gets an additional 4 lines above and below the row that states "visit total"
and the top 4 each row gets a name in column A and a value in B
the bottom 4 get a name in column A and a formula in column B thru where ever
One of the lines also would import data from another file.
They whole entire thing would then also copy formatting from another excel document.
Do I create a form and use that? or will it be easy to add code to manipulate this?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 25%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
You could use VBA to connect to the website and export the data. Or you could use Power Query.
Without details of the process it's hard to say which approach is best.
The data manipulation could also be done with VBA or PQ.
Please supply detailed explanation of how you connect to the site and export the data
Phil
I planned on having the file already downloaded an put onto my share drive or teams drive. which ever.
But the issue i'm having is how to actually automate the manipulation.
tasks:
1 add 4 rows above row "visit total"
2 add rows below row "visit total"
3 add column B
5, copy formatting from exisiting excel file
....
Sounds fairly straightforward if you can supply a sample file to work with. Plus the file you want formatting taken from.
You also need to clarify:
Phil
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 74%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Use whatever search engine you prefer and look for "powershell excel module". You'll find the module ImportExcel and many other posts about manipulating Excel with PowerShell.
@ SamirNarang-9818
We are responsible for general issues of Office desktop clients but your issue is more related to Power program.
In order to give you an authoritative answer, it’s recommended to post your issue on the following forum,
Excel for developers.
Thanks for your understanding.
Regards,
Erin
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
I believe that it is best if you enable the developer module and use macros or VBA.
