declare

Hi All, I just upgraded to Excel 2013 and now am getting an error saying I need to update my code to allow for 64bit. I tried changing to Declare PtrSafe Function but that didn't help. Any help is appreciated. The code that is generating the error is: <code> Private Declare Function...

My apologies if this has been addressed before. If so, I haven't been able to find the right keyword combination to find it. My system is Windows 7 with Office 2010 (32-bit). I have an Excel template which has evolved over quite a few years, and I've hit a new issue. I sent the template to a...

Hello, I am basically self taught with VBA and I am making more and more complex macros. I am finding that my variables are all over the place and I was wondering what the professionals do in regards to variables. Do you declare all variables or just the significant ones? With the...

Good Day All the Code Below works with 32 Bit what code For Excel 64 Bit ? Private Declare Function mciExecute Lib "winmm.dll" (ByVal lpstrCommand As String) As Long thanks

Can I declare a global array that's available to all modules within the workbook, I tried declaring a variant array as Public but it gave me an error

I found this code here in this forum which maximizes the userform to cover the whole screen. It worked for me but I have a multi page form and the multi page did not expand. So I wanna know if it can also expand as well. Then what happens to the controls on it. Will they too expand? Option...

Hi Guys, I have a little problem, everytime when I need to run macro the name of files are changed. I want to automatize it maximally as I can and it need to be friendly for newbies. How can I assign name of chosen files to macros using box like below? Need to run twice this box, choose file...

Dear: everyone! I want to retrieve data as the data string length in the Formula Bar (the formula bar, rather from its Edit Box) I have used the following 1. Declare Private Declare Function FindWindow Lib "user32" Alias ​​"FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As...

hello i am trying to declare a dynamic array with 3 columns. within a for loop i would like to add to the array so it is unknown how many record elements will be in the array. here is what i have so far which is not working 'declare array Dim final_array() As String 'add records to the...

Hello guys. I'm having trouble tryin to declare a function from a dll, in a test case I'm not bein' able to use a function that i made using visual basic in a dll. Error 453 gets on my way no matter what i do. The code in the VBA on excel is: Declare Function TestReturn Lib "(Path to dll...

Hi there, I'm stuck with a search / copy macro in Excel. What I am trying to do is to modify a piece of code I used before. I was searching a range in sheet A (wsOut) for an item X and copy the entire line to sheet B (wsIn) if X was found within the range. I did this through an input box. As...

I need to declare a two dimensional array that will return the Row and the cell's string value. My only solution is to return the row as a string like this. Public GlobalArray(2, 100) As String Can someone help me get more control than this? Maybe I should just declare it as a variant but this...

I am trying to declare a dll function in VB6. The syntax for a Declare statement is as follows: [Public | Private] Declare Function name Lib "libname" [Alias "aliasname"] [([arglist])] [As type] I will not know the name of the dll until run time. So, at run time I read the dll name into a...

Hello All, I have multiple tables (all the same size) on a worksheet that are filled with rates. I would like to be able to populate a different array for each of these tables. Since there are several tables on the sheet, I am trying to create a Sub routine in a module so that I can simply...

Hi, Several people on this board have recommended that I alway use Option Explicit in my VB code (via the Tools, Options, Require Variable Declaration option) Firstly, what is the thinking behind this (or what are the implications of not doing this?) Secondly, When I have a lot of code, I...

I have a bunch of Variables that I have in one workbook and I was wondering if I could declare it for the whole application rather than just the project. Example for Main Workbook: Option Explicit Public Shop, Shift, Name as String Sub Add Shop = "Engine" Shift = "Days" Name = "Ted"...