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

Hi everyone, can I ask how can I rotate the label of this chart using VBA?

Thank you.

This is my codes:

Private Sub OptionButton1_Click()
ActiveSheet.Range("F2").Select
Dim wks As Worksheet
For Each wks In Worksheets
    If wks.ChartObjects.Count > 0 Then
       wks.ChartObjects.Delete
    End If
Next wks

Dim rng As Range
Dim cht As ChartObject
Set rng = ActiveWorkbook.Sheets("REPORT DATA").Range("D2:AI10")
  Set cht = ActiveSheet.ChartObjects.Add( _
    Left:=ActiveCell.Left, _
    Width:=1180, _
    Top:=ActiveCell.Top, _
    Height:=548)
  If Range("I38") >= Range("K38") Then
  MsgBox "Wrong date value, please check your enrty.", vbCritical, "Error"
  Else
  cht.Chart.SetSourceData Source:=rng
  cht.Chart.ChartType = xlXYScatterLines
  cht.Chart.SetElement (msoElementDataLabelCenter)
  cht.Chart.ChartArea.Format.TextFrame2.TextRange.Font.size = 8
  cht.Chart.HasTitle = True
  cht.Chart.ChartTitle.Text = "LEONARDO - MounterTrace Size with Index Line 1 to 8"
  cht.Chart.Axes(xlCategory).MinimumScale = Range("I38")
  cht.Chart.Axes(xlCategory).MaximumScale = Range("K38")
  cht.Chart.ChartArea.Format.Fill.Visible = msoFalse
  cht.Chart.PlotArea.Format.Fill.Visible = msoFalse
  End If
End Sub

Open in new window


SampleDatabase-Monitoring-Size-January-20.xlsm
0
Free Tool: Path Explorer
LVL 11
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

I have two workbooks. (i.e., "Workbook_Closed" and "Workbook_Open"). I would like to put code in Workbook_Open that will import cells "C2:AA120200" from "Sheet1" of "Workbook_Closed". What is the VBA code to do this for ADO, DAO and RDO. Also which one of these data accesses interfaces is the fastest, most stable and which one would you recommend and why for this process?

You all probably know all about each, but below is a link describing them:
https://msdn.microsoft.com/en-us/library/aa261340(v=vs.60).aspx
0
I'm pretty new to Csharp programming and  need some help connecting my current cSharp to a SQL express db.

From my research i'll be connecting to the DB with a appsettings.json file with the follwoing lines of code.   Would this be correct?

thank you for any help.

{
  "DBInfo":
  {
    "Name": "MySQLconnect",
    "ConnectionString": "Server=localhost\\SQLEXPRESS;Database=Users_Db;User Id=username; Password=password"
  }
 
}
0
We have upgrade our system to Windows 10. Since this upgrade, Crystal Report displays reports incorrectly when a “can grow” field (Description) does take up more than one line. All sections are fixed height up to and including the Page Header Section 3. Section 3 has a minimum height set. The Data Section 3 is set to Print at Bottom of Page. This appears correct when each field in Section 3 is one line or the report is generated on a Window 7 system.
CR_Layout.PNG
CR_Result.PNG
0
I was using Python 2.5 but just downloaded 2.7.14.  I just got the error: ImportError: No module named numpy.

And, how do I search solutions - I found lots of others with error messages similar to mine (exactly except for numpy), but found no answers.  

Thank you!
0
I need to prove that certain patterns were engineered and not random events and have been told that Neural Networks can be used to help make this determination.

What kinds of tools and algorithms should I be looking at?

Any sample projects that have done something similar?
0
Why WooCommerce is one of the majorly favored choices when it comes to having an eCommerce store. This article will acquaint you with some reasons that I believe make it one of the best eCommerce platforms available.
0
I have Excel 2010.  The following vbscript file is executed by a scheduled task.  It opens a file to update it, save and close.  The file has the "read-only recommended" option on and my script must answer this prompt with "no" which is not the default.
Option Explicit
Dim objXL
Set objXL = WScript.CreateObject("Excel.Application")
With objXL
	.DisplayAlerts = False	
	.WorkBooks.Open FileName:="S:\Schedule\EngDates.xlsm", ReadOnlyRecommended:=False, IgnoreReadOnlyRecommended:=True
	.DisplayAlerts = TRUE
	.Visible = TRUE ' Optional
	.Run "EngDates.xlsm!UpdateDash"
	.ActiveWorkbook.Close(True)
	.Quit
End With
Set objXL = Nothing

Open in new window

I have tried several different syntax formats, with and without parentheses, and nothing has worked yet.
When I run this script, I get an error as seen in the attached file.  Does anyone see the problem with my syntax?  
Thanks!
The error that occurs when I run my script
0
I am exploring code editors.

