Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17







Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Share tech news, updates, or what's on your mind.

Sign up to Post

Is it possible to bypass the need for a LAMP server (LAMP = the Linux operating system, the Apache HTTP Server, the MySQL relational database management system (RDBMS), and the PHP programming language)?

I am looking for a way to simply put some files on a file share for a specific group and let everyone have access to whatever is required to run the application, but without having access to a full LAMP server.

Can writing php files that conform to newer standards accomplish this?  If not, is there any way to accomplish this without any installs?
Technology Partners: We Want Your Opinion!
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Dear Respectable Experts,

i need help below code attached function Extract a number from a string value and returns numbers as string i need that it returns number as value or number please help me if it is possible.


Option Explicit

Public Function ExtractNumbers(AValue As Variant) As String
  Dim Character As String
  Dim Index As Long
  Dim Result As String
  Dim Value As String
  Value = CStr(AValue)
  For Index = 1 To Len(Value)
    Character = Mid(Value, Index, 1)
    If IsNumeric(Character) Then
      Result = Result & Character
    End If
  Next Index

  ExtractNumbers = Result
End Function

Open in new window

I have a 2 paypal accounts one personal the other is business. In my personal PayPal account. There is an option

Web site preferences Send your clients to my website after a payment

I have made extensive programming to use this option

In my business account at PayPal nobody seems to understand that I need the same functionality in my business account

So in my business account I need clients to be sent to my website to update my database (for example)

Does anyone know how to go about this in the business account?

I want to use VBA to populate the cells in a single column with the following formula.


where A2 is the starting location of the text that I am searching for "501020", and C2 is the starting location of the result (x or Y).  Each subsequent row would have different text in column A and the appropriate result in column C.  The number of rows in the worksheet will vary ranging up to 500 rows.

I want to duplicate the same results that I get if I copied the above formula in C2, and pasted it down to the last row containing data in column A.

I have a dashboard created but wish to link some of the information to the data behind it, for example, showing on the front sheet  I wish to look at points 6-11
1) Overdue tickets - done
2) Open Tickets - done
3) Problem tickets - done
4) Completed tickets - done
5) Unassigned tickets - done
6) The person who has been assigned the tasks most often - support on this
7) Which user has reported the most tickets - support on this
8) How to check your ticket (based on the data in the IT Action List) - is there an easy was of a user clicking on a button which then displays the tickets they have reported
9) Top 5 categories reported (number of instances) - chart
10) Top 5 subcategories (number of instances) - chart
11) Open tickets by category - pie chart

Kind regards, Stewart
Hi, I have a couple of macros which needs to be run automatically every day. However after opening the sheet I need to move the tab and press CNTRL+D to download the file. HOw can do that automations. Please advise

Is it possible to insert image (location map ) in the sheet using VBA if I save all the respective images in a folder with Project code as name.

Say for example if I have DS101.jpg ,DS102.jpg (Project Code column in datasheet) saved in a folder. When I run the macro it fetches the respective image for each project and insert at a specified range (Location) in the template.

Please find the attached excel
I have a datasheet and a template. I need to create around 30 worksheets(in the same workbook) using the data . When I run the macro with 7 sets of data it is working fine (execution time: 3 minutes). But it is hanging if I enter more number of data.

Please find the code I am using:

Option Explicit

Sub PTOTemplateFill()

Dim LastRw As Long, Rw As Long, Cnt As Long
Dim dSht As Worksheet, tSht As Worksheet
Dim MakeBooks As Boolean, SavePath As String

Application.ScreenUpdating = False  'speed up macro execution
Application.DisplayAlerts = False   'no alerts, default answers used

Set dSht = Sheets("Datasheet")           'sheet with data on it starting in row2
Set tSht = Sheets("Project Page Template")       'sheet to copy and fill out

'Option to create separate workbooks
    MakeBooks = MsgBox("Create separate workbooks?" & vbLf & vbLf & _
        "YES = template will be copied to separate workbooks." & vbLf & _
        "NO = template will be copied to sheets within this same workbook", _
            vbYesNo + vbQuestion) = vbYes

