true power of MS excel. update: PowerBI

[benteSAiz]

Re: MS excel formula, programming, analysis, presentation and tutorials.

mga master gumawa ako userform sa MACROS bakit kapag kino-close kuna Ms Excel ko at saka open ulit hindi na se-save or retrieve yung form na gawa ko sa Macros.?

ito yung nag pa-prompt.

[the following cannot be saved in macro-free workbooks:

.vb project

to save a file with these features, click No, and then choose a macro-enabled file type in the File Type list.

to continue saving a macro-free workbook, click Yes:]

Yan po yung ng po-promt na message sa excel 2007 ko. saan po ba makikita yung "macro-enabled file type in the File Type list" hindi ko kasi mahanap sa tools ang FILE TYPE LIST kaya click Yes button nalang para ma save ko.. nag sa-save naman pero kapag e close kuna MS excel hindi kuna ma retrieve yung userform na ginawa ko sa Macros kapag buksan ko ulit MS excel..

pa tulong mga master..

 

[kaytoy]

Re: MS excel formula, programming, analysis, presentation and tutorials.

mga master gumawa ako userform sa MACROS bakit kapag kino-close kuna Ms Excel ko at saka open ulit hindi na se-save or retrieve yung form na gawa ko sa Macros.?

ito yung nag pa-prompt.

[the following cannot be saved in macro-free workbooks:

.vb project

to save a file with these features, click No, and then choose a macro-enabled file type in the File Type list.

to continue saving a macro-free workbook, click Yes:]

Yan po yung ng po-promt na message sa excel 2007 ko. saan po ba makikita yung "macro-enabled file type in the File Type list" hindi ko kasi mahanap sa tools ang FILE TYPE LIST kaya click Yes button nalang para ma save ko.. nag sa-save naman pero kapag e close kuna MS excel hindi kuna ma retrieve yung userform na ginawa ko sa Macros kapag buksan ko ulit MS excel..

pa tulong mga master..

@benteSAiz

Save a macro-enabled workbook
Follow these steps to save a macro-enabled workbook:

Click the Office button and then click Save As.

The Save As dialog box appears.

Enter a name and select a location for your workbook.

Click the Save as Type drop-down arrow.

A list of file types appears.

Select Excel Macro-Enabled Workbook (*.xlsm).

Excel adds the .xlsm extension to the filename.

Click Save.

Hope it helps ^_^

 

[benteSAiz]

Re: MS excel formula, programming, analysis, presentation and tutorials.

@benteSAiz

Save a macro-enabled workbook
Follow these steps to save a macro-enabled workbook:

Click the Office button and then click Save As.

The Save As dialog box appears.

Enter a name and select a location for your workbook.

Click the Save as Type drop-down arrow.

A list of file types appears.

Select Excel Macro-Enabled Workbook (*.xlsm).

Excel adds the .xlsm extension to the filename.

Click Save.

Hope it helps ^_^

@kaytoy
salamat sa reply master! big help nareretrieve kuna macro form ko. pagaralan kona mag program sa excel .

 

[nasnipkeropi]

Re: MS excel formula, programming, analysis, presentation and tutorials.

gandang umaga po sa lahat,.. mga sir pano kaya po mag timing ng lyrics at kanta sa powerpoint? project lang po namin,.. gagawa po kami ng videoke presentation,..

 

[bhoc84]

Re: MS excel formula, programming, analysis, presentation and tutorials.

pa help naman po,gusto ko kasi macopy yung value from column L copy to F,G or H given na yung color sa column B ay kapareho nya.pero yung nasa column b ay may nailagay na ko na conditional formatting sa date nya View attachment 1069056

pa ask po ulit

 

[martinjonathan]

Re: MS excel formula, programming, analysis, presentation and tutorials.

salamat dito ts...ang lupit mo..

 

[edwardz89]

Re: MS excel formula, programming, analysis, presentation and tutorials.

sir gumagawa ako ng simple internet records instead na mgsulat ako sa papel gagawa ako ng excell form. .tanong ko sir pano lagyan if condition time in lng dn yung remarks nya open time..mag oopen time cxa..pano formula sir?

View attachment 238565

 

[nash0260]

Re: MS excel formula, programming, analysis, presentation and tutorials.