I want my coder to be able to see the code but not necessarily edit it.

Sometimes, but not always, I want to be able to switch editing off so that all they can do is leave me a comment to the side of the code.

"Put this after line 31" for instance might be a response or
"Change line 40 to this" for instance.

It's harder than I thought to find a code editor that will allow this.
0
What is the fastest and most stable VBA code that will import a range of data from another workbook without opening it.

Example:
Copy Ranges B2:B2000 from a closed workbook located at: C:\Files\Samples\Test.xlsx and past it to Cell C200 in Sheet1 of the current workbook.
0
Become an Android App Developer
LVL 11
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

I have a spreadsheet that gets opened automatically every day to pull data from other sources. I have a list of dates for every work day for the year in column A. In column B in the first row I have a formula to start. None of the other rows in column B have this formula yet. What I need to do is when the file is opened every morning automatically I need the formula to be copied down to the row that has the current date in column A and then paste the values in the row where the copy originated from. For example if A1 is 1/17/18 and the formula is in B1 I need to take that formula and copy it to B2 since A2 is 1/18/18. And then paste the value that is already in B1 so the formula is no more in B1 and is now in B2. How can this be done in VBA?
0
Hello All,

This is an extension of a question here - https://www.experts-exchange.com/questions/29071843/Display-Query-Results-in-Message-Box.html

I'm trying to "cache" the results of the input box and re-use it on reload of the script.

My thought is this:

Is it possible to send the result of objRecordSet("ID") to a spreadsheet, then put that result from the spreadsheet as the default data in the input box?

So, the below code works fine. It populates the fields as it should but I want to send the objRecordSet("ID") to the
spreadsheet and retrieve it from the spreadsheet at reload of the script to be input box default value - see bold font I added that's not part of the original script.

So, in effect each ID the user enters in the input box will be the default value when they re-run the script.

If there's another way to do what I'm asking, I'm all ears! I hope this makes sense, thanks!


strKey = InputBox("Enter Person ID","Search", MyDefaultValue)
If strKey = "" then
Field1 = ""
Field2 = ""
on error resume next
Else
strConnection = "Provider=SQLOLEDB;Server=;Database=;User ID=;Password="
strSQL = "SELECT * FROM Table1 where ID LIKE '%" & strKey & "%' or User_Name LIKE '%" & strKey & "%'"
Set objConnection = CreateObject("ADODB.Connection")
objConnection.Open strConnection
Set objRecordSet = CreateObject("ADODB.Recordset")
objRecordSet.Open strSQL, objConnection, adLockReadOnly
do while objRecordSet.EOF = false
Field1 = …
0
Hello Experts,

I have run a hql called samplehive.hql, see attached. However, the script fails with the following error:

FAILED: ParseException line 1:2 cannot recognize input near 'D' 'R' 'O'
18/01/17 20:46:46 [main]: ERROR ql.Driver: FAILED: ParseException line 1:2 cannot recognize input near 'D' 'R' 'O'
org.apache.hadoop.hive.ql.parse.ParseException: line 1:2 cannot recognize input near 'D' 'R' 'O'

I'm very new to Hadoop Hive, can someone take a look at the script and let me know where I'm going wrong

Thanks
samplehive.txt
0
Why are these columns in Amibroker not filling with data when IB data is enabled?

https://www.screencast.com/t/cKtchTvX1Y5
0
Hi there!

I have an issue preparing an installation of Python/IDLE in one of my client's team computers. Basically, I prepared a couple of scrappers using Python and Selenium. The packages being used on my scripts are selenium, openpyxl, and python-docx.
However, I can't even get to installing the packages on that machine, because one I execute the Python installer from the website (3.6.x), the insteller won't. I tried using admin rights, disabling antivirus, I checked the correct processor architecture, and I still can't get to run the installer on that particular machine. In other team members I was able to installe in their machines. I have run out of ideas to trouble shoot this. Could you please point me to things that I can try out to run the installer Python/IDLE installer?

Thank you so much!
Any help is greatly appreciate it.
0
Hi there!

I have an issue preparing an installation of Python/IDLE in one of my client's team computers. Basically, I prepared a couple of scrappers using Python and Selenium. The packages being used on my scripts are selenium, openpyxl, and python-docx.
However, I can't even get to installing the packages on that machine, because one I execute the Python installer from the website (3.6.x), the insteller won't. I tried using admin rights, disabling antivirus, I checked the correct processor architecture, so I give up trying to install the officitial distirbution in that machine. In other machines I don't have this problem.

So I was wondering if you could recommend other Python distributions for windows that can enable me to run my scripts using the mentioned package? I saw some alternatives such as PyCharm, but I am not sure if that will help.

