Forum

Hi Rameez, There is no acreenshot attached, make sure you press the Start Upload button after you select files. have you tried recording a mac...

Look again at your code, you will see that ".Show" is found twice in your code. If you use .Show 10 times, it will display the dialog 10 times.

I don't understand the problem, looks like you know how to join pieces of text together. Why not adding the location to your formula: ="\mtlnas0...

how to put in cell a105 to put the complete file path in the formula. What formula you have in A105? And where is the folder location?

Put the full path in E3, not just the file name. Or, put the network folder address in code before E3 value: NetworkPath & ActiveWorkbook.Ac...

Hi Louis, You'll have to use vba for this. Basically, make changes in only 1 workbook query, and the query text will become the reference for al...

Hi Klaus, Formulas will not work, you will need a vba solution for this. Please provide a sample file with a manual example showing before and a...

Can't use the file you sent, macro 4 functions are blocked on my system. Anyway, they will removed from excel, why concentrating on a solution that wi...

No, will not work. Why don't you use the example I sent? your double quotes are not properly added, already gave you the correct string: "<a ...

According to HTML language, that's the way to create a hyperlink: It's the only way.

If works from excel, it should work from vba as well. Try with background query set to false, otherwise vba will not wait until the query finishes....

Hi Jose, You have to use the href tag: "<a href=""" & LinkHere & """>" & ActiveWorkbook.FullName & "</a>" Are you...

Try: save_name=Activesheet.Range("A105").Value Make sure cell A105 has the extension as well, not just the complete file path, if not, ...

Hi Sajil, To compare different periods, you have to build a different structure, see this example:

Great, glad to hear you managed to make it work! 🙂