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

x

Microsoft Applications

43K

Solutions

37K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

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

Sign up to Post

I want to provide the user with the macro in an excel but I do not want them to see my macro codes, is it possible? if yes please suggest.

I want to implement this in Excel and word application both.
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.

I had this question after viewing Modification of VBA to use named range instead of offset.

Rgonzo1971 was very kind of helping me many times.  the code  in earlier post was great. now i tried to implement this into my worksheet. it seems like for every cell, i have created two procedures for two cell. please see attached file. but i think there have to be a easiler way to combine all of these into one Sub Procesure. i do not know how to do this. any help is appreciated. if it would not be simplified then it seems like i have to have 16 seperate procedures for each of the cells.

EEE.pngEE.xlsb
0
We just purchased action pack and get Dynamics CRM on the cloud using the 5 licenses. I would like to create a test project in visual studio and try to call the web api. Can you show me something how can i do the set up?
For now, all i need is below:

1. create a static method to check the connection is valid or not. return true or false
2. create a static method to read all leads inside of lead entity.  and that is all i need.
0
We use SCCM 2012 to remote our user computers.
RDP works on all computers but Remote Control only works on some ones.
I check some of these failing computers and SCCM client is installed and the Remote Control setting enable.
If I run "Msiexec /i Client.msi SMSFULLREMOTETOOLS=1" this fix the problem.  Apparently the Remote Tool component is missing in these computers.
Is it a way to fix this problem remotely?
0
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
how can I lookup with two values in Excel. Please read sheet 2 from sheet 1 in the attached example.
grid-map-analysis.xlsx
0
EE,

Curious if it's possible for certain network devices say Juniper, brocade or Palo Alto firewall OIDs that display Anyconnect VPN active sessions, high availability status, SIP Trunks or Chassis Cluster Failover? I'm trying to monitor these in SCOM (Operations Manager) and I need to import these for monitoring.

Thanks in advance
1
Hi All Expert,

Good Day.

I have a user using outlook 365 and one of her colleague emails always went to Junk inbox, I have whitelisted the email address and disable the antivirus add on and still same, the outlook didn't set any rule also. This only happens to one of the email in the same company and domain, raise a ticket to Microsoft and the guy moved the inbox to other server and still same. Appreciate if any expert here can advise me on.

Thanks!
0
My outlook 2013  OOF works for some time for some hrs. and then turns off automatically

It is only me having issues, anything to be checked in my outlook
0
Hello All,

We have a few computers.
On one computer when i click on a control and want to open the Zoom box with Shift+F2 i get a message,
"Add-in missing or was modified". and access locks up.
I already uninstalled Access 2010 and installed it again and it did not help.
Thanks in advance
0
Get your Disaster Recovery as a Service basics
LVL 1
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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
We are seeing this graphic attached to the first character of a file name in SharePoint. What do you call this? Is anyone else seeing  it? Example: new file name
0
I'm currently in the midst of a 2013 to 2016 Exchange migration.  Included with this migration is standing up a new Exchange 2013 servers as part of a storage refresh.  We need to keep our Exchnage 2013 enviroment around for some legacy applications.  I've been using New-MigrationBatch, Start-Migration-Batch, and Complete-MigrationBatch to stage the migration batches to copy most of the data over to the new databases on 2016 manuly complete at the desired time.  This has worked flawlessly for all mailboxes moving from 2013 to 2016.  If the batch contains a 2013 to 2013 migration it appears the associated move-request moves the mailbox and does not wait to be manually completed as it should almost like it thinks the autocomplete switch is being used.  I've gotten around this by seperating out the 2013 moves into a separate batch a leveraging a foreach loop with the New-MoveRequest cmdlet with the -suspendwhenreadytocomplete to overcome this.  I've not come across this before granted most of my migration previously have been 2010 to 2013, 2013 to 2016, or 2010 to 2016 never a mixed batch.  I can't find anything that would indicate this is by design or a bug.  I was wondering if anyone has come across this before.
0
in regards to this question
https://www.experts-exchange.com/questions/29067900/Excel-formula-referencing-multiple-columns-between-tables.html
obviously i have more data then i included in the example, as sheet1 is 90k plus enterys.
and i have a couple other large sheets referenced that are not directly part of the problem
so the information i am trying to retrieve exists on column 3 (C) of sheet 4, i have modified the formulae as follows
{=IFERROR(INDEX(Sheet4!A:O,MATCH(1,(Sheet4!A:A=B8)*(Sheet4!B:B=C8),0),3),"")}

Open in new window

and entered with ctrl + Shift + enter and i am getting no data.
should it matter that sheets 1-4 are from sql data connections? or is there something obvious im doing wrong
0
Hi all,

From last few hrs i have been trying to make a Pivot table, Column "C" "Task" based Person based Count.

