Go Premium for a chance to win a PS4. Enter to Win

x

Programming

52K

Solutions

40K

Contributors

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

cplusplus.jpg
This jovial programmer is Paul Kent.  I just published his new course on C++.  Great job, Paul!

https://www.experts-exchange.com/courses/1401/Programming-for-You-Introduction-to-C.html

Note: This is a paid course.
0
What does it mean to be "Always On"?
LVL 5
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

excel vba
I have data i'm copying to another workbook, from my current workbook.

Dim curWks As Worksheet
Dim templWks As Worksheet
Dim rngToCopy As Range

  
Set curWks = ActiveSheet
With curWks

Set rngToCopy = .Range("A1:AX65453", .Range("a1").End(xlToRight).End(xlDown))
End With

Workbooks.Open _
fileName:="C:\Program Files\enterprise\Customer Copy\Customer_Template.xlsx"


If ActiveSheet.Name = "Project Data" Then
Else
Sheets("project Data").Activate
End If

Set templWks = ActiveSheet
templWks.Cells.Select
templWks.Cells.Clear

' APPENDS DATA
rngToCopy.Copy _
Destination:=templWks.Range("A65453").End(xlUp)


' after i copy data i need to insert a column at  Column P


Workbooks("Customer_Template.xlsx").Close SaveChanges:=True
Application.CutCopyMode = False

Open in new window



What I need:
after i copy data i need to insert a column at  Column P in the other workbook.
And give the Column Header a name "Customer  Price"


Thanks
fordraiders
0
hello,
i am new in Kotlin Programming Language.
any can help me for Kotlin Programming Language
0
Hi All,

I am trying to put together a little GUI to be used by my team so that we can run a selection of PS scripts at the click of a few buttons.

The idea i have seen in an old job several years back was something sort of like this,

Basically a page with Buttons and text box descriptions,

then a text file or even integrated for a task list that I can edit the Function and Description of the buttons.

Has anyone seen anything like this, i am new to programming and cant afford to spend several hundred for PowerStudio i was hoping to find a easier way that I can edit someone elses work?

thanks
ideas
0
Need to convert text string to Bitmap image.  I have been provided C# code, but I program in Delphi.  The data is received from a pinpad and is a signature.

I have attached a sample cs document that they provided,

Any idea on how to convert this document to delphi?  Ultimately, I pass the text to a function that returns a bitmap or initializes an existing bitmap..
TriPosSignatureGenerator.cs
0
hi,

while doing maven install i got below error
No compiler is provided in this environment. Perhaps you are running on a JRE rather than a JDK?

while doing maven clean it is success though
i follwed below steps to resolve
http://javarevisited.blogspot.com/2016/06/maven-eclipse-error-no-compiler-is-no-JRE-JDK-installed.html

how
 maven clean
maven install
maven update
are different?
why maven clean is success and no issues in doing maven update as well where as maven install complained above jre?
0
Hello
Getting the attached.  The supplier saying network related issue not programming.
Ideas?
2017_11_16_09_22_49_Error_messages_u.jpg
0
Please see attach spreadsheet for example,

Can you please help me automate the counting of records using a macro.

There are three worksheets
1. Priorities - Lists all the Priorities in column A that will be used in responses on the Responses worksheet
2. Responses - Each row is a set of responses by a user and there may be up to 50 user responses.  I will populate these manually.  The worksheet has some examples.  The responses going across the row can go up to 150 after the name in column b.
3. Results - Counts the responses for every row by user that is in the responses worksheet. The responses are are totaled in the last column. (or on a separate worksheet if easier)

When you look at the attached file you can see two examples.
CountResults.xlsx
0
I have inserted two shapes ("Plus Sign") in cell z14 of excel 2016. As per my requirement I am using below code for shape copy paste

Range("Z14").copy
Range("D15").activate
activesheet.paste
'------ I am using below code to fetch row number on click of macro ------
 Dim wb As Workbook
 Dim ws As Worksheet
 Set wb = ThisWorkbook
 Set ws = ThisWorkbook.Worksheets("Additional_Details")
 
    Set b = ws.Shapes(Application.Caller)
    With b.TopLeftCell
        cs = .Row
    End With

Above code works fine excel 2016 however it is providing old row number "14" in excel 2013

Please suggest.
0
I have a website coded in .aspx and I need to get help in coding.
Can someone please tell me exactly what programming language it is?

