application

Hi guys im currently on vacation and running my spreadsheet on a sub par laptop. On my workstation everything works great but after I started using it on win 7 32 bit on my laptop I have revived a bunch of errors when I run my sheet but I have fixed most of the problems but I get error with...

I just found out that I would have uninstall my 64 bit Windows Office 16 with the 32 bit version because one of the databases we have was written in the 32 bit version. Will my Excel 64 bit files open in the 32 bit application without losing any functionality? I have some formulas in some...

Dears, good morning! I developed an application to access a web page. I encountered a problem after login. When clicking on the "Submit" button, a form will appear to select some combos, while the macro is waiting to close the form to continue, with this message: "Waiting for another application...

Hi If you write an excel application that will be distributed to a high number of people. You dont know what excel version they use etc. How do you go to be sure the application will work for the highest possible number of people?

Hey Guys, Im trying to create a macros for an application report. the report contains application data and the status if they're expired or not. for each application which is expired, i want to email the whole row of data to the owner and the technician. the names are also in the same row...

Hi everyone, I'm trying to create a function in VBA to find the annual volatility of a specific stock price. I have all of the numbers on my worksheet titled "Historical Copper Prices", I'm just having a hard time defining my ranges and executing the function. 'N' is around 150 right now but...

I know this topic has been addressed before. I wish to select multiple items from a drop-down list and have them presented in a single cell, separated by commas. I have read the relevant threads, and I am afraid I find them too complicated to understand, and all my efforts to use VBA code...

Hello! I have a program, which consists of two parts. First part is my Delphi program “logo”, which runs an Excel file. This is the Delphi code: procedure TForm1.Timer2Timer(Sender: TObject); begin timer2.Enabled :=false; XL.Visible := true...

In A1 I have 43244 Software Application. I want it to be 24/05/18 Software Application. I thought combining TEXT and LEFT would work but it doesn't.

Good Morning, I am looking to create a VBA that copies text data from an application row by row and pastes it into column A as part 1, then part 2 takes the Column A text data and then adds _Name at the end in Column B and lastly copies that data an pastes over the previous information in the...

Dears, good morning! I developed an application to access a web page. I encountered a problem after login. When clicking on the "Submit" button, a form will appear to select some combos, while the macro is waiting to close the form to continue, with this message: "Waiting for another application...

Hello All, I am attempting to create a Macro that updates the naming convention in a specific application. In this Macro I will have 1 column that lists account names starting with T001 and goes all the way to T100, in the application I will be using all accounts should be listed in the same...

Good Morning All, I currently have a excel macro that uses SendKey to update an application. The current code works off two columns in excel (1) Has the name of the function (2) Has the Total Percentage for the function. The Macro checks the name by copying the application data and pasting it...

Hi guys, I rebuilding application and moving database from Access to SQL Server Management Studio. I want to add access level for application rather than add every user to access (Application doing all user validation). I am not really fluent with SQL. Can some one advice what am I doing...

Hey! Is it possible to open a file of an other application than Excel, but opening same from within Excel? I was trying to establish by using a link in an Excel cell, but the system does not work, it continues telling that the file cannot be opened, because there is no application to open it. I...

Hi! I have an excel form that updates a tracker when a user selects a button. Is it possible to make the application open as if it were a standalone application without the Excel logo splashing on the screen? I have a button that updates the tracker, I dont mind then, showing Excel, but...

I have a VBA Excel-based timesheet program that allows employees to submit weekly timesheets. The application itself takes charge of creating each weekly timesheet and saving it to a specific network location (ActiveDirectory). At other times, the application also needs to be able to read...

Hello, I have written a macro to open an external application in excel, which works file however when application opens up a pop up window open ups too and I need to select "Connect" button from the message box. Would anyone know a VBA coding I could use to perform this action? Thank you.

Hi all, With Excel 2013 running under Windows 7, I am recently experiencing screen refresh problem. It happens most often when I switch between application, or sometimes when Excel is comming back from executing a macro. My screen does not display Excel. I know it is there an activated since my...

Hello Everyone, I recently started working with Excel, and VBA for that matter. I currently have an application that exports its data to a new excel sheet, And I would like to be able to click a button, Copy the data from the sheet I need, and paste it into my current workbook. I figured out...