Wanted the work done by
How many Voice, Editing, Camera, Anchor work did "Micheal" do

If anyone can help me would be great
attached sample file
Thanks in advance
Sample.xlsx
0
I need to create a Task Scheduler for 10 pm every day, but if the PC is off at that time, it needs to forgot this event and wait until next day 10 pm.  In other works if the PC is off skit the event.
Right now my script create the event but if the computer is off, the event occur at soon user log on in the morning, I need to avoid it.
Any ideas and thanks for your help.
 
#Create a 10 pm task Scheduler

$taskExists = Get-ScheduledTask | Where-Object {$_.TaskName -like $jobname }

if($taskExists)
{}
else
{
$script =  "-ExecutionPolicy Bypass -file $File"
$action = New-ScheduledTaskAction –Execute "powershell.exe" -Argument "$script"
$trigger = New-ScheduledTaskTrigger -daily -At $Time
$Description = "Shutdowm computers at $Time every day."
$settings = New-ScheduledTaskSettingsSet -AllowStartIfOnBatteries -DontStopIfGoingOnBatteries -StartWhenAvailable -DontStopOnIdleEnd
Register-ScheduledTask -TaskName $jobname -user "theuser" -Password "password"-Action $action -Trigger $trigger -RunLevel Highest -Settings $settings -Description $Description
}
0
Have Exchange 2013 and a few users use OWA instead of Outlook.  All of a sudden the Calendar Notifications and Task Notifications don't work.   Normally 30 minutes before a meeting a pop up would happen and the computer would make a sound.

Now that isn't happening, nothing has changed, and it's across all users on all computers.

All the settings in OWA, options, settings, calendar are correct and say to remind and play a sound every 30 minutes.    The new mail notifications and sounds are still working correctly.
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 am ranking (column AH)  the points for a group of members based on if they meet all percentages greater than or equal 100.  My problem is when the point total (column AG) for a non-qualified member is greater than the qualified member.  I cannot figure out how to exclude the non-qualified member from the formula.  I've attached my spreadsheet and my formula is:  

=IF(NOT($G2>=100%),"Not Qualified",IF(NOT($M2>=100%),"Not Qualified",IF(NOT($S2>=100%),"Not Qualified",RANK($AG2,$AG2:$AG4)+SUMPRODUCT(--($AG$2:$AG$4=$AG2),--($D$2:$D$4>$D2)))))
Ranking_EE_111417.xlsx
0
Important Lessons on Recovering from Petya
LVL 11
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

hi
Just wanted to find out if there is any DateDif configuration that would show the number of years and days between two dates eg. the difference between 12/12/1945 and 14/11/2017 is 71 years and 28 days. Or indeed some other formula?
Thanks
0
need help opening a .webloc file.  thank you
0
I have a column in spreadsheet.  It has a (') in front of each number '006040001
When I use the find and replace with a space it turns only some of the numbers into something that looks like a formula that looks like this 9.9502E+17 instead of the number.
I tried formatting the column as text and I also tried formatting the column using copy, paste value only.

In both cases I still get this on some of the numbers.  If I click on it the real numbers do come back  but I need this to just be a text value as I am using it for a naming convention.  The number were generated by a program I have no control over.
.
0
This follows on from a previous question and some validation checking.

=IF(AND(D37="Yes",D39="Town"),"(Co(z) + 0.6)/1.6)^2",IF(AND(D37="No",OR(D39="Sea",D39="Country")),"Ce(z) x qb","Ce(z) x Ce,t x qb"))

Simplified version

=IF(AND(D37="Yes",D39="Town"),"Equ3",IF(AND(D37="No",OR(D39="Sea",D39="Country")),"Equ1","Equ2"))

Based on the Eurocodes for wind design on which I am basing this spreadsheet I have an issue.  

The final answer for Equ 3 should equal Equ1 + equation 3 ( which is static = Co(z) + 0.6)/1.6)^2) or Equ 2 +  equation 3.

Not sure of how to build this one. I had thought using the cell E41 adjacent to D41 to display?
scaffoldv3.xlsx
0
Using Office 365, is there a way to ensure that the default language is ALWAYS English, no matter what language an email is sent in. It seems to turn off automatically when attempting to reply - in English - to an email sent in another language...thanks
0
I need to check the values of a number of cells and keeping getting errors. D39 is a 'list cell' to control entries

1st check
=IF(D37="No", And(D39="Sea"or"Country")"text1=iftrue","text2=iffalse")

if I then change cell D37 to 'Yes' then
=IF(D37="Yes", And(D39="Sea"or"Country")"text3=iftrue","text4=iffalse")

Thanks in advance Paul
0

Microsoft Applications

43K

Solutions

37K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.