Search:

I wasn't really sure where to put this on the forum. My current development environment is limited to using a single thread and I'd like to find a way to utilize all CPU cores that my machine offers...

OptionBase1, thank you for the suggestion. I did not think of doing that. It works great. I had to add some extra code to actually get the 10th value in dz(), because (i mod 10) evaluates to 0 when i...

I feel like I have been coding for too long this afternoon, because for the life of me, I can't find a solution to what seems to be a simple problem.

I have an array that I need to extend multiple...

So maybe I need to make w() a Variant instead? I gave it a try and I still have the same error. Is that what you were referring to?

Here is a specific VBA example of what I am trying to accomplish, and the work I have done so far:


Dim w() As Double: ReDim w(3, 3)
For i = 0 To UBound(w)
For ii_ = 0 To UBound(w, 2)
...

So I'm trying to write a function that can do Dot Product calculations on arrays. I want to use the SumProduct worksheet function to do this. I demonstrated what I'm trying to do on the worksheet...

Hello all,

I’m using VBA Regex for the first time. It works pretty good. Except for a few things. I’d like to create a search pattern that can detect all Unicode characters and Unicode numbers....

I'm not sure why it worked for you and not me. The only difference I can see is that I'm running Excel 2010. Maybe 2013 has the advantage? In any case I did find a solution by posting the issue on...

Hello, thank you for the suggestion!

I didn’t consider a Byte array. I totally forgot about that data type. You don’t really use it often in Excel I guess.

Anyway, I was in-fact able to...

Hello,

Thank you for your suggestions WestConn. I did however decide to consider OptionBase1’s advice and go with arrays. So far, it’s been much easier to use than my original methods of string...

Sorry - double posted on accident. How to delete?

Hi, I have my own reasons for avoiding multidimensional arrays and variants. I like working with strings much better.

@OptionBase1, thanks for the suggestion.

Is anybody else willing to work...

Hello all,

I'm working on my own custom VBA Matrix Operations functions. Ones for matrix multiplication, addition, subtraction etc... Mainly for some linear algebra I have to do, and the native...

From what I know, VBA runs at most, on a single thread. I’m processing a lot of data through some linear algebra functions I developed. I’m processing a 20,000 by 5 volume of data (20K rows and 5...

Are there any API functions out there that can build an image based on some kind of encoding? I'm looking to build some functionality, that will piece together images based on selection of items in a...

Hello All,

I developed a feedfoward neural network in Excel VBA. It works as expected, except for the occasional overflow error. Which I expected at some point to be honest. I know VBA is not the...

So I know Neural Networks can be complicated subjects. Which is why I am here. I am looking to use a neural network to analyze data and make predictions based on the data. I don’t really have access...

Hello everyone,

So I just started getting into machine learning and it’s been a lot of fun. I took some online courses on Pluralsight to help me get started with TensorFlow, Googles machine...

Hello,

I need some help with Excel. I’m using VB.NET to try and access certain buttons on the ribbon. I need to “click” one of the buttons. As it is, I’m using late binding to actually create the...

Hey everyone, so I am wondering if a certain function is possible. I would like to be able to overlay a video on the desktop so it behaves in the same way a background would. I would like to do this...

Okay here are some results:

First Ten Bytes:
{0:X2} 241
{0:X2} 209
{0:X2} 69
{0:X2} 9
{0:X2} 229
{0:X2} 166
{0:X2} 20

Hey SittenSpyne, I'll try and do that first in the morning to see what we come up with. Thanks for your help.

As for my co-workers, well they don't have access to my files. Nobody does except...

Gosh I wish I could post it but I can't. I'm not worried too much about getting my work back. It was stuff I didnt really use that often. I'm more concerned about security issues. Is it likely just a...

Okay this is weird. All of a sudden code I have saved in individual .vb files are all in chinese or Korean (I think). This code for my workplace, not at home, so I can't post any of what I am seeing....

The arrays are actually declared publicly at the top of the module. Otherwise I couldn't use them throughout the rest of the subroutine. They are actually inside of an If Statement that is dependent...

Okay, thank you for the fast response! So I went ahead and tried using the StdPicture object as an array. I think I am doing it correctly, but not entirely sure.
It didn’t really improve the speed...

Hello everyone,

So I am trying to use an image control box to play an animation. I know that it cannot it play an animated .Gif file. So what I am trying to do is, use a series of images that will...

okay, this is pretty cool stuff. I'm actually a part video game developer and I do a lot of 3D modeling. When I saw this though, I had to investigate it:
...

So I’d like to be able to be able to apply a GIF to my desktop wallpaper and let it play. I am working on Windows 7 (my workstation, not my home PC). I know that there are no native features in...

Okay, well that makes sense. I did actually do some googling on the error as well and I found this article:...

What methods can I use to track down any potential memory issues. Generally speaking if an application states that I am low on memory and it is struggling through a process, what can I do to actually...

So I am curious if anybody knows of any software that can actually compose music? Like write a score of sorts. I think I heard of an AI that was able to compose a symphony. I can’t imagine it was...

Well, I think the database will be central. If it was local to each installation, wouldn't that require the user to download all of the data onto there device? I was thinking of using a central...

Hello everyone,

I am looking to possibly design an application to interface with a database. The application in question will be used primarily for Real Estate investors to look at properties. I...

Is there a way to cut down on development time for an application framework? Sort of like skinning? Where like in web design, you can simply buy or use free templates as a basis for your designs, and...

Is there an equivalent in VB6 to the .Net
System.Runtime.InteropServices.Marshal.BindToMoniker() call? I would like to be able to call this in Excel for specific reasons.

How do you step through code in Visual studio? I have Visual Studio 2012 Professional Edition. That would be much easier. I am working in an interpreter, and I typically don't compile executable...

I actually didn't even post the correct pseudo code. I'll probably update the post tomorrow and perhaps use some real code that is slightly modified. One mistake in my post is where in the loop I do...

I am trying to use a Do While Loop to get something done, but I am having an issue with a variable.

The While loop is conditional on the value of a variable, and it is supposed to stop when the...

I guess I'm not the only one with the problem. In my particular case I think the issue is probably the HD. I don't think it is responding when the computer wakes up. Hence no display. I mean, if the...