procedure

Hello All, I am trying to have three cells filled on a particular sheet when a user opens the workbook every time. Here is the sub getting the values, which in in my module 1 Public Sub Project_Info() Dim P_Number As Range, P_Name As Range, GC As Range Set P_Number = Sheets("CO...

Hello all! I have a spreadsheet that I entered a check mark (letter "a" in Marlet font) into set boxes. I want to write a formula that tallies all those boxes containing an "a" check mark in a given row. How would I write it? Below is an example of the boxes- although it didn't copy right...

Hello: I need some help please with creating a VBA sub procedure. I need to create an If/Thenloop that copies data from field A2 of one worksheet, goes to another worksheetand paste the data in cell S2, calls another sub procedure and then repeatsthese steps. I’ve explained it a little more...

folks, i am trying to match and compare two data sets to ensure we are charging the correct amount. One contains the rates charged for medical procedures (Rates) and the associated service fee charged for ancillary items, and the other contains patient level data (Patients) including fees and...

Macros have been working fine but I must have inadvertently key stroked something while accessing tools/macro. Trying to use existing macros gets "Invalid Outside Procedure" error. I can manually create a new macro but get the same error message when trying to use it.

Hi, at the moment my code copies an excel file from an windows explorer path (Source_path) and puts the file in a new path (Destination_path), opens it and does some formattings and saves it. This procedure should be done on Sharepoint. I don't want to download the file. The source file is...

I have an excel 2007 file which I want to export a selected range to pdf.i used the codes i got from this platform itself but it is showing run tomorrow 5 invalid procedure call or argument . some one pls help ????

Hi Again. This post is still about the check mark problem that I started. That post has now been solved. What I want to know now is the following: The Event Procedure check mark will also activate if you move through the cell with the check mark. Apparently moving the mouse through the cell...

Hi all, I am calling a procedure in another workbook with VBA. The workbook is already open. I am trying to suppress all alerts with application.displayalerts = False. I added the application.displayalerts in both procedures. But after calling the procedure in the other workbook I am still...

Hi All, I'm having a problem when trying to import an SQL stored procedure into excel 365, Step 1: Data tab –<wbr style="box-sizing: inherit;"> > From Other Sources -> From SQL Server Step 2: Enter Credentials. Your server name can be an IP address Step 3: Choose any old table or view. Pick...

Hi all, I have a table of customer who are awaiting or have had a procedure in a table like this: <tbody> Customer ID Procedure Request Date Completion Date 0001 Echo 2018-04-02 2018-05-05 0002 Echo 2018-05-06 2018-05-27 0003 TILT 2018-05-07 2018-05-20 0004 Echo 2018-05-19 </tbody>...

Okay it is what you think :) 1. I made a GIGANTIC code which traverses the entire workbook. And right when I was almost done, I got "procedure too large." This appears to be because the compized size of teh sub is > 64 kb. 2. I do not want to break into two subs, because the setup is so...

Friends, How can I call a stored procedure from Vba Excell for Mac? Thanks

Hi everyone, I want to run a procedure of project in another Workbook (wb2) from current Workbook (wb1) -This procedure was not created by me and too complicated for me to understand. -This procedure has Arguments, like "Case 1","Case 2",etc -I do have wb2 open I was searching and found two...

hi Guys, I have a huge worksheet with a lot of code in it, but everytime i run it, it gives me an error saying the procedure is too large. Is there a work around it? the code is 4000 lines, but most of it is the same thing with the only difference being either the table name, column name, or...

Hi, I tried to post a new thread about 3 hours ago and nothing has come through. Just wondering if this is normal procedure and if a mod could please look into it Thanks

Hopefully, I will explain this well enough for people to understand :)I have quite a complex userform. The issue I am facing is when clicking a checkbox in a different frame it is not ticking on the first click. It takes a second click. I think the issue is there are a number of procedures that...

Hello everyone, my name is Maurizio and my problem is this: using the vba I created a procedure that opens my e-mail that sometimes does not have to be (Outlook) and I have already placed the address of the recipient in his place and so far so good. Then I created a procedure that takes data...

I have the following procedure that works well but my problem is that I need to have the same procedure run on different worksheets within the same workbook. I have tried Arrays unsuccessfully (as I am not good enough at programming) and resorted to copying the same procedure 8 times for the 8...

Hello experts, At my school we need a script/formula to automize a selection procedure. Students have to hand in 4 preferred schools and they also need to mentioned whether they want to start in autumn of spring. Conditions: Based on the rank (column F) the student with the highest score...