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

how are the steps to put this in any file i need
DATADATE--10-RR.xlsm
0
Database Solutions Engineer FAQs
LVL 2
Database Solutions Engineer FAQs

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.

i have this file  working  but need paste the data in destination

after click the button
need paste the data in destination
wktaSSS_v2--1-.xlsm
0
We're talking an ASUS net book (tablet  that can detach from small keyboard) Modal T100H Mobile Dock.

Somehow I have managed to turn on the number lock so that instead of a "j" I get a "4 or some such, and so on for the letter set that prints numbers when you set it to. Except that I did not do that intentionally.

There is NO number lock key on the keyboard.

In case you did not get that, let me repeat it....THERE IS NO NUMBER LOCK KEY ON THE KEYBOARD!

I say this only because I did some searches and found that as the answer.

So experts, what's the solution?
0
i have an sheets some data is mark with the color can i  copy just by the color ??
0
This procedure --which I attached to a command button-- isn't working.

I'm really trying to make it work with an IF Then Else to see if it can be done. (see attached workbook.

Private Sub cmdAdd_Click()
Dim rowcount As Double
Beginning:
rowcount = 9
If rowcount = Empty Then
    Cells(rowcount, 1).Value = frmEmployeeInfo.txtEmpName.Value
    Cells(rowcount, 2).Value = frmEmployeeInfo.lstEmpDepartment.Value
    Cells(rowcount, 3).Value = frmEmployeeInfo.txtEmpEarnings.Value
    
    Else
    rowcount = rowcount + 1
End If

End Sub

Open in new window

forms-in-excel.xlsm
0
need go to the las record of data

but data will increase so it will change as time goes

in this case F1211
Gotolast.xlsx
0
Hello,  the following selects a range, if it exists, whether there is only one, or a bunch.  However it has a row = 2 in it.  How would I rewrite this to write that out of it?  It sort of confuses me.  If found it in a google search.  Its like saying, if the cell in row 2 is blank, the activecell (which is k4) is blank too?

row is used 3 times in this in this sub.  How can I do the same thing without using this row that dim as Integer??
Looking for some assistance rewriting this.  Please advise and thanks.

    Range("K4").Select
    If ActiveCell = "" Then
        MsgBox ("No Config Profiles found to ALE")
        Exit Sub
    Else
        Dim row As Integer
        Dim value As String
        row = 2
        Do
           value = Cells(row, 11).value ' 11=column K
           If value = "" Then
              Exit Do
           End If
           row = row + 1
        Loop
        Range("K4:K" & (row - 1)).Select
    End If
    Selection.Copy

Open in new window

0
HERE MY LIST OF NUMBER
N3DTA.xlsx
0
Dear Team, I just want to confirm these concepts. We are deploying a new Exchange server and in the migration phase. As our understanding, there are 2 options at the moment:

OPT #1. Collect all PST files from users, create new email accounts in a New Exchange server and everyone will have to open their OLD PST file to access the old emails.

OPT #2: Collect all PST files from users, create new email accounts in a New Exchange server and IMPORT their OLD PST files to the Exchange EDB, then everyone can use their accounts to access OLD emails normally.


Am I right to think that:?

1. Open PST files via MS Outlook is just open the file and nothing happens to Exchange EDB database ?

2. Import PST files via Exchange Management Console will import email data from PST file to Exchange EDB database , then increasing its size (by the size of PST files) ?

If we have about 2000 users, which option will be better?
0
Hello Everyone, Im looking to create an MSI file for citrix so i can deploy to multiple computers at once. i have downloaded a .exe to MSI converter and that did not work. ive also tried following the instructions on Citrix's website at the cmd prompt yet i get an error that citrixrecevier.exe is not a recognized as an internal or external command....  
is there anyway to convert or deploy to multiple computers without creating a GPO on the servers?
If possible i would like to use Desktop Authority from Dell or PDQ deploy.
0
Watch the Recording: Learning MySQL 5.7
LVL 2
 Watch the Recording: Learning MySQL 5.7

MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.

Whenever i drag a formula in excel, I have to double click the cell for it to actually calculate correctly. For example if i drag a formula from one cell that's total was 12 all the cells will say 12 that i have dragged the formula to even though the answer should be 29, or whatever.  I was wondering if there was an easy fix because this can be tedious.
0
Please provide me with the steps on how to create a bootable Windows OS that will boot from a USB drive so that I can access the computer's Windows 10 OS to run antimalware and antivirus programs.
0
In an excel sheet I want to have scores added up by contestant - say in B1 is the persons name 'Billy Brown' and in C1 is 10.  So the formula has to cycle through the B and C column then add only the scores for that persons name.  It would be good if it could put the persons name in say D1:D5 and their total scores next to their names in E1:E5
0
I believe SCOM 2012 does include configuration manager 2012 as well

