+ Reply to Thread
Results 1 to 1 of 1

Modify html data in Bulk using Excel

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    Bedford
    MS-Off Ver
    Excel 2007
    Posts
    1

    Modify html data in Bulk using Excel

    Hi,

    I have a requirement to modify HTM file properties in bulk. I have currently around 110 files in .html format.

    They all have iteration of a shape used with defined custom properties.
    -------
    <DIV tabIndex=-1 id=P011_012_013_014 class=hsc.shape.1
    style="FONT-SIZE: 0px; TEXT-DECORATION: none; HEIGHT: 75px; FONT-FAMILY: Arial; WIDTH: 75px; POSITION: absolute; FONT-WEIGHT: 400; FONT-STYLE: normal; LEFT: 560px; TOP: 197px; BEHAVIOR: url(#HSCShapeLinkBehavior) url(#HDXVectorFactory#shapelink)"
    hdxproperties="fillColorBlink:False;Height:75;lineColorBlink:False;Width:75;"
    value = "1" src = ".\A3F35_files\Mot.sha" parameters =
    "Point?NameOne:Test;Parameter?ParamOne:PV;Parameter;Value?DataSourceOne:X1;Point?NameTwo:Test1;Parameter?ParamTwo:PV;Value?DataSourceTwo:X2;
    linkType = "embedded" globalscripts = "" styleClass = "">
    ------

    Basically I want to go through all files in a local folder and Modify "Paramone"or "Paramtwo" value strings based on different Datasource options.

    I am very new to Excel VBA macros and looking for some directions on how I can import htm data from multiple files and Parse it in Excel, modify the values (if Parsed data is split into Columns, can run analysis and update values) and Save these updates in source Html files.

    Regards,
    Jawad
    Last edited by cjawadz; 04-15-2019 at 02:20 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] excel bulk data modification
    By khushboo# in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2017, 08:07 AM
  2. bulk modify chart sources
    By scb998 in forum Excel General
    Replies: 1
    Last Post: 08-10-2016, 03:17 AM
  3. Excel - bulk processing disparate spread sheets with common data into 1 table or SS
    By rblackcat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2013, 08:41 PM
  4. Problem in Bulk import of Excel data into SQL
    By sridevi kumaravel in forum Excel General
    Replies: 0
    Last Post: 10-25-2012, 07:58 AM
  5. Giving Bulk Data feed Using Excel
    By jack_sparrow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2008, 11:11 AM
  6. What is the fastest way to bulk load data into Excel?
    By Gail Hurn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2005, 05:06 PM
  7. Replies: 0
    Last Post: 03-15-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06620 seconds
  • Memory Usage 8,856KB
  • Queries Executed 15 (?)
More Information
Template Usage (32):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (1)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_legacy
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (48):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1