Thank you Sir for another useful video. I need your small in regards to excel hyperlink function. I am trying to open. txt file in excel after clicking on created hyperlink, e. g. =hyperlink (text file location, friendly name ) This works perfectly for word and PDF files however getting error for accessing notepad file as "cannot open the specified file " I would be greatful if you help me on this. Thanks again.
I just recorded a macro which I'm sharing with you. I added the 2 lines of code for the DisplayAlerts: Sub HyperLinkToTextFile() ' ' HyperLinkToTextFile Macro ' Range("A1") = "MyTextFile" 'Range("A1").Select 'Columns("A:A").EntireColumn.AutoFit Application.DisplayAlerts = False ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _ "C:\Users\takyar\Documents\cleaning-tank.txt", TextToDisplay:="MyTextFile" Application.DisplayAlerts = True End Sub
Thank you once again Sir. The code is really helpful. The formula which I mentioned is working fine in excel 2013 hower it's throwing error in excel 2010 version. Instead of using code I am trying to make my template macro free. Please let me know if you have any further suggestions. Thanks.
Try using the task scheduler to open the file and then call the macro from the workbook_open event. The following tutorials will help: www.exceltrainingvideos.com/tag/automatically-protect-workbook-with-password/ www.exceltrainingvideos.com/launch-vb-script-using-task-scheduler/
@@Exceltrainingvideos sir, edit link option is disable.. i have created queries and cooection from nse websites that i need to refresh daily without open it for this i am using vbScript as u explained. but its cancel refreshing data and simply maro run with same data .....please guide if possible ....may i mail u sir raegarding the same with file.
Thank you for yet another very useful tutorial!👍
Glad it was helpful!
Can I refer to a range of folders, for example if I have such list in exl? So that the system would delete the list of folders
Yes - use the paths.
@@Exceltrainingvideos thank you so much for the vid, it saved me hours of work
Great VBA :-)
Glad you think so!
Thank you Sir for another useful video.
I need your small in regards to excel hyperlink function.
I am trying to open. txt file in excel after clicking on created hyperlink, e. g.
=hyperlink (text file location, friendly name )
This works perfectly for word and PDF files however getting error for accessing notepad file as "cannot open the specified file "
I would be greatful if you help me on this.
Thanks again.
I just recorded a macro which I'm sharing with you. I added the 2 lines of code for the DisplayAlerts:
Sub HyperLinkToTextFile()
'
' HyperLinkToTextFile Macro
'
Range("A1") = "MyTextFile"
'Range("A1").Select
'Columns("A:A").EntireColumn.AutoFit
Application.DisplayAlerts = False
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"C:\Users\takyar\Documents\cleaning-tank.txt", TextToDisplay:="MyTextFile"
Application.DisplayAlerts = True
End Sub
Thank you once again Sir.
The code is really helpful.
The formula which I mentioned is working fine in excel 2013 hower it's throwing error in excel 2010 version.
Instead of using code I am trying to make my template macro free.
Please let me know if you have any further suggestions.
Thanks.
hi can i delete files automatically when a usb drive is inserted.whitout click on a run button ? thanks
Try using the task scheduler to open the file and then call the macro from the workbook_open event. The following tutorials will help:
www.exceltrainingvideos.com/tag/automatically-protect-workbook-with-password/
www.exceltrainingvideos.com/launch-vb-script-using-task-scheduler/
sir please guide me regarding auto update external link query data before macro run or make video in this regard thanks a lot .
Is the external link a link to a workbook?
@@Exceltrainingvideos sir, edit link option is disable.. i have created queries and cooection from nse websites that i need to refresh daily without open it for this i am using vbScript as u explained. but its cancel refreshing data and simply maro run with same data .....please guide if possible ....may i mail u sir raegarding the same with file.
@@Exceltrainingvideos please sir