Convert Cell Formula into VBA Application.WorksheetFunction

[razzandy]

Hi Guys

I am trying to find out how to use Application.WorksheetFunction. to simply use the =

I want to change this:
[a1] = "='C:\Users\Work\OneDrive\CloudStation\Systems\Stock Sync\[Stock Synchroniser.xlsm]MainCall'!$B$28"

Into something like this:
Variable = Application.WorksheetFunction.Equals("C:\Users\Work\OneDrive\CloudStation\Systems\Stock Sync\[Stock Synchroniser.xlsm]MainCall'!$B$28")


Is this possible?

Thanks in advance

 

[Domenic]

Try...

x = Application.ExecuteExcel4Macro("'C:\Users\Work\OneDrive\CloudStation\Systems\Stock Sync\[Stock Synchroniser.xlsm]MainCall'!" & Range("B28").Address(, , xlR1C1))

Hope this helps!

 

[razzandy]

Thanks Domenic, that works great

How did you find that? I have looked everywhere!

Try...

x = Application.ExecuteExcel4Macro("'C:\Users\Work\OneDrive\CloudStation\Systems\Stock Sync\[Stock Synchroniser.xlsm]MainCall'!" & Range("B28").Address(, , xlR1C1))

Hope this helps!

 

[Domenic]

Thanks Domenic, that works great

You're very welcome!

How did you find that? I have looked everywhere!

This particular method was briefly mentioned in a book by John Walkenbach called "Excel Power Programming with VBA". In searching Google, I also found the following links...

https://docs.microsoft.com/en-us/pr...e/developer/office-2003/aa195716(v=office.11)

http://spreadsheetpage.com/index.php/tip/a_vba_function_to_get_a_value_from_a_closed_file/

 

[razzandy]

You're very welcome!



This particular method was briefly mentioned in a book by John Walkenbach called "Excel Power Programming with VBA". In searching Google, I also found the following links...

https://docs.microsoft.com/en-us/pr...e/developer/office-2003/aa195716(v=office.11)

http://spreadsheetpage.com/index.php/tip/a_vba_function_to_get_a_value_from_a_closed_file/

Thanks Again Domenic

I will take a good look at those links, thank you.

Is it Cold up there in Sunny Canada? Wet & Windy in the UK 10oc

 

[Domenic]

10 degrees celcius? So it's warm there?

It's been brutally code here for the last week or two, with snow and icy conditions. At times, temperatures reached as low as -20 degrees celcius, -30 with the wind chill (if I remember correctly). Other parts of Canada got even lower temperatures. So yes, it's been fun.