Here is a snippet:
		Out ('<script language="Javascript" type="text/Javascript">');
		Out ('function valCoupon() { ');
		Out ('var oForm=document.forms.form1; ');
		Out ('var sError=""; ');
		Out ('var nID=0;')
		Out ('for (var i=0;i<oForm.radCoup.length;i++){');
		Out ('if (oForm.radCoup[i].checked==true) {');
		Out ('nID=oForm.radCoup[i].value; }}')
		Out ('if (nID==0) {sError="'+ErrorOut2(73)+'"; alert(sError); }');
		Out ('else {oForm.submit();} ');
		Out ('} </script>');
		Out ('<table cellspacing="0" cellpadding="0" width="745" align="left" border="0"><tbody><tr><td class="header" valign="top" background="images/Community/graphic_com_creambkg.gif" colspan="3"><img alt="SOTA Referral Number" width="643" height="40" src="images/Community/graphic_com_header_referral_number.gif" /><p></p></td></tr>');
		Out ('<tr><td valign="top" background="images/Community/graphic_com_creambkg.gif" colspan="3"><table cellpadding="0" width="655" align="center" border="0"><tbody><tr><td class="content" valign="top" background="images/Public/graphic_pub_rightcontent_bkg.gif">');
		Out ('<div class="subheader_sec">Where did you discover your Referral Number?</div><br />');
		Out ('<p>We love to know how our customers are discovering our Referral Numbers - it\'s such a great way to see how word of our products grows and spreads. We appreciate you 

Open in new window

0
Free Tool: ZipGrep
LVL 11
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

I was able to retrieve the attached file thru a soap call to a web service, now i need to convert this xml file to a .csv file, is there an easy method of walking thru the xml file to extrtact the fields i need?
Tempxml3.xml
0
See this code:
$piece1 = $test;
$piece2 = "";
$piece3 = "";
$ln = strlen($test);
if ($ln > 84) {

	$arrayWords = explode(' ', $test);

// Max size of each line
	$maxLineLength = 84;

// Auxiliar counters, foreach will use them
	$currentLength = 0;
	$index = 0;

	foreach ($arrayWords as $word) {
    // +1 because the word will receive back the space in the end that it loses in explode()
		$wordLength = strlen($word) + 1;

		if (($currentLength + $wordLength) <= $maxLineLength) {
			$arrayOutput[$index] .= $word . ' ';

			$currentLength += $wordLength;
		} else {
			$index += 1;

			$currentLength = $wordLength;

			$arrayOutput[$index] = $word . ' ';
		}
	}
	$piece1 = $arrayOutput[0];
	$piece2 = $arrayOutput[1];
	$piece3 = $arrayOutput[2];
}	

Open in new window


This works perfectly, except I need a variation where I can limit the FIRST line ($arrayOutput[0]) to 84 & the subsequent lines to 94. See attached image for visual of this need. The text is printed using a pdf generator on an existing form image (with the word Remarks & the lines.)

How can I do this?

Thank you
Capture.JPG
0
Hello Experts,
how does make a bat file for continuous Ping multipal IP with background Colour changes ?
for example:-
start ping -t 192.168.207.11 -l 0
start ping -t 192.168.207.12 -l 0
start ping -t 192.168.207.13 -l 0
start ping -t 192.168.207.14 -l 0
start ping -t 192.168.207.15 -l 0
0
hi,

while executing below xquery

for $x in doc("Books.xml")/books/book
return if{$x/@category="XML")then<XMLBOOK>{data($x/title)}</XMLBOOK>
else <NONXML>{data($x/title)}</NONXML>


on below xml


<?xml version="1.0" encoding="UTF-8"?>
<books>
	<book category="JAVA">
		<title>Master Core Java</title>
		<author>JG</author>
		<year>2015</year>
		<price>50</price>
	</book>

	<book category="DOTNET">
		<title>Get Certified in .Net</title>
		<author>BG</author>
		<year>2016</year>
		<price>60</price>
	</book>

	<book category="XML">
		<title lang="en">XML and XML Schema Definition in easy steps</title>
		<author>BT</author>
		<year>2014</year>
		<price>20</price>
	</book>

	<book category="XML">
		<title lang="en">XSLT XPATH and XQuery Fundamentals</title>
		<author>BT</author>
		<year>2016</year>
		<price>30</price>
	</book>
</books>

Open in new window

getting below error

Syntax error on line 2 at column 9 of file:/C:/Users/sg/gpJava/ud/xsl_xpath_jquery/XQuery/Books2.xqy near {....xml")/books/book return if...}
  XPST0003: Unrecognized node constructor if{}
Static error(s) in query

how to fix it
please advise
0
hi,

eclipse java perspective kind of messed up as i tried to expand console which went to top right corner from bottom. I further tried to move which moved outline some where else etc. How bringing back to default view of java perspective so that i can see everything as origninal? if i restart the eclipse this problem resolved or there is any trick or command to fix this java perspective(even any other perspective for that matter like J2ee etc)
i tried restarting eclipse did not help though
please advise
0
In the html world what is difference between
<th> vs <td>

when we use each under <tr> of <table>
please advise
can i use one another interchangeably?
0
hello, I am tasked to create a java chat application using socket programming with clients under a main server, is there any link that can help me? thank you
0
Hi, I used following code to add data to Combo box, But combobox showing results
String[] Array
Where is wrong
public List<string[]> Displayadd()
        {
            List<string[]> lstpartners = new List<string[]>();
         
            string sqlPartners = "SELECT name ,address from test";

            string results = string.Empty;
            PartnerCon=dbConnect.Connect();
            PartnerCon.Open();
            SqlCommand cmdPartners = PartnerCon.CreateCommand();
            cmdPartners.CommandText = sqlPartners;

            using (SqlDataReader rdr = cmdPartners.ExecuteReader())
            {
                //List<string> mylist = new List<string>(new string[] 
                while (rdr.Read())
                {
                    lstpartners.Add(new string[] { rdr["address"].ToString(), rdr["name"].ToString() });


                }

            }


            PartnerCon.Close();



            return lstpartners;
        
        }

Open in new window


Calling Combobox

 cmbPartnerID.DataSource = null;
            Partner ptr = new Partner();
            cmbPartnerID.DataSource = ptr.DisplayAdd();
            cmbPartnerID.DisplayMember = "address";
0
I have a small program I need created. Here is what it will do.

1) Run from the desktop
2) Check for the existence of a usb microphone plugged in
3) If no microphone then prompt user to plug one in.
4) If microphone present then run another application / exit
5) Gives user the option to copy predetermined file from point (a) to (b)
6) config file for # 4 and # 5