up up up up natin wag natin hayaang matabunan itong threads natin malaking tulong sa mga newbie ito ^^, dito dn ako natutu mag code and ulit

- - - Updated - - -

sir gumagawa ako ng simple internet records instead na mgsulat ako sa papel gagawa ako ng excell form. .tanong ko sir pano lagyan if condition time in lng dn yung remarks nya open time..mag oopen time cxa..pano formula sir?

View attachment 1073045

parang need mo ng macro dto for timer countdown hehehe. hindi pa masyado nagana utak ko un lng agad tumakbo sa utak ko ngaun

 

[edwardz89]

Re: MS excel formula, programming, analysis, presentation and tutorials.

up up up up natin wag natin hayaang matabunan itong threads natin malaking tulong sa mga newbie ito ^^, dito dn ako natutu mag code and ulit

- - - Updated - - -



parang need mo ng macro dto for timer countdown hehehe. hindi pa masyado nagana utak ko un lng agad tumakbo sa utak ko ngaun

gusto kopo kasi gawin pag open time cxa ilog ko lng yun time in dn sa remarks nya ay OPEN TIME. .sana may mka tulong. .salamat.

 

[nash0260]

Re: MS excel formula, programming, analysis, presentation and tutorials.

gusto kopo kasi gawin pag open time cxa ilog ko lng yun time in dn sa remarks nya ay OPEN TIME. .sana may mka tulong. .salamat.

eto paps medyo kaw na mag continue ng ginawa ko may mga code na sia dragdown mo na lng kpag need mo pa ng another data mali nga lng ung sa payment hehehe.. naka set sia ng 15 per hr kaso kpag 1hr and 30mins na consume dapat 45 bahala ka na heheh pero kpag d ako busy try ko ayusin hehehe

 

[edwardz89]

Re: MS excel formula, programming, analysis, presentation and tutorials.

eto paps medyo kaw na mag continue ng ginawa ko may mga code na sia dragdown mo na lng kpag need mo pa ng another data mali nga lng ung sa payment hehehe.. naka set sia ng 15 per hr kaso kpag 1hr and 30mins na consume dapat 45 bahala ka na heheh pero kpag d ako busy try ko ayusin hehehe

slamat tol yun lng IF condition sa remarks need ko peru maraming thanks..

 

[nash0260]

Re: MS excel formula, programming, analysis, presentation and tutorials.

slamat tol yun lng IF condition sa remarks need ko peru maraming thanks..

walang anuman paps nakatulong nmn ba ung remarks ko?

 

[ailhyn009]

Re: MS excel reportings, presentations, and vba helping thre

pabm po. ty

 

[azlandfaqs]

Re: MS excel reportings, presentations, and vba helping thre

sir pa help naman po ako sa excel ng pag ng type ka mg auto complete xa. gagamitin ko po to sa series ng mga cards.

TIA

 

[kirby21]

Re: MS excel reportings, presentations, and vba helping thre

sample naman boss

 

[nash0260]

Re: MS excel reportings, presentations, and vba helping thre

sample naman boss

Goodam paps ^^, and too all

 

[edwardz89]

Re: MS excel formula, programming, analysis, presentation and tutorials.

walang anuman paps nakatulong nmn ba ung remarks ko?

ok na ok tol. .may 1 problem nman ako pag ngstart cxa 8:00am dn ntpos sa 8:am bali 24hrs hindi nya ma count yun 24hrs Zero ang no. of hrs nya..mgandang gawin d2??

 

[kaytoy]

Re: MS excel formula, programming, analysis, presentation and tutorials.

ok na ok tol. .may 1 problem nman ako pag ngstart cxa 8:00am dn ntpos sa 8:am bali 24hrs hindi nya ma count yun 24hrs Zero ang no. of hrs nya..mgandang gawin d2??

@edwardz89

Comment lang po....
- it would be very unlikely that a human could stay in front of a computer for straight 24hrs...

 

[kirby21]

Re: MS excel formula, programming, analysis, presentation and tutorials.

pa up lang mga bossing

 

[kentooth]

Re: MS excel reportings, presentations, and vba helping thre

salamat po dito. . .sa wakas matuto narin ako. . .jejeje