Is it same as SCCM 2012? in that situation SCOM 2012 does the work for SCCM as well.

i believe SCOM 2007 does not have this feature

Is there any good documentation highlighting difference between SCOM 2005, 2007, 2012, 2016
0
Hi Guys, in column A of the attachment, I have tried to format the column to Dates. However, cells ending in "AM" are not formatting properly. Can someone help?
Format-problem.xlsx
0
Hi all

I have some userforms in a spreadsheet that I want to appear when the user clicks on a cell in the relevant column. However, when I highlight a row, the userforms pop up a number of times and I have to manually close them all down - is there a way to stop the userforms coming up when the whole row is selected please?

This is the code that I have in the objects for Sheet 1;
Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Application.Intersect(Target, Range("I4:I302")) Is Nothing Then UserForm2.Show
    If Not Application.Intersect(Target, Range("K4:K302")) Is Nothing Then UserForm2.Show
    If Not Application.Intersect(Target, Range("P4:P302")) Is Nothing Then UserForm2.Show
    If Not Application.Intersect(Target, Range("Q4:Q302")) Is Nothing Then UserForm2.Show
    If Not Application.Intersect(Target, Range("S4:S302")) Is Nothing Then UserForm2.Show
    If Not Application.Intersect(Target, Range("T4:T302")) Is Nothing Then UserForm2.Show
    If Not Application.Intersect(Target, Range("W4:W302")) Is Nothing Then UserForm2.Show
    If Not Application.Intersect(Target, Range("AB4:AB302")) Is Nothing Then UserForm2.Show
    If Not Application.Intersect(Target, Range("AF4:AF302")) Is Nothing Then UserForm2.Show
    If Not Application.Intersect(Target, Range("AG4:AG302")) Is Nothing Then UserForm2.Show
    If Not Application.Intersect(Target, Range("AH4:AH302")) Is Nothing Then UserForm2.Show
    If Not Application.Intersect(Target, 

Open in new window

0
This formula isn't working.  It's pretty basic!  Can you advise??
IfStatement.docx
0
I have data in this situation i have data betwwen  row 8 and 19
like show here ddddddddd.png

then i need to put all in one column ( column G , Count sheet)
like here
rrrrrrrr.pngTransPOSEdta.xlsx
0
Hi

I added a UDF (User Defined Function) to Module1 of my spreadsheet then saved the sheet as an .xla file.
I then went to Option Add-ns (Excel 2007) and enabled the add-in
I re-opened Excel and tried to use the function in a cell but wasn't able to. Why would this be?
0
Ransomware-A Revenue Bonanza for Service Providers
LVL 4
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

SCCM image deployment is failing in UEFI mode. PXE boot is working ,issue is happening when it tries to partition the disk.Could anyone help on this?

Laptop Model - Lenovo T470
System Center configuration manager 2012 SP2.
0
In the attached XL 2010 worksheet, I have a column called Emails and have email addresses in different cells. I want to be able to send each of these people the same email but individually, so rather than sending the same email to the group, or putting them all in the BCC field, I want them to each get their own individual email with the same message so creating a group in Outlook may not work for this purpose. Is there a way to do this?

Thanks,
EmailList.xlsx
0
I had this question after viewing Set font smaller and allow box to expand.

Assistance is greatly appreciated.
0
Hi,

I have 20 worksheets with several data sheets (not every sheet), that I need to consolidate to a master file.  Not all worksheets are the same format.  I am saving them all in one folder.  What I need is a macro, to open all the files, copy from each one the data into a newly created mater workbook please.  On the first copy I would like all the sheets headers, but on the subsequent copies I would just want to copy the data starting at a certain row depending on which sheet (eg ignoring repeating headers).  I do also have hidden columns that need copying across and would like it all in paste special values.  Can you please help I am not great with macros...
0
Hello,
I need to see if there is a way for me to create a template in Outlook, that when opened up the recipients and the subject line are already filled in.  To go a step further, can the present date be auto inserted to said subject line of the email?  I have a current template that I use for the body and it seems ok for now.  Of course, there are tweaks that need to be done...

TYIA,
Greg
0
I understand that Microsoft Office Suite 2007 is around 10 years old and SP3 is around 5 years old, but I was wondering if installing and using it on Windows 10 64-bit is fine? Has anyone tried this or had any issues?
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.