If MakeBooks Then   'select a folder for the new workbooks
    MsgBox "Please select a destination for the new workbooks"
        With Application.FileDialog(msoFileDialogFolderPicker)
            .AllowMultiSelect = False
            If .SelectedItems.Count > 0 Then    'a folder was chosen
                SavePath = .SelectedItems(1) & "\"
                Exit Do
In the sample file attached on OCEAN tab there is raw data and on DATA tab formulas display values looking at the OCEAN tab and the other tabs on the file.  

I have been trying to copy the formula range B2:AG2 down according to the criteria in A2 cell.  If the value in the A column is 1 for the corresponding range Excel should copy the formula range down. When no value shows in A column it should stop copying down the formulas.  

The formula in column  A goes down to the row number 100,000. As an alternative I did this simply by using IF logic for each formula cell but this is not how I want to achieve this. I don't want to fill up the whole range all the way down to corresponding number of rows on the OCEAN tab.  I tried to come up with a VBA procedure to accomplish that but was not successful.  

I would appreciate if an expert can help me to do this by adding a VBA procedure.

Thank you
I am curious about finding the cost to a big bank to process something like a bank transfer from one account to another...

I am thinking about my bank, where I have two accounts, where I may move a few hundred dollars from one account to another.

Is the cost less than a penny for such a transaction for a website or an iPhone app to make such a transfer? I assume there are overhead costs where auditors review blocks of transactions, but I am not asking about that. Just the marginal cost for a hosted and highly secure website to process a transaction.

Does anyone have an idea about this?
Free Tool: Port Scanner
LVL 10
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I'm a Beginner. Skill Set means Which Web technologies needs to learn.and how to learn like training manual,courses,books,Practice,Senior's Guidance.I don't want to be a Full-stack developer.i want to be a back-end developer(web applications,dynamic web pages).
Well I need a similar Macro to make a Pivot as before but not as complex. I need a Pivot to give me YTD totals.

Report Filter = Task Type (which incident is selected)
Columns = Month
Row Labels = Assigned To
Values = numbers

Dear Experts:

The active worksheet has the following make-up

                                                                                                                                   Column B,C,D (hyperlinks)
Column A (network paths as strings)                                  Column B                               Column C                         Column D
C:\MyFiles\Products\94-307-22-10-Product1.pdf           94-307-22-10                                                                  96-774-23-22
C:\MyFiles\Products\96-774-23-22-Product3.pdf                                                            94-509-24-10

I wonder whether a macro could achieve the following:

The macro ...
- loops thru the network paths in Column A.
- grabs the product numbers from these network paths
- searches for the corresponding numbers in Column B, C, D
- if found, the network path is inserted into the hyperlink address of that hyperlink (ie. replacing the existing hyperlink addresses).

Would be great if this is feasible.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
I cant find any information on whether its possible to design a VBA application to automatically resize depending on the users screen resolution? I've used Horizontal, Vertical and Grid layouts in Python. Does anyone know if something similar is available in VBA? or are peoples userforms always a fixed x pixel by x pixel in size?

Thanks for the help
I need a MACRO to create a pivot Table and export that to a PDF or show as image in another tab then export it.

Worksheet name = 8 Week INC Trend
Report Filter I need , "8 Week Trend", "Task Type"
Column Labels I need "Week Ending"
Row Labels I need "Assigned to"
Values I need "number"

NOTE I do have a name range for my data TAB called "RANGE"
I need a MACRO to export the active sheet to a PDF file.
At C35 I have this drop down with names and when selecting the name it will email out the form...that works great and what I wanted to do is duplicate that at B35 but I'm unable to do so.  The Code is there at module 2 for email so I need it to work for the "Email Supervisor" highlighted in yellow.

See attachment.
I need to create an iso from files (not bootable) but can't seem to find a trustworthy program.  I search EE and found 2 references to cdburnerxp, but my AV catches it and says nono.

There must be a simple answer to this, what do you guys use?
What would be the options available for securing VBA code?  

I work for a large company that has sold off a portion of the business.  The portion of the business that's been sold wants access to a reporting solution developed internally that uses VBA.  The VBA has sensitive proprietary information contained within it.  Cost of the end solution to secure the code is not much of a concern.  Time to implement the solution is somewhat of a concern.

