office365

I am trying to save a new opened workbook as a csv on a Mac but keep running into error 1004: application or object defined error here is the code: Dim directory As String directory = "/Users/johnsmith/Desktop" Dim mystring, clientname mystring = Range("B2").Text clientname = Mid(mystring...

I logged into my user in sharepoint with office and linked many workbooks to a single workbook, but now when I try to refersh, I am getting can not find installable ISAM. Can someone please tell me how to fix this issue? I am using 64 bit office 365. Thanks in advance.

Hi all, So this one may be a bit confusing to explain so I'll try my best! I'm on O365. I have a table, which will grow by rows as time goes on. ID1 ID2 ID3 ID4 ID5 ID6 ID7 ID8 1 2 aaa bbb ccc ddd 100 100 2 2 eee fff ggg hhh 400 400 3 3 iii jjj kkk lll 700...

Sorry for the vague title. Trying to get this done in a nice way, but feels more difficult than it looks. I have two tables - Strings and Data. Starting off with data in grey columns and I need to extract verified data to green (already filled as a manual "to-be" example). Values in table Data...

Greetings Folks, I'm trying to come up with a solution at work that will help a few departments. I do not have anyone to bounce ideas off of as I am the only "me" in the company and my knowledge is well intentioned, at best. I'm trying to take away from me manually going into a tool one...

Guys, I'm struggling with Conditional formatting in a table generated by PowerQuery. Formatting changes entire row cell color based on text in column H - in addition there's a separate Duplicate value formatting for column D exclusively. So, obviously they intersect with each other and I need to...

I have been using an Excel-based form for years with a macro button that automatically sent the form as an attachment in an email through Outlook. Locations that have since switched from Outlook to Office365 say the button no longer works. Does anyone know where I can find the macro...

Hi all, I have a workbook that became very slow. I would like to use a profiler to help me spot where it slows down. I got some VBA code (please see below), but all it is for 32 bits Excel, that s asks for 64-bit in the first 4 lines. Because I am beginner I can´t fix it. Does someone know...

Hi, This seems such a silly problem for me, so silly that I can't seem to solve it. The company I work for has just upgraded/ changed to Sharepoint on the cloud and we all have the Office 365 suite of programs/ apps on our computers. Previously when I wanted to open more than one workbook at a...

I want to print below a logo letterhead but cannot get the margins set as I need them?

Hi guys, I've got this spreadsheet i designed took me a very long time, however there is one major issue. It takes their Office365 name and populates a cell, the idea is it searches that name via filtering to find the user and displays his records. It works in the majority of cases, however...

Each pupil has a marksheet in Office365 which is shared with them. It is protected so that they cannot edit other than adding comments to say what needs marking next. Also in 365 I have a class spreadsheet which is linked to each individual’s spreadsheet to give me a summary. It works fine...