Questions tagged as 'vba'

Tagged questions
0
answers

Printing is repeated in SAP Script

I am working with a macro, which prints the dispatch guides. He does it correctly, but when I'm going to print one followed by another, the first one is repeated. See in the image that I was repeated the branches Llanquihue and Osorno. I a...
asked by 24.09.2018 / 23:01
1
answer

Refresh view when selecting a ChekBox

I have the following code and I need that when selecting the CheckBox you enable or disable the DropDown , that should happen instantly every time the CheckBox1
asked by 18.09.2018 / 19:35
0
answers

How to place several dates with Date and Time Picker in a ListBox?

I would like to know how to insert 2 or more dates with the Date and Time control, selecting the "Select date" button and selecting the dates from the control. Or, if there is a better solution I am open to your answers. Thanks     
asked by 10.09.2018 / 17:21
1
answer

Extract content from DataGridView from SAP to Excel with Macro

I'm having trouble passing the contents of a DataGridView SAP to Excel with a macro. I get the error:    "The object does not support this property" Here where you mark me in the VBA This is the code section: Su...
asked by 09.09.2018 / 06:15
0
answers

as I can from the inbox of outlook call with a link an application or form of ms access 2013

as I can from the inbox of outlook call with a link an application or form of ms access 2013. With the application of ms access I send an email to the interested person, she must read what we ask her to do, what I need is that from the email (in...
asked by 09.09.2018 / 20:15
1
answer

Count cells in a filtered range

I am working on some Excel reports in which we need the amount of tickets that are not being attended (empty cells), according to other criteria. Currently this is what I have in my code gsh.Shapes("UnpickedCE").TextFrame.Characters.Text =...
asked by 06.09.2018 / 18:08
1
answer

extract sap text and copy in excel - SAP Script

It's been a while since I said hello. I wanted to consult about this topic that I am seeing very recently that are the scripts to automate processes with SAp from Excel. In particular I'm doing a script to generate dispatch guides from SAP...
asked by 06.09.2018 / 22:21
0
answers

How to save file in UTF-8 format in VBA

I have a macro that works well, it saves a file in .csv and puts double quotes, which I need. The problem that inside this file I have special characters (in Korean, Chinese, etc) and when I save it, it changes me. I was reading and I thin...
asked by 31.08.2018 / 19:08
0
answers

Error converting data type nvarchar to date

Good evening I have a problem registering a form of a dating system in which marks the error of the title, I think the solution would be to convert the following code. Private Sub BtnRegistrar_Click(sender As Object, e As EventArgs) Handles Bt...
asked by 21.08.2018 / 06:17
1
answer

Document_Open () fails when I open the document by Macro vba in Excel

I have an excel with the following vba code: Dim objWord Dim objDoc Set objWord = CreateObject("Word.Application") Set objDoc = objWord.Documents.Open("Ruta") 'Ruta verificada And I have a word document with this vba code: Private Sub Doc...
asked by 22.08.2018 / 15:42