You are not logged in.

Open a worksheet with a macro

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

PerMerte

Professional

  • "PerMerte" started this thread

Posts: 19

Date of registration: Oct 12th 2010

  • Send private message

1

Monday, February 28th 2011, 12:17pm

Open a worksheet with a macro

Hello,

I'm searching for a macro for opening a worksheet by clicking on a button.
I never programmed a macro so I have no clue.
I want to use it for a "Welcome-Worksheet", where all other worksheets are linked as buttons. I think that looks a lot nicer than using the Hyperlink-function in Palo-Web and edit the cells.


Greetings and tia, Michael

MJV

Master

  • "MJV" is male

Posts: 32

Date of registration: Aug 30th 2010

  • Send private message

2

Tuesday, June 21st 2011, 3:38pm

RE: Open a worksheet with a macro

Hello everybody,

I'm facing the same question.

Anybody there who knows how to open an existing spreadsheet by macro?

The job to be done is reading values out of one spreadsheet and writing it in another spreadsheet.

Thanks for assistance!

Mark

Rod

Master

Posts: 87

  • Send private message

3

Friday, June 24th 2011, 8:15am

RE: Open a worksheet with a macro

Hi,

In Excel the basic Macro would be something like

Source code

 
1
2
3

Sub OpenBook()
Workbooks.Open Filename:="C:\Temp\Book1.xlsx"
End Sub
Hope this helps.

Rod

This post has been edited 1 times, last edit by "Rod" (Jun 24th 2011, 8:15am)

PerMerte

Professional

  • "PerMerte" started this thread

Posts: 19

Date of registration: Oct 12th 2010

  • Send private message

4

Wednesday, August 10th 2011, 1:40pm

Hi,

unfortunately you cant't use functions of Excel's macroengine. Unless there is a possibility to extend the library of Palo's macroenginge.
Is there a possibility to get the functions of Excel's macroengine? That would be very helpful!
Has anyone an idea to open sheet in a Spreadsheet with macro which is assigned to a Button? I only need a simple open- function, when I click the button "sheet1" is opened.

Tia, Michael

dominik_l

Jedox Team

  • "dominik_l" is male

Posts: 344

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

5

Wednesday, August 10th 2011, 5:49pm

Hint: if you take a close look at the "Navi Home" workbook of the Bikers Best application (part of Premium Setup), it might give you an idea ;)

MJV

Master

  • "MJV" is male

Posts: 32

Date of registration: Aug 30th 2010

  • Send private message

6

Monday, August 15th 2011, 2:07pm

With new release 3.2 CE, there seem to be no longer any "labels" for sheets within a spreadsheet. Jumping between sheets gets much uncomfortable without those labels.
Using hyperlinks maybe a way to change between sheets within spreadsheets or between spreadsheets.

But still I would prefer using macros to open spreadsheets or to change to another sheet. Can "bikers' best" database/application be downloaded without installing Palo Premium trial version?

Regards,
Mark

CNX

Master

  • "CNX" is male

Posts: 72

Date of registration: Nov 12th 2008

Location: Berlin, Germany

  • Send private message

7

Monday, August 15th 2011, 4:55pm

Quoted from "MJV"

Can "bikers' best" database/application be downloaded without installing Palo Premium trial version?
Download could be found under the download section of community edition
Palo Community and more Downloads
Andreas Malinowski
FORECAST Unternehmensplanungen GmbH, Berlin, Germany
www.forecast.de

MJV

Master

  • "MJV" is male

Posts: 32

Date of registration: Aug 30th 2010

  • Send private message

8

Tuesday, August 16th 2011, 7:54am

Quoted from "CNX"

Quoted from "MJV"

Can "bikers' best" database/application be downloaded without installing Palo Premium trial version?
Download could be found under the download section of community edition
Palo Community and more Downloads


Thank you,
but donwload only contains database, not "Navi Home" workbook mentioned by Dominik.

Anyone who can link or send me the workbook (resp. macro-routine)?

Regards,

Mark

This post has been edited 1 times, last edit by "MJV" (Aug 16th 2011, 8:48am)

dominik_l

Jedox Team

  • "dominik_l" is male

Posts: 344

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

9

Tuesday, August 16th 2011, 2:52pm

Did you maybe grab the wrong download?
You need "Bikers Best Roadshow 2011 Demo", that zip contains a .pb file (Palo Web Bundle) which you can import in Palo Web.

MJV

Master

  • "MJV" is male

Posts: 32

Date of registration: Aug 30th 2010

  • Send private message

10

Wednesday, August 17th 2011, 10:15am

Quoted from "dominik_l"


You need "Bikers Best Roadshow 2011 Demo", that zip contains a .pb file (Palo Web Bundle) which you can import in Palo Web.


O.k., now I got right archive an found the file. If I understand the readme rightly, I need the Report Manager for importing the file? So with CE I am on a dead end here?
I'm sorry, but I'm just looking for some code to open a worksheet resp. jump to another sheet in current worksheet. Is'n that possible without installing Premium Version as demo?

Thank you for further assistance,

Mark

dominik_l

Jedox Team

  • "dominik_l" is male

Posts: 344

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

11

Wednesday, August 17th 2011, 10:44am

You can import the .pb file in File Manager, too.

PerMerte

Professional

  • "PerMerte" started this thread

Posts: 19

Date of registration: Oct 12th 2010

  • Send private message

12

Monday, September 5th 2011, 12:24pm

Hi!

Opening a workbook with:
function Umsatz_Click ()
{
return array(
array('hl', '[/Default/Public Files/Admin/Neue Arbeitsmappe.wss]')
);
}
works fine!

But how to adress a sheet of this workbook? I want to open sheet2!

Tia, Michael

This post has been edited 1 times, last edit by "PerMerte" (Sep 15th 2011, 9:08am)

PerMerte

Professional

  • "PerMerte" started this thread

Posts: 19

Date of registration: Oct 12th 2010

  • Send private message

13

Wednesday, September 21st 2011, 11:58am

Hi!

Could anyone help? For example how is the hyperlink for a worksheet?
Or does anyone can give me a macro-code, that opens a worksheet?

Tia, Michael

kratzer

Master

  • "kratzer" is male

Posts: 87

Date of registration: Feb 23rd 2006

Location: Karlsruhe

Occupation: IT

  • Send private message

14

Wednesday, September 21st 2011, 12:51pm

in a hyperlink you can address a certain sheet:

in the hyperlink link choose: existing file --> file name --> target (Cell or sheet): type in for example: sheet2!A1

Consider case-sensitivity.

##
German version: Existierende Datei --> Dateiname --> Ziel (Zelle oder Blatt):

J.F.Mueller

Trainee

Posts: 2

Date of registration: Mar 28th 2012

  • Send private message

15

Wednesday, March 28th 2012, 1:26pm

Create a new *.wss via Macro

Hello,

i'd like to be able to create a new *.wss File in my project via a Macro.
If i try to export something p.e.
function exportfile() {
ActiveWorkbook()->export("F:\Windows\Jedox\Palo Suite\storage\h1-Public+Files\n1-example.wss");
}
i can generate the file, but its not listed in my File-Manager even if i actualize the file-manager view or log-out and log-in....
I really like the Starter Demo Project with all the Hyperlinks and so on, but i cant find a possibility to generate a new file without clicking on the New-Tab in the File-Manager.

I'd be really pleased, if someone could help me with this :)

I'm using Palo Suite 3.1.

Thanks for each hint.

J.F.Mueller
Rate this thread