-
FlexPro
- Auf einen Blick
- Features & Optionen
- Einsatzgebiete
- Alle Vorteile
- Neu in FlexPro 2021
- FlexPro gratis testen
- FlexPro View OEM Freeware
- Kaufberatung
- Login
- Language
- +49 6894 929600
- infoweisang.com
- Google Maps
- Produkte
- News
- Support
- Unternehmen
- Jobs
- Kontakt
- Login
- Language
- +49 6894 929600
- infoweisang.com
- Google Maps
Recording Macros
- Dieses Thema hat 2 Antworten sowie 2 Teilnehmer und wurde zuletzt vor vor 21 Jahren, 2 Monaten von tim@gci.org.uk aktualisiert.
-
AutorBeiträge
-
September 26, 2003 um 2:47 am Uhr #12705tim@gci.org.ukMitglied
Thank you support for your help on the last question.
I am now trying out the macro feature. I have to make two recordings, but they haven’t played back for me.
1) I have 5 charts in a document. I select the first chart with my mouse. Then, using the “quick macro”, I press Ctrl+Shift+R, and record my actions. In this case it was to select right button click, select options, and then go into the dialogue boxes to deactivate (hide) the x-axis.
When I finished with the dialogue boxes, I stopped the recording.
I then selcted the second chart and pressed Ctrl+Shift+P to repeat the operation for it. This didn’t work.2) All five of my charts are driven by an excel workbook which I have imported into my database. If I make changes to the variables in my workbook and press the update all button, my charts all update.
I want to record a macro that will increment the value in a cell of my excel workbook by 1, then “update all”, then export my document as a .jpg file. I want to use these images to make an animation.
I am being stumped at the first hurdle however as the macro recorder doesnt let me make a change the value of a cell in the excel workbook.Any tips would be much appreciated.
Many thanks,
Tim.
September 26, 2003 um 3:01 am Uhr #8368tim@gci.org.ukMitgliedThank you support for your help on the last question.
I am now trying out the macro feature. I have to make two recordings, but they haven’t played back for me.
1) I have 5 charts in a document. I select the first chart with my mouse. Then, using the “quick macro”, I press Ctrl+Shift+R, and record my actions. In this case it was to select right button click, select options, and then go into the dialogue boxes to deactivate (hide) the x-axis.
When I finished with the dialogue boxes, I stopped the recording.
I then selcted the second chart and pressed Ctrl+Shift+P to repeat the operation for it. This didn’t work.2) All five of my charts are driven by an excel workbook which I have imported into my database. If I make changes to the variables in my workbook and press the update all button, my charts all update.
I want to record a macro that will increment the value in a cell of my excel workbook by 1, then “update all”, then export my document as a .jpg file. I want to use these images to make an animation.
I am being stumped at the first hurdle however as the macro recorder doesnt let me make a change the value of a cell in the excel workbook.Any tips would be much appreciated.
Many thanks,
Tim.
September 26, 2003 um 3:01 am Uhr #9158Bernhard KantzTeilnehmer1) We cannot reproduce this problem. If we start the recording AFTER selecting the diagram in the list view and stop recording BEFORE you select the next one, it works. The recorded code is for example:
ActiveDatabase.SelectedObject.XAxes(1).Divisions.Visible = False ActiveDatabase.SelectedObject.XAxes(1).Line.Visible = False ActiveDatabase.SelectedObject.XAxes(1).Labels.Visible = False
2) The macro recorder cannot record any changes made inside excel. To do such job, you need to use FlexPro Professional and write the code yourself.
-
AutorBeiträge
- Du musst angemeldet sein, um auf dieses Thema antworten zu können.