Search results for query: *

Hi Skip I have overcome the problem (must have been timing out) by using a view on the SQL Server db and selecting all from that, rather than running the complex SQL query in Excel. I guess there is a limit to how much processing Excel can do (via MS Query) within the allotted timeout period...

Hi Skip I tried that for an hour .... You can tell if the query is running by looking at the Refresh Status icon in the External Data tool bar. If the icon is greyed out it means that the query is not running. When I run the query it lights up for a few seconds and then greys out again, but I...

Hi all. I am trying to import data from a SQL Server database into an Excel spreadsheet. I have done this before using the exact same database with no issues. However, this time, when I go through the exact same process (Data > Import External Data > New Database Query, select datasource...

Hi, I need to encrypt data in C# and decrypt that same data in VBA. Does anyone know of how I can do this? Thanks [bigsmile]

That looks as if could well do the trick. I'll give it a try - thanks!

Hi I am trying to create an array from a comma seperated string. I have been trying to use the Split function but the version of VBA that I am using (VBA332 - unable to change - am running a Macro in a Reflection session) does not include the VBA.Strings.Split functionality. All help would be...

Thanks for the interest guys but I have moved on from the SPLIT idea and have used the resolution from thread222-1279342 to great effect. :-)

But not VBA

That looks like it should do the trick. I shall give it a go. Many thanks Jerry!

Hi Skip, Thanks for that. It would probably work but I don't have 'split' available in my object library. I have tried adding Excel 9.0 object library (the only Excel library available on this server) but it still does not compile. Also, this looks OK if I have only 1 parameter but I have...

I know that people will suggest using a different method to access the data in the ini file - I'm not proud - as long as I find a method that works i am happy! Just tell me what it is! (-:

Hi I have an ini file that I am reading to get parameters for my VBA macro. For set length values I have no problem using the code below to extract the string from the ini file. However, if I want to extract a file path that may have different lengths I do not know how to handle that. Any ideas...