microphone is determined to exist by using the following command ...
wmic path CIM_LogicalDevice where "Name like 'PowerMIC%' " get /value
If mic isn't found I usually get " No Instance(s) Available. "



Thanks ..... Is this something you can do ? Windows 7 but should also be able to work with windows 10

Joel T Brown
0
Hire Technology Freelancers with Gigs
LVL 11
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

hi,

i have 3 ant projects downloaded from tfs say project1, project2, project3
i need to import them to eclipse
when i unzipped there is no .project  no .eclipse etc files. so when i import as existing java project not recognizing them as existing project.

when i import as build.xml after import i am not seeing build.xml anymore to build the project

https://stackoverflow.com/questions/3880350/importing-ant-build-xml-in-eclipse

how to import regular ant project into eclipse. please advise
0
hi,

under eclipse -->general -->network connections
i see options like manual, native, direct

when i select manual and select http(giving usernae and password) https((giving usernae and password) socks(not giving  usernae and password) in proxy entries at the top
and
at bottom proxy bypass first three like local host then 12x.x.x.xx
and
tfs.crm.com
then it is connecting.

To my friend when selecting native which choosed al other options apart from above six then it connects for him.

what is difference between native and manual
when i try to do remote debugging on one unix server they are suggesting to change to mative from manual but my fear is i cannot connect to tfs any more. if i change to native and come back to manual again does it save the configurations as earier?


when to use direct?
https://help.eclipse.org/mars/index.jsp?topic=%2Forg.eclipse.platform.doc.user%2Freference%2Fref-net-preferences.htm
https://stackoverflow.com/questions/27405988/remote-debugging-failed-to-connect-to-remote-vm-connection-timed-out
please advise
0
Hello,

I have a vbscript I have finished and pushing out via gpo.

I want to convert the vbs to html. How do I go about doing this?
0
I am from Chemistry background in India with 16 years of IT Programming and DB experience. Living in US for past 9 years.

Currently, I am assigned lots of SQL Data Correction work(Backend) that will make me obsolete in future.
My corporate work does not allow me to do any new work.
My Family(3 dependents) life does not allow me to learn a whole lot.

How to smoothly transition from my current legacy, obsolete work to more reliable & paying job in future(current age:46 years until 70+ years of age).
0
I created a simple Macro that cleans some data from an excel file that generated from ServiceNow every month.  The Macro simply formats some fields, creates columns, splits data in one column to two columns and sorts the data.  Here is the current code, I know the code isn't optimized but I am under a time constraint to get this done.  

Sub MIMCleanup()
'
' MIMCleanup Macro
'
' Keyboard Shortcut: Ctrl+k
'
    Columns("A:A").Select
    Selection.NumberFormat = "mm/dd/yyyy"
    Columns("B:B").Select
    ActiveWorkbook.Worksheets("Page 1").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("Page 1").Sort.SortFields.Add Key:=Range("B2:B16") _
        , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
    With ActiveWorkbook.Worksheets("Page 1").Sort
        .SetRange Range("A1:O16")
        .Header = xlYes
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
    Columns("E:E").Select
    Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
    Columns("D:D").Select
    Selection.TextToColumns Destination:=Range("D1"), DataType:=xlDelimited, _
        TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
        Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _
        :="-", FieldInfo:=Array(Array(1, 1), Array(2, 1)), TrailingMinusNumbers:=True
    Range("E1").Select
    ActiveCell.FormulaR1C1 = …
0
I am attaching a file and I'm wondering if this needs to be done with a macro or can it be done using formulas e.g. indirect?
1. On the Week names and numbers sheet I have a list of week dates and numbers. Is there a way to create and rename sheets only using the week dates marked in yellow e.g. 3/11/2017, 17/11/2017, 1/12/2017 either using a macro or formulas (ideally it would be great to have it done so that the file with the dates could just be re-created for the following year?
2. Then to have the contents of 03-11-2017 automatically copied to all these newly created renamed sheets..and last but not least,
3. to have the corresponding week date and week numbers for the sheet entered automatically in the areas in yellow on the sheet.

Thanks.
EE_update_sheet_names.xlsx
0

Programming

52K

Solutions

40K

Contributors

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.