What options are there to secure this VBA code and how  secure is each option?

I found this option online: http://www.spreadsheet1.com/unviewable-vba-project-app-for-excel.html#buy
It appears to be an option that's fairly secure but I'd like to understand how secure the above option is and what other options there may be out there.  

Any help you can provide is appreciated.


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Hello Experts,

I need to copy data from one workbook to another, and save it using Excel VBA on Mac.  Can you please help ...

Many thanks in advance !

I want to convert file from .xlsx to xlsb. Which  xlFileFormat I need to give in below code ?    $ws.SaveAs($file + '_' + $ws.Name, [Microsoft.Office.Interop.Excel.xlFileFormat]::xlCSVWindows)
Hi Experts,

I am using the Data Validation List in Excel Sheet (Sheet Name : MainSheet) and Using Index and Match function in same sheet different cell (i.e. Column B) I want to display list's selected value ID (which is available in another sheet called "Sizes").

See, I am not going to select value from drop-down. Here, I am copy-paste value from some outside data into Column A (MainSheet).

I want to auto update the "Column B" based on the value in in "Column A" of MainSheet.

Also for some value it's updating the ID in Column B but in most of the cases it's not returning respective ID.

How do I get the correct result?

I'm attaching the sample sheet for you kind reference.

D Patel
We need a solution to retrieve filenames from sub folders in macro for a comparison analysis.
option to select the folders for comparison from D:\ and E:\
We need to break the path in the rows
Match folder/subfolder/filename in D: with folder/subfolder/filename in E:
reflect matched and not matched filenames

Hello Experts,

I'm totally new to programming using MVC in .net 4.5 and using (DB first) approach beside scaffolding way to create controllers and views from existing models.

When I rum my application I got those 2 errrors:

1- Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<System.Web.Mvc.SelectListItem>' to 'System.Collections.Generic.IEnumerable<WebApplication2.Models.tb_List_AgencyCategory>'. An explicit conversion exists (are you missing a cast?)

2-'IEnumerable<tb_List_AgencyCategory>' does not contain a definition for 'Concat' and the best extension method overload 'Queryable.Concat<SelectListItem>(IQueryable<SelectListItem>, IEnumerable<SelectListItem>)' requires a receiver of type 'IQueryable<SelectListItem>'

Here is my Model Code:

namespace WebApplication2.Models
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.Linq;
    using System.Web.Mvc;
    using System.Collections;
    public partial class tb_Current_Agency
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
        public tb_Current_Agency()
            this.tb_Current_Activation = new HashSet<tb_Current_Activation>();
            this.tb_Current_Activation1 = new HashSet<tb_Current_Activation>();
            this.tb_Current_GSBService = new HashSet<tb_Current_GSBService>();

Open in new window

I have approx 10 Excel Files (XLSM) in a folder and want to access each Workbooks ("Data") sheet and copy the data into a 2d array. So in the end i will have 10 2d variant arrays. I do not want to open each workbook during this process and the below code has got me started but i've hit a road block trying to get the data from the Workbooks into an Array

So far im using the following code
Sub GetData()
    Dim fso As Object, fldStart As Object
    Dim MyPath As String, MyData As Variant
    Application.ScreenUpdating = False
    MyPath = "C:\Users\Desktop\XL Test"

    Set fso = CreateObject("scripting.FileSystemObject")
    Set fldStart = fso.GetFolder(MyPath)
    For Each f In fldStart.Files
        If f.Name Like "*.xl*" Then
'*** I Need code to give focus to each particular workbook
'*** I was pointed to an answered question on a forum where the user wanted something similar. (Below)

'*** Range("A1:A" & MaxRows).Formula = "=INDEX('" & MyPath & "\[" & f.Name & "]Sheet1'!AD:AD,ROW())"

'*** This does get me some data from each Workbook but I don't understand what alot of what it does
'*** The range i'm trying to use for each f will be along the lines of, start at A1, go to the last populated row. Then go right till the last populated column in row 1 

    End If
    Next f
End Sub

Open in new window

Can you help get me past this blocker, thanks






Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.