Hey Friends
following code not working, getting error in highlighted part,
Please suggest me how to fix this.![]()
Please Login or Register to view this content.
Thanks in advance
Sagar007
Thanks in advance
Hey Friends
following code not working, getting error in highlighted part,
Please suggest me how to fix this.![]()
Please Login or Register to view this content.
Thanks in advance
Sagar007
Thanks in advance
Sagar
Arise awake & stop not till d goal reached
Maybe, change too:
ActiveWorkbook.SaveAs Filename:="E:\Inventory & " - " & Format(Now,"dd-mm-yyyy") & ".xls", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False
That line should be![]()
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Both Code are not working, for further details please see attached workbook
Try this
![]()
Please Login or Register to view this content.
Hi Arlette
Thank you very much, working perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks