Microsoft Office

69K

Solutions

42K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

I have an excel wookbook that contains 2 different worksheets.  The worksheet1 has all the information.  Worksheet2 has cells taken from worksheet1.  I want to be able to have the 2 cells that are highlighted in the worksheet1.png to be automatically copied to the next available cells in worksheet2 when the amount is entered in the cell which in this case is -15332.00 otherwise it won't enter anything.  Hope this makes sense.  Any suggestions??worksheet1.pngworksheet2.png
0
We have all users enabled with the E5 but have the exchange license off.  We basically need to run a script against a group that turns that exchange license on under the E5 once the person is migrated to Office 365.  can someone provide a way to do this in Powershell with Office 365?
0
hi experts i need an ifstatement formula in row 23;
if L6 = zero or nothing do nothing, otherwise L9*(L19-L13) + L20%, rounded up to 0.1
excavation_1.xlsx
0
Hi,
I get type mismatch error to right line below

        tm = Replace(Cells(rw, 3).Value, ".", "")
        If Trim(tm) = "" Then
            tm = ""
        Else
            tm = Right("0" & Hour(tm), 2) & Right("0" & Minute(tm), 2)
        End If

Open in new window

with this values. Please help.
20a.png
0
Any way to do this?

I want the same file name  as the .doc it is was  ...
0
Experts,

in a previous ask to "Convert Months to Days for Total price Calculation". I had an issue with entering a "Renewal Date" into the userform. In the attached workbook is the fix.  

This issue was fixed but changes are not incorporated into this worksheet 29173473a.xlsm. Please incorporate the fixed code.


https://filedb.experts-exchange.com/incoming/2020/02_w08/1444654/29173473a.xlsm

https://filedb.experts-exchange.com/incoming/2020/02_w07/1443481/29170885a.xlsm
0
A bug in the attached script creates all blank output when the cell references have not data.

For example, cell BR10 is blank, so the "Numbers_3" sheet has not data. It has to do with blank cells, because when I put data in that cells I get cell data in "Numbers_3" sheet.

I would like to resolve it where I can have blank cells because if I have to put data beyond number 70 I will need another script that will delete any row containing any number above 70.


blank cells create blank resultsGreen represents blank cells

The attached file contains data in all the "Numbers_X" sheets but after the macro is run only Numbers_2 has data and it is the only filled line.
CreateCombinationsBug_sheetsblank-c.xlsb
0
Experts,

I need help with converting the attached link file worksheets Original Quote and RAW_DATA to a Table format with the ability to convert back to a range while having the code to still function correctly.

https://filedb.experts-exchange.com/incoming/2020/01_w03/1440849/29169174.xlsm
0
I would like to modify this script or even have another script run on the output if needed, so that any data in the output file which are "numbers stored as text"
will be converted to "numbers"... and the file resaved.
CSV-to-Excel-Copy.ps1
0
I have an Excel add-in firing an HRESULT 0x800401A8 error, when calling the getter of Worksheet.Parent.

I would be glad if anyone could let me know what the error might be, but more importantly and more generally, I would like to know how I can understand these HResult codes?

I did the following but am still confused:

Read the Microsoft's documentation on the Structure of COM error Codes.
Checked this SO thread.
Tried my chances with Magnum DB.

Thanks!
0
The attached file with script removes "decis" but would like to combine both "remove Deci" scripts from prior posts into one script and make it faster.

The attached file contains two additional sheets to test with.
CombineRemoveDecisandMakeFaster.xlsb
0
The idea is to create a script that removes rows where there are 2 or more numbers from different "decis". A deci is defined as numbers from 1-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, and 90-99,

There should be:

1) a prompt would ask for input of "Maximum numbers allowed from different decis" or something similar. If the input is one (1) then
2) choose the sheet to be processed
3) sheet "Numbers_3" would be edited as follows:

 This process should be able to be repeated for any sheet similar to "Numbers_3"

Remove rows containing 2 or more numbers from different decis
Notice how all the green rows contain number from only 1 "deci". That is the goal.
Remove-rows-with-2-or-more-numbers-.xlsb
0
Windows 10 Pro system here acting as a server in a small office. System is connected to internet and is "on" all the time.

All of a sudden a "Microsoft Edge" pop-up appears requesting username and password for "server".

Above this, its claiming "Virus Alert from Microsoft this computer is blocked"

AFAIK, no staff would have been using this server for anything dodgy AND this computer is just not used for internet surfing at all.

Where did this appear from? How did it get installed and how did it know the PC is the actual server?
0
Hello,

We are using O365 with Office 365 Pro Plus.

There are times when some of our users need to include sensitive PII information in their emails to outside parties.  

What is the best way to secure those emails?  

Please advise.  

Thanks.
0
Is there a way to have a single excel workbook shared with multiple users where each user can only SEE a single sheet after supplying login credentials?  I know you can prevent editing in this manner but I want to prevent viewing as well.

I am trying to create a simple password keeper for a small organization so that the users can stop using sticky notes stuck to their monitor for this purpose.  I am open to other suggestions but they have to be free and easy to use.

Thanks so much!
0
I want to bring data from one spreadsheet to another, if a field is 'No', then pull comments from D5 over to another sheet.  

So one sheet - D5 is 'Yes' or 'No' - if 'No' and D6 are comments.  I would like the data to appear on another sheet.  

If 'Sheet1' - D5 = 'No' then pull data from 'Sheet1' - D2.   Thanks Experts.
0
Hi
I have an excel sheet with Names, email and passwords
I want to send an email to each individual on the list with their password, also with some text explaining what it is used for.
I guess I could use word and merge the excel sheet data
But don't know how I can get it to send separate emails to the individual
Any ideas or guidance please

Gordon
0
Hallo,
I have a list of dates in A12 -   only workdays.
How can I add 2 blanks for Sat and Sunday
Should look like this:
Excel
Thank you very much.
Best regards,
Thomas
Zeiterfassung-2020.01-Expert-Exchang.xls
0
I join into MS Teams hosted by another party using
MS Edge (though I may sometimes use MS Teams
app itself).

Is there a way to record the session (video+audio)
as a participant?  If so can give me the screens
showing how this is done?

Or it's only the host could record?
0
The idea is to create a script that allows a maximum of "X" numbers from same "deci". A deci is defined as numbers from 1-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, and 90-99,

There should be:

1) a prompt would ask for input of "Maximum numbers allowed from same deci" or something similar. If the input is one (1) then
2) ask to click on any cell that contains numbers to be processed then
3) sheet "Numbers_3" would be edited as follows:

 This process should be able to be repeated for any sheet similar to "Numbers_3"

max of "X" from same DeciThe picture shows items in RED that should be removed they all contain more than one number from the same deci. The sample numbers that should remain are 3, 7, 10, 20, 30 since only 3 and 7 are from same deci. 3, 7, 10, 20 and 29 are shown red since it contains 3 and 7 from same deci plus 20 and 29 from same deci. Thus it does not meet the criteria.
AllowMax_X_fromsameDeci.xlsm
0
Hello. Im requesting assistance with the following. I have a excel file that i want to filter according to the dropdown list selected. attached is the example file. In the "main" tab is where the table and the dropdown list will be featured. Once the table is filtered to the dropdown selection, the last column (column E on the "main" tab in the attachment) needs to be answered either with YES / NO. Once i have answered all the rows, I want excel to record the options selected in the "results" tab.

the "results" tab will have the same columns as 'main" tab.

Your assistance is greatly appreciated.
work_deck.xlsx
0
On our process controller servers we have come across an interesting issue since the server was upgraded to server 2019.  An IIS based web app on the host is instructed to upload a file from the user's local disk, then open it in Excel on the host where it will be parsed into a waiting database.  The same code is working well on several other machines that are running server 2008.  On the 2019 host the file uploads, and successfully writes it to the temp directory. Excel is invoked, but it fails to find the file and open it.  A rather generic windows type error is passed back to the app.
"An unexpected error occurred: Microsoft Excel cannot access the file 'C:\Temp\Test SP_WCETest1_001_Test Meter_20200218040939.AMD.xlsx'. There are several possible reasons: • The file name or path does not exist. • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook."
I have verified the permissions on the file and the folder are open to group 'everyone' with full control.  From the host console the file will open in excel with a double-click. There are no errors in the event logs beyond the one passed back to IIS. (above)
I pulled up procmon on a working host and compared file activity to the temp directory between the working and non-working.  csv files are attached. Ike is the working 2008 server, Phillip is the failing 2019 server.  The only thing that I found of interest is on Phillip, there is some svchost …
0
I have 2 seperate worksheets. I choose the range from one column to paste into another blank worksheet for analysis and to create a table. IS there an easier way then choosing the top of the column and having to scroll down to the end of my records? There are 1,000 records in some and more in others. I dont want the whole column as I am chosing a range and creating a table in my new worksheet.
0
I have 2 tables in power query I want to comare the id column in each table and find the matches? How do I do this?
0
Hello experts. I created a test pdf form in Adobe Acrobat Pro with three simple text field properties. Test1, Test2, and Test3. I have a table in ms access for office 365 call tbl_test that contains the identical field names as my pdf names. Test1, Test2 and Test3.

All I am trying to do is populate the pdf form field names with what every I put in my ms access field names. Everything I have tried to google or go on youtube (preferably since I am not a programmer) to view shows how to export from say an entire excel into a pdf to where I am looking for say some sort of mapping. Hope I am making sense and any help for a newbie would be great.
0

Microsoft Office

69K

Solutions

42K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.