Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

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
[Webinar On Demand] Database Backup and Recovery
LVL 11
[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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
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
Upgrade your Question Security!
LVL 11
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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
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
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 would like to develop a page which can interact with AD so that user's can update their contact details on the fly and it's in sync with AD so that signatures are up to date. I also want to flash the page every 30/60 days to every user so that they are forced to check and update their contact

i have attached a layout , which i would like to create a page so that i can ask every user every now and then to update their contact details.
0
I would like to write a custom check writing software for this dot-matrix printer.
Preferably in python. Any recommendations on how to go about this? What is the best language etc...
I think I would prefer a Linux environment but I am open to c# .net windows as well.
0
I have worksheets named WS1 and WS2. I need to compare Column C of WS1 with Column D of WS2. If both columns contain same values then I need to highlight both the cells of "Column C of WS1" and "Column D of WS2".
Example:
Column C of WS1    
500,000.00
260,000.00
65,000.00
30,000.00
46,104.00
530,000.00
350,000.00
55,000.00
7,000.00
2,520.16
30,000.00
210,000.00
650,000.00
10,000.00

Column D of WS2
2520.16
500,000.00
260,000.00
65,000.00
30,000.00
46,104.00
530,000.00
350,000.00
55,000.00
7,000.00
30,000.00
1,827,099.63
210,000.00
650,000.00
10,000.00
If values of Column C = Value of Column D then the cell containing same values in both columns is highlighted. My data is not uniform. They may have repetitive values. I am doing it manually right now and it is time-consuming as I have a lot of data to work on. Can you please suggest me.
 I am looking for exact matches for currency amounts and also I want the amounts which has been already matched to be left out. The value in each cell should be matched with only one value of another cell. Leave out the next repeated value to match with next.
0
When developing an application / web application, what type of documentation is required /beneficial if a developer leaves a company to allow the new developer to understand the setup /configuration
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.

Hello Experts - I am running Server 2008 R2 with Office 2007 and IE8.  I need to upgrade to IE11 as some of the third party sites we work with are no longer compatible with IE8-IE10.

I have an Access application that currently works extremely well retrieving files from IE8, however, when I try to use this with IE11 the Open/Save/Save As bar at the bottom is a problem.

If I am retrieving a file that has a direct url to the file that includes a .xls file extension, then the file will open without the download bar.  If I am in a site and the application navigates to a url that does not have a .xls file extension included, or one that is for a file type other than pdf or xls, or one that is within a site that requires a login first to download the file, then the download bar appears.

Direct URL w/File Extension Example - http://www.plazahomemortgage.com/Documents/Rates/Plaza_JAX_Rates.xls
URL w/o File Extension Example - http://h2o.caliberdirect.com/Utilities/PublicOpenDocument.aspx?c=ICAgICAgNzcyNUBAMTNAQDU2QEAxMAAA

I have tried several different solutions for editing the registry, but I am either doing it wrong, or it isn't working.

I can run this same Access application on a Windows 10/Office 2016/IE11 setup and the download bar does not appear.

Switching to Chrome/Selenium is not an option; I don't have time to learn Selenium right now, and the Security Team won't approve Selenium for install.

Thanks in advance for your help!
1
field will be in the form are as follows
GIN--STATIONARY NO
GX NO. CG/001/N - AUTOMATIC CHANGEABLE AFTER EACH
DATE - CHANGEABLE
DOO- DATE I WILL DECIDE
SUR NAME- FROM TABLE
INITIAL-FROM TABLE
RANK-STATIONARY FOR EACH PERSON
P. NO.-UNIQUE NO
THERE WILL BE SOME CASUALTY e.g. LEAVE, MOVEMENT, PROMOTION,AMENDMENT
i donot have the idea how to make this form from the so that i can receive the date from table. ple help me.
0
I am trying to add custom layout to my preferences. Here is the relevant code.

1. SettingsActivity

        public class SettingsActivity extends AppCompatActivity {
        private SettingsFragment mSettingsFragment;

        @Override
        public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_fragment);

        FragmentManager fm = getFragmentManager();
        mSettingsFragment = (SettingsFragment) fm.findFragmentByTag(SettingsFragment.TAG);
        if (mSettingsFragment == null) {
            mSettingsFragment = SettingsFragment.newInstance(R.xml.settings_main);
        }

        try {

            fm.beginTransaction()
                .replace(R.id.content_frame, mSettingsFragment, SettingsFragment.TAG)
                .commit();
        } catch (Exception ex) {

        }

        }

        @Override
        public void onBackPressed() {
        if (getFragmentManager().getBackStackEntryCount() > 0) {
            getFragmentManager().popBackStack();
        } else {
            super.onBackPressed();
        }
        }
        }


activity_fragment :

    <?xml version="1.0" encoding="utf-8"?>
    <LinearLayout android:id="@+id/root"
    xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical">


    <FrameLayout
  …
0
hello there
i have this scenario as a semester project and i don't understand how to find the entities please help

The Scenario:

information system of the promotion office in the management of the faculty members of the university

The Office of Promotions for the Administration of Faculty Members is affiliated with the University. Where the staff are concerned with organizing the procedures and keeping the files and the necessary data on the faculty members who are applying for promotions and research for the purpose of promotion and residents of this research, whether they are inside the university or from outside. The applicant for promotion the right to promotion several times during his career before retirement when The number of years spent by the previous scientific degree and the completion of a specified number of published scientific researches and submit an application for promotion to be approved by the competent department to which the applicant applies for promotion. Where the applicant can upgrade to the highest degree whenever it meets the conditions according to the regulations of higher education .. In order to consider the procedures of the applicant to upgrade it first submit a written request indicating his personal data such as the functional number and the name of the tripartite and the faculty and the section to follow them and the specialization and degrees obtained and the date Get all of them and qualifications (BA, MA, ..). The applicant …
0
I have an excel workbook with many rows in a tab called data...  I would like to have another tab called terminated that would only show rows from the data tab where column K = terminated

how is this done with a formula or lookup etc...
0
is there a solution to protect assignments drag in team planner view ? Drag changes task start / end dates but ProjectBeforeTaskCrange event is not fired…
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.