@dbeato
Param (
[string]$file = 'C:%USERNAME%\fILENAME'
)

in my powershell how to rename here ?

@scottalanmiller Whether this can be used in String too ?

How to mention the default or current user in the Powershell. Like in .bat file we can mention C:%username%\

In powershell it's not working.How to enable that ?

@irj copy part of the excel allignment as well as subject of the mail

@lakshmana I think @scottalanmiller is busy in real,if he is here he would have replied to the thread it seems

@roopankumar Fate

I need to copy the first sheet of the excel sheet to the outlook through powershell where i am referring the below link but the copying is not happening.Help needed

https://social.technet.microsoft.com/Forums/scriptcenter/en-US/21643bfc-40c0-4b2e-8a75-365361f0654e/powershell-outlookapplication-send-email-containing-text-excel-copied-speadsheet?forum=ITCG

@roopankumar What ?

Going to Office on the First day of the Year in First Shift

Can anyone help on the same if not busy ?

I am having the Excel File 1 and Excel File 2 where the contents in the excel file 2 needs to be copied to excel file 1.Whether the copying can be done through the Sheet name ?

I am having this powershell script to copy but the copying is happening but it should happen according to the sheet present.Can any one help on the same ?

$excel=new-object -comobject excel.application;
$excel.visible=$true;
$SourceWorkBook=$Excel.Workbooks.open("$filelocation");
$TargetWorkBook=$excel.workBooks.open("filelocation");
$SourceWorkBook.WorkSheets.item(1).activate();
$SourceRange=$SourceWorkBook.WorkSheets.item(1).range("A2","O2");
$SourceRange.copy() | out-null;
$TargetWorkBook.worksheets.item(1).paste();
$SourceWorkBook.close($false) # close source workbook w/o saving
$TargetWorkBook.close($true) # close and save destination workbook
$excel.quit()

Unexpected token 's' in expression or statement.
+ CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordException
+ FullyQualifiedErrorId : UnexpectedToken

Checking on the same

Downloading the production level tickets in Excel file which needs to be copied to master copy

I am having having 3 Excel sheets where A file is the master copy where B and C are duplicate copy.The master copy Excel has 3 pages and duplicate copy has only one page.I need to copy B Excel file in page 2 of Master Copy and copy C Excel file in Page 3 of Master copy.These things to be done in Powershell is it possible?The first page content in Master copy should not be deleted and the other two pages can be deleted before copying the data

Whether it preferable to install in Coolpad Note5 ?

Okay forget everything.I need only powershell commands which needes fo open the browser automatically and need to go to another page by searching keyword in that website(consider open facebook.com and click on forgot password without human intervention that click option sgojld be through Powershell).Once the keyword is searched there will be a excel is downloaded from the website then that content needs to be copied in automatically to the outlook and that mail should also send automatically without human intervention

@dbeato said in Powershell Help Needed Part2:

@lakshmana said in Powershell Help Needed Part2:

@jimmy9008 said in Powershell Help Needed Part2:

@lakshmana said in Powershell Help Needed Part2:

@dbeato no automate mail from outlook

How does 'Automate mail from outlook' get you to 'PS to select New Topic' on ML?

Need powershell as medium to automate mail

Now you are asking a different question.

No read this post carefully all i need in PS

@jimmy9008 said in Powershell Help Needed Part2:

@lakshmana said in Powershell Help Needed Part2:

@jimmy9008 said in Powershell Help Needed Part2:

@lakshmana said in Powershell Help Needed Part2:

@dbeato no automate mail from outlook

How does 'Automate mail from outlook' get you to 'PS to select New Topic' on ML?

Need powershell as medium to automate mail

Thats not what the post said.

In this post need to select the option in webpage to download if excel is there

@jimmy9008 said in Powershell Help Needed Part2:

@lakshmana said in Powershell Help Needed Part2:

@dbeato no automate mail from outlook

How does 'Automate mail from outlook' get you to 'PS to select New Topic' on ML?

Need powershell as medium to automate mail