Home Excel

Macros and VBA

19 Conversations

Latest Activity

Custom List Message Item

Hi,

 

I am facing the below mentioned error, The VBA code run perfectly in my system, While using the same macro to another system it shows the below mentioned error:

 

"The error commonly occurs when code is incompatible with the version, platform, or archit

... Read More
112 Views
6 Replies
A few quick checks. In VBA, go to the Tools menu, choose References, and make sure none are marked MISSING. Make sure you are not mixing 32-bit libraries with 64-bit libr... Read More

Hi,

 

I am attaching the Error Screenshot...

Error.jpg

Regards,

Arvind Kaushik

Read More

Dear Friends,

 

I am trying to run SQL queries on Oracle server from macro. However, the queries which takes 2 minutes to execute on SQL developer runs indefinitely from macro. On the other hand queries like "select * from dual" or simple count queries runn

... Read More
32 Views
0 Reply

Hey there, 

 

I'm tring to use the Random Number Generation function in Analysis Tookpak in my VBA code. I've added atpvbaen.xls. I am using the Random function from this library but need help on understanding the arguments it requires. (outrange, points, d

... Read More
31 Views
0 Reply

I have a user form to search previous records in a table on another sheet named "data base" and load them in to a worksheet.  The form has a list box displaying the first 6 columns from the data base, a textbox to enter what to search for, and control but

... Read More
36 Views
0 Reply

I have attached a file with just two blocks of information that was downloaded from another program.

There are over 500 blocks in total.  I need to first Replace All occurrences of "Totals: $" with nothing so that only the dollar amount is left.  Then I wo

... Read More
190 Views
10 Replies

Hi Sue

 

You'd be best off using Power Query (Get & Transform) if you can for this.

 

What version (Excel 2016, 2013, 2010) of Excel do you have?

 

If 2010 or 2013 then downloa

... Read More

Hi Sue

 

You'd be best off using Power Query (Get & Transform) if you can for this.

 

What version (Excel 2016, 2013, 2010) of Excel do you have?

 

If 2010 or 2013 then downloa

... Read More

I have two sheets in a workbook. One is protected accept about two dozen cells.  The other is not protected.  When I run a macro to copy and paste 19 cells from the unprotected sheet to 19 cells in the protected sheet, 8 of the pastes go to unprotected ce

... Read More
76 Views
2 Replies

Hi Michael

 

Can you clarify what your issue is and post the code for your copy/paste action

 

Thanks

 

Wyn

I have two sheets in a workbook. One is protected accept about two dozen cells.  The other is not protected.  When I run a macro to copy and paste 19 cells from the unprotected sheet to 19 cells in the protected sheet, 8 of the pastes go to unprotected ce

... Read More
44 Views
3 Replies
Thanks Jan! paste special worked great!

The Locked property is part of the cell formatting, so if you do a plain copy and paste, the target cells receive all formatting of the source cells. Try doing a paste sp

... Read More

Today, we are pleased to announce the general availability of the Microsoft Excel REST API for Office 365

 

Nowdevelopers can use Excel to power custom apps. Excel is an indispensable productivity tool; users across all industries and roles embrace it. It i

... Read More
155 Views
1 Reply

when will be general availability for microsoft graph API will be release?

Hi,

 

I have some stats software that exports tables to Excel but can only do so in one of the standard Excel table styles (e.g. Light 1, Medium 1 etc.). I have created a custom style that better fits with my company's usual outputs which we would need to a

... Read More
98 Views
3 Replies

Hi Adam

 

If you set a custom table style and call it MyStyle for example then use this code

 

Sub FormatAllTables()


Dim wks As Worksheet
Dim tbl As ListObject



    For E
... Read More
Best Response
Hi,

I was asked to create a report according to the chiefs (Chief 01, Chief 05, Chief 09...) found on the data base. I recorded a macro and assigned it to a button that would create a Pivot Table, however whenever I try to play it for a second time, it sho... Read More
62 Views
1 Reply

Hi

 

Purely recording macros, especially relatively complex ones like creating Pivot Tables, are a bit of a recipe for disaster to be honest.

 

The main solution is to look a

... Read More

I have a large data query file with a few sheets containing pivot tables. I need to add a button to the first sheet that will refresh all the pivot tables in the file.

116 Views
4 Replies

Also, when you say Data Query file are you using Power Query and do you want the queries to refresh also,  in which case my PivotCache suggestion won't do it for you

 

This

... Read More

HI Pierre

 

If you do want to go down the Macro route rather than using the Refresh All button then I'd suggest adding this code to a module.

 

Best to avoid any hard coded r

... Read More

Dear Pierre,

 

First and foremost, add the (Developer Tab) to your Excel Ribbon, and follow these steps:

 

  - Go to Insert at the Developer Tab, and click on it.

  - You will

... Read More

Hello Pierre

 

Excel already has such a button on the ribbon:

Data -> Connections -> Refresh All

 

You could also put it in the Quick Access Toolbar if you don't want to switc

... Read More

i have a column of numbers that are color coded (to represent a specific mfg department) and I need to total the values by color.  Meaning I need to total all the values that have the same background color.  

 

I have done an exhaustive search online and wa

... Read More
255 Views
5 Replies

Hello,

 

take a look at this question in the Microsoft Community formerly known as the "Answers" Q&A forum. (I know, the "Community" site name is confusing to have on two d

... Read More

Hi matt nipper,

 

since you mention that you "have done an exhaustive search online" i have come up with a solution for you, although it has a rule that it will only work,

... Read More

@Mourad Louha's suggestion of an extra helper column for a sumif is by far the safest and most easily understood option.     

Read More

Hi Matt,

 

may be using the SUMIF or SUMIFS functions could help. You can define as criteria the same criteria you defined for the conditional formats. And, you don't need

... Read More

Hello everybody,

 

we have a new policy that says "Disable all except digitally signed macros". So all Excel files with macro feature need to sign. I need to find a solution how we could sign over 10k excel files in bulk. Is there any solution with powershe

... Read More
77 Views
0 Reply

I am trying to record a macro that generates a new sheet featuring a template for entering client details and creates a line on the master sheet that autopopulates based on future inputs from this new sheet. Any thoughts?

77 Views
1 Reply

HI Mike

 

That sort of thing is doable but a fair bit of coding involved.

 

When you say you want it to generate a new sheet, is that just a one off, or does it need to be ab

... Read More

I have 10 worksheets in the same format labled S1 thru S10.  I have another worksheet for data entry.  Each row contains data to be copied to one of the other 10 worksheets.  The destination is defined in a cell in that row, e.g. S5.

What is the syntax to

... Read More
157 Views
4 Replies

Hi Bob

 

Does the input sheet get cleared out after the data is copied to the other sheets?