Categories
Development

Combining data from multiple workbooks into a single worksheet

My code is designed to allow the user to open multiple workbooks and take the data from each workbook copy it in to a new workbook and save that workbook in a designated location with a dynamic name. My code is failing when the data that has been copied from the opened workbooks in to […]

Categories
Development

VBA How to click Enter while excel is waiting for user action

When I save my excel file with VBA, it asks me to enter my credentials (it saves it on some kind of server). Looking though the website I found a way to use SendKeys and delay the action. My issue: the code stops and wait for user input (click enter) and I can’t find a […]

Categories
Development

Error through RefreshAllStatisticData in VB

I have a similar problem like: Bloomberg data doesn't populate until Excel VBA macro finishes I wanted to run my macro ConvertTocsv through a vb script file, to schedule it later. In my files are bloomberg formulas, so I added Sub Master1 with RefreshAllStatisticData so the Bloomberg values can populate. When I run the macro […]

Categories
Ask

How to save each sheet as a separate workbook except sheet 1?

I have an excel workbook with 5 sheets but I only want to save sheet 2 to sheet – 5 but I don’t want to save sheet 1. I want to exclude it from saving. How can I do it? I have tried some codes but I am having difficulties. Sub SaveShtsAsBook() Dim xcsvFile As […]