support

Hi folks, I bought myself a new Mac Book. My old Office 2011 is out of installs and it looks like Office 2019 is where I'm going. But I do have a couple of questions. Does anyone who has experience with 2019 know if: 1) does it support VBA (in memory of 2008 :) ) 2) is the MacScript command...

This my be outside the scope of this messageboard. I have a number of automation processes running many reports and such. One of the tasks that needs to be done is to save an word file as a PDF. This is, of course, trivial in VBA. However... What I really need to do is use Acrobat DC ability...

Hi, I am new to MS Access. I wanted to know, does Access support Pivot tables now. I am required to edit couple of existing macro. These macro has pivot tables in this. However, I guess, pivot tables are no longer available in Access. Please correct me if am wrong. How do I proceed if pivot is...

I'm looking to highlight/identify duplicates in a row based on a common title (same) and am not sure of the direction to proceed. Simple example: There are two helpdesk title's and both are part of similar groups. I would like to identify all groups that "helpdesk" have in common. Then...

Hi to everyone, kindly require to provide me a VBA code so that to run a code from another folder/file. The bath of the code is follow: w:\accoffice\inv.people\VBAacc.xlsm.personal.XLSB!moduleacc Please note without opening the file It would much appreciate any support. Thank you in advance

I have an issue with a Gantt Chart Template that I created, its very slow for some reason (I cant find the root cause :warning:) Could you please take a look of it and support me to speed it up? Thanks a lot!!! Download Link: https://drive.google.com/open?id=1nU...nDEKAB0iePAH6a

Good afternoon all, I'm looking for some help with a BI Power Query formula (Trying to cut out lots of manual work) that will take a date from a column (So 10/07/2019) and return back whether that date was Last Week, Last Week -1, Last Week -2, etc up to Last Week -4 in a new column to the right...

Hi, I have a sample data as below, original data is around 90 thousand. Please Note:- That in the below sample data the value in the column "Approval Status" is show "Approved", but this is not the case it can be other values as well for example like "Rejected" or "Submitted" etc., Sample...

Dear supporters, appreciate your support to help me i copy data from system to excel sheet (data) <colgroup><col></colgroup><tbody> A - Support A - Support A - Support B - Support B - Support B - Support B - Support B - Support B - Support C - Support C - Support C -...

Hi All, How do you deduct 1 row from the last row selected using ctrl+shift+down? In this way, I won't be including "Grand Total" to the graph that I will be creating. Range("A5").Select Range(Selection, Selection.End(xlDown)).Select <colgroup><col width="305" style="width: 229pt...

Hi All, I have created a VBA that automatically creates a pivot table. However, I would also like to automate the creation of a graph from the the pivot table. What I want to happen is to make a graph from the details without including "Row Labels" and "Grand Total". If there is a new entry for...

Hi All, How do you remove a row with "(blank)" from a pivot table which is also producing count for blanks? VBA <colgroup><col width="305" style="width: 229pt; mso-width-source: userset; mso-width-alt: 9760;"> <col width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt...

The code I wrote is also slow to take data from the site so I want to translate it to msxml2.xmlhttp. I need your support for it, if you help https://yadi.sk/i/DtV6aex_1I2lxQ <svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24"> </path></svg><svg focusable="false"...

Hello, I a have a spreadsheet of about 1600 rows in which I need to get into another format.... <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Part ID Amount 79123 5233122 44.18 79123 11606476 95.1 79123 22346192 149.81...

Hello. I am trying to concatenate two cells that contain time of the day and show them as a time slot in text format (like: 09:30-11:00). I have changed the destination formats to text and also used the TEXT formula but it returns strange numbers (fraction of 24 hrs I assume). How can I change...

This one is baking my noodle. I need the digit in () extracted into a separate column. These are all values in Column A, though some columns are indented. Ideas, please?? 01. First Week (1) None (1) 10/09/2018 (1) Initial Onboarding Complete 01. First Week (1) None (1) 07/30/2018 (1) Initial...

Does VBA support any kind of "keyword" parameter? By this, I mean parameters of the form keyword=value. Something like this: =MyFun(A1, B2, Keyword4=C3, Keyword2=D4, ...) I am working on a UDF that has half a dozen optional parameters with more to come. Most of them are omitted on most...

Good evening all, I was wondering if someone would be kind enough to help mewith the following please? What I am trying to achieve is the following: Retrieve the gross balance for all accounts (excludingduplicates where there is >1 of the same entry / account) in Column A whilstalso...

Hi guys, Sorry to bother you, but I don't know if Excel is able to do this task, if yes it would be great. :) The thing is I have, for example, a list of values (1,2,3,4,5) and another list of values (A,B,C), is there any way, having this, to get these row combinations?: <tbody> 1 A 1 B...

Hi, I have a report and in that the format of the number are coming in 2 different ways. Is there a way to correct this. 1. 340.35 = this is normal format, i don't have any issue with this. 2. 28.390,26 = If you could see there is "." instead of "," and "," instead of "." and also have to...