VBA to website

[vofzxy]

hi guys

so i have some mediocre knowledge of VBA, but i have this pet project that i wish to achieve.
however that requires a higher level of ability to code in VBA.

so i wanna ask if its possible to get some VBA tutor on this to aid me in my project or should i just go freelancer .com ? LOL

2nd things is, after i have worked my VBA out on excel. is it possible to translate to a website, like a HTML file that take excel as an input and perform the various macros i have written on it. is that software or can be done by some website making whizz?

ok my aim to create a search macro that will display the results on "Sheet 1" and the data is all on "Sheet 2", after that i would like to know if i could make a web interface for it .

 

[davidktw]

hi guys

so i have some mediocre knowledge of VBA, but i have this pet project that i wish to achieve.
however that requires a higher level of ability to code in VBA.

so i wanna ask if its possible to get some VBA tutor on this to aid me in my project or should i just go freelancer .com ? LOL

I will let any others who would want to tutor you in your VBA. My offer is you ask question here, I answer if I can.

2nd things is, after i have worked my VBA out on excel. is it possible to translate to a website, like a HTML file that take excel as an input and perform the various macros i have written on it. is that software or can be done by some website making whizz?

Macros for your excel do not really work outside of Excel or Office suite itself. You will be able to transform some of them to work in the web if they have general concept, but you will certainly need to adapt to web language and engine to work. I did a search and it seems able to publish excel into web, but I'm not sure how far you can go with it, and it certainly isn't about enabling user to upload an excel and work on it. VBA is basically dependent on much of its Office Windows Library and these may not necessarily be accessible from Microsoft IIS easily.

ok my aim to create a search macro that will display the results on "Sheet 1" and the data is all on "Sheet 2", after that i would like to know if i could make a web interface for it .

You know, maybe you will want to try out Google Spreadsheet and uses Google Apps Developer API found at https://developers.google.com/google-apps/ to perform what you want to achieve in Excel. You will need to adapt, but it seems able to accomplish what you need.

 

[tuxguy]

hi guys

so i have some mediocre knowledge of VBA, but i have this pet project that i wish to achieve.
however that requires a higher level of ability to code in VBA.

so i wanna ask if its possible to get some VBA tutor on this to aid me in my project or should i just go freelancer .com ? LOL

2nd things is, after i have worked my VBA out on excel. is it possible to translate to a website, like a HTML file that take excel as an input and perform the various macros i have written on it. is that software or can be done by some website making whizz?

ok my aim to create a search macro that will display the results on "Sheet 1" and the data is all on "Sheet 2", after that i would like to know if i could make a web interface for it .

Looks to me that your eventual goal is to have something on the web and you are trying to leverage on what you know to get there.

Am of the same view as davidktw that, VBA is not really suitable to your eventual goal

Have a suggestion that might be able to help. Dive straight by using web technologies. Try going to www.tersus.com to have a look. Pretty sure you can achieve your goal easily.

Feel free to PM me if you need any help on Tersus

 

[vofzxy]

I will let any others who would want to tutor you in your VBA. My offer is you ask question here, I answer if I can.



Macros for your excel do not really work outside of Excel or Office suite itself. You will be able to transform some of them to work in the web if they have general concept, but you will certainly need to adapt to web language and engine to work. I did a search and it seems able to publish excel into web, but I'm not sure how far you can go with it, and it certainly isn't about enabling user to upload an excel and work on it. VBA is basically dependent on much of its Office Windows Library and these may not necessarily be accessible from Microsoft IIS easily.



You know, maybe you will want to try out Google Spreadsheet and uses Google Apps Developer API found at https://developers.google.com/google-apps/ to perform what you want to achieve in Excel. You will need to adapt, but it seems able to accomplish what you need.

WAH so pro !

ya but i start with an excel sheet of like 800 rows 16 columns ....
so Macro is the first way to go.

If i can get a web site/ web app (whats a web app >< )
thats would be great.

thats said if i can achieve my goals on 1 spread sheets, that same "solution" is applicable to the other 2 in tow , matter of row x col

Cannot use google. company data, company laptop

hence manual type lorrr~~~~~~~

 

[vofzxy]

Looks to me that your eventual goal is to have something on the web and you are trying to leverage on what you know to get there.

Am of the same view as davidktw that, VBA is not really suitable to your eventual goal

Have a suggestion that might be able to help. Dive straight by using web technologies. Try going to www.tersus.com to have a look. Pretty sure you can achieve your goal easily.

Feel free to PM me if you need any help on Tersus

first statement is absolutely correct.

what is tersus? ahha will need time to sink in.
thanks for the suggestion anyway.

not sure how that will work out if i wanna transport it into my work laptop, hence VBA is the way to go, first

 

[davidktw]

WAH so pro !

ya but i start with an excel sheet of like 800 rows 16 columns ....
so Macro is the first way to go.

If i can get a web site/ web app (whats a web app >< )
thats would be great.

thats said if i can achieve my goals on 1 spread sheets, that same "solution" is applicable to the other 2 in tow , matter of row x col

Cannot use google. company data, company laptop

hence manual type lorrr~~~~~~~

Webapp is in short for "Web Application". That means this application is normally served to the end-users via the browser, but not necessary must be so. Native mobile application are also loosely considered a kind of web application, just that they exist in natively coded in-device application to the smartphones or tablets. Browser showing a dynamic website is the most common form of web application.

The office suite has been around for a very long time and while the formats did changed but most libraries still are on Office 2007 standard. You will find a good number of good excel programming languages libraries across common languages like Java, C#, VB, Python, Ruby, PHP, Perl that have 3rd parties libraries that deal with the Office suite file formats.

If you want to allow your end-users to upload an excel worksheet and process it, then it will most likely has to be a dedicated webapp to allow upload of a file, then parse the file using the excel library, then work within library using the features offered. Some libraries can read the functions in it and execute it.

 

[vofzxy]

Webapp is in short for "Web Application". That means this application is normally served to the end-users via the browser, but not necessary must be so. Native mobile application are also loosely considered a kind of web application, just that they exist in natively coded in-device application to the smartphones or tablets. Browser showing a dynamic website is the most common form of web application.

The office suite has been around for a very long time and while the formats did changed but most libraries still are on Office 2007 standard. You will find a good number of good excel programming languages libraries across common languages like Java, C#, VB, Python, Ruby, PHP, Perl that have 3rd parties libraries that deal with the Office suite file formats.

If you want to allow your end-users to upload an excel worksheet and process it, then it will most likely has to be a dedicated webapp to allow upload of a file, then parse the file using the excel library, then work within library using the features offered. Some libraries can read the functions in it and execute it.

hahaha, you wanna be my shifu ?!

nah, no uploading allowed, i maintain the data i wanna search through without using ctrl F !

 

[davidktw]

hahaha, you wanna be my shifu ?!

nah, no uploading allowed, i maintain the data i wanna search through without using ctrl F !

You will need to be more specific with your enquiries here. I'm not going to be anyone "shifu". You have questions, you ask here and I will advise as accordingly.