Can someone confident recommend some for this case?

Thank you so much!
Any help is greatly appreciate it.
0
Can I assign co line 6 to a phone number as  part of system programming I want this a a 'panic' button to call a specific outside number
0
I created a main form with a datasheet subform that includes 4 fields: ID, Product, MinimumStock, StockOnHand. Subform record sources are from a query.

I now want to add a checkbox field onto the form, so the user can select products that are under minimum qty and then by clicking a button on main form to generate a Production Order of records ticked.

Also, it is possible to show updated stock level in the main ProductTable? How this can be realised?

I just started learning Access for couple months, and only know very little about Macro and VBA. If any programming is needed, please kindly post the code as well.

Thank you for your help in advance.
0
Hi, so I've got an Ionic 3 app which has a native camera plugin and onesignal plugin as well for notifications.

The native camera plugin works fine in Ionic View or DevApp, and onesignal works when build it to an APK and run it natively on my Android phone.

However, when I use an emulator to run it, even on IOS, it comes up with cordova_not_available. And even the cameras don't work. i run the command

ionic cordova run android or ionic cordova run ios

Emulator shows up but the issue is that cordova doesn't seem to be compiled in. Thus causing cordova plugins to fail.

What can possible be the issue? I've removed all the plugins and android/ios platform, re-installed an still the same.

It's kind of difficult to develop the OneSignal notification when I can't run it with the emulator.

Anyone who has come across this, please advice.
0
Concerto's Cloud Advisory Services
LVL 5
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Im trying to do a transfers but they are all pending but Eth never leaves my wallet.
They are all under SIGNER and local transactions.

Im not sure did they even leave my computer?
If I go to TxQueue Viewer I see this
Parity.JPG
Can anyone tell me whats is wrong?
0
We are converting some BBX/Pro5 Business Basic data files for a customer.
I can read all of the fields in the file except for the DATE fields, which are stored in some kind of packed format.

Here's an example of the file layout:
-------------------------------------------------------------------------------------------------------------------
REF NAME               DESCRIPTION                            MASK/FORMAT   POSITION
PAYMENT DATE      CURRENT PAYMENT DATE      MMDDYY B   1(45,3)
   ENCRYPT WITH:         DECRYPT WITH:

DUE DATE               CURRENT DUE DATE                MMDDYY B   1(48,3)
   ENCRYPT WITH:         DECRYPT WITH:

DISCOUNT DATE    INVOICE DISCOUNT DATE      MMDDYY B   1(45,3)
   ENCRYPT WITH:         DECRYPT WITH:
-------------------------------------------------------------------------------------------------------------------

Opening the file and reading into a string variable results in garbage.
Since the field is only 3 bytes, there must be some way to define a field other than as a string.

Does anyone still remember this and would be willing to point me in the right direction?

Thanks!

John -Z-
0
hi,

what is difference between control shift L and call hierarchy(control+alt+H)  in eclipse debugging the code.
what are best debugging techniques or tips

please advise
0
We have 4 RDS servers, and 1 RDS Gateway Server which is also the Broker. The 4 Session Host servers is divided into 2  Sessions Collections. When a user RDP into the Gateway he is getting redirected to the Wrong Session Collection.

I have search the internet and can't find a proper explanation on how to broker decide to which Session Collection to send the client. I thought it was based on the group you add when creating the Session collection.

Please any help on this will be much appreciated. The outcome is to have say User Group A to always go to Session Collection A and then User Group B to go to Session Collection B.
0
I have to open csv file after creating from Powerbuilder.
Upon creating csv file , I have to open csv file as excel file automatically.

So I think it is better to use command prompt.
How could I open csv file as excel by using command prompt?
0
I've created a custom API for internal use and have query strings used to find specific assets - http://localhost:3000/api/asset?ipaddress=10.1.1.100 ... returns 1 device

What I would like to do is return results for all devices with the ip address that contains the substring in the query string - http://localhost:3000/api/asset?ipaddress=10.1.1 ... returns all devices within this subnet. Right now, this returns 0 devices.

Here's the structure of my router(s) -

router.get('/', verifyToken, function (req, res) {
    const query = {};

    if(req.query.clientcode)
        query.clientcode = req.query.clientcode;
    if(req.query.assetkey)
        query.assetkey = req.query.assetkey;
    if(req.query.name)
        query.name = req.query.name;
    if(req.query.siteid)
        query.siteid = req.query.siteid;
    if(req.query.ipaddress)
        query.ipaddress = req.query.ipaddress;

    asset.find(query,function(err, results) {
        return res.json(results);
      });
});

Open in new window

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.