Over 1 million tech questions and answers.

Macro to convert table to convert table into iCalendar file?

Q: Macro to convert table to convert table into iCalendar file?

First off, yes I want an iCalendar vs an Outlook calendar file because, heresy of heresies, I prefer Thunderbird to Outlook. Moving on...

My work doesn't offer an option to download the weekly schedule as a file, and my schedule changes so often that each week I have a whole schedule to plug in. I'd like to automate the process. Pulled directly from the clipboard, the table looks like this:

01:45 pm - 11:00 pmFront Service Clerk
M: 05:00 pm - 06:00 pm

06:30 am - 12:30 pmFront Service Clerk
M: 09:00 am - 10:00 am

02:00 pm - 11:00 pmFront Service Clerk
M: 05:45 pm - 06:45 pm

06:30 am - 03:45 pmFront Service Clerk
M: 09:15 am - 10:15 am

01:45 pm - 06:30 pmFront Service Clerk
M: 04:15 pm - 05:00 pm



Is there a way to make a macro to pull the time and put it into the time section of an iCalendar file, pull the "M" and put it into the "location" section, while ignoring the "Front service clerk" section? Important: Saturday is the first day of the week. Preferably it'd then save it as an .ics file, but it can just put it out in ics format and I can change the file extension.
Thanks.

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Macro to convert table to convert table into iCalendar file?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 219.2

First off, yes I want an iCalendar vs an Outlook calendar file because, heresy of heresies, I prefer Thunderbird to Outlook. Moving on...

My work doesn't offer an option to download the weekly schedule as a file, and my schedule changes so often that each week I have a whole schedule to plug in. I'd like to automate the process. Pulled directly from the clipboard, the table looks like this: EDIT: this forum doesn't seem to keep tables and wants it vertical like this. Just imagine the text is in a horizontal table.

12:30 pm - 07:15 pm
Front Service Clerk
M: 04:00 pm - 04:30 pm


06:30 am - 11:15 am
Front Service Clerk

01:15 pm - 11:00 pm
Front Service Clerk
M: 06:00 pm - 07:00 pm

12:00 pm - 03:00 pm
Front Service Clerk

08:00 am - 02:45 pm
Front Service Clerk
M: 10:15 am - 10:45 am



Is there a way to make a macro to pull the time and put it into the time section of an iCalendar file, pull the "M" and put it into the "location" section, while ignoring the "Front service clerk" section? Important: Saturday is the first day of the week. Also, days I don't work are blank and get copied into the table. Any way to fix that? Preferably it'd then save it as an .ics file, but it can just put it out in ics format and I can change the file extension.
Thanks.

Read other answers
RELEVANCY SCORE 122.4

Hi ..
 
I have a good quality of .png format image files of a nicely laid out table image. I used .png because of the higher, to me, image quality.
 
Wearing out Bing/Google searches has given me many suggestions of online converts to free/trial applications with all very inconsistent quality results, i.e.: not worth the effort .  I tested converting the .png to .pdf image and .jpg image files to accommodate testing a wider breadth of programs with same inconsistent, i.e.: useless results.  I have some 80-120 image files I'd like to convert.
 
Cost is always a consideration, but I did not go into this without thinking I might need to purchase a converter/OCR to .xlsx package. I cannot seem to find one that says it works. I DO except the ability to trial/test anything before purchase.
 
Ideas? Suggestions?
 
Thank you in advance for your consideration.
 
Let me know.
 
John

Read other answers
RELEVANCY SCORE 112

Dear expert,
Needs to convert Word table (data) to Excel.
Using copy/paste does not work well as format are totally gone.
Have learnt to use:
1. For Word file, save as web page. Then close the word and file.
2. In Excel, Under Data menu, use Import External data, then import Data.
3. Choose the .mht file I have saved in Word.
4. New Web Query will pop up and choose options - check "FULL HTM Formatting to do conversion", check "USe the same import settings for the entire section"
5. Press import button and export to Cell A1
But the problem is ....
This still involves a lot of manual steps to do if there are a lot of files to be done.
Is it possbile to write the VBA in Word or write the script in Excel to do all the steps above?
Doc files in C:\Temp\Word\
Web files in C:\Temp\Web\
Excel files in C:\Temp\Excel\
Thanks for help.
 

Read other answers
RELEVANCY SCORE 110.8

i made a table in ms word.
but i want to convert this table into execl sheet for data analysis.
only copy/cut from ms word and paste into execl sheet are not working as the whole table comes into one cell of the execl sheet and it doesn't serve my purpose to analyse the data.
the volume of the data is huge and re-entry into execl sheet takes lot of time.
is there any solution to convert this ms word data into execl sheet.
its urgent.
 

A:Solved: how to convert ms word table into execl sheet

Read other 16 answers
RELEVANCY SCORE 110.8

Hi there,

I am trying to convert my xls file into a database table. However, the problem is the xls file wasn't formatted in the traditional database style which has all field names at the first row and data rows after.

I wonder if there are any add-ins that can do this task. If not, do I need to write vba to handle it? I have like a thousands of sheet like the attached one and at this moment, not quite sure how to do.

Please help.
CR
 

A:Need to convert formatted-free xls sheet to database table

Read other 8 answers
RELEVANCY SCORE 96.4

I have cloned a logical partition with valuable data from an MBR partition from one HD to a new 4Tbt HD. Now I realise that I am stuck with a 2 Tbt partition limit if I leave it as a MBR partition. Is it possible just to convert from an MBR to a GPT partition without deleting the partitions and the data and starting from scratch? Also what are some recommended programs for partitioning?

Kind Regards
Chris

Read other answers
RELEVANCY SCORE 96.4

Dear Sir/Madam,
We want to convert GPT partition to MBR partition table format can you please suggest and help us.

Read other answers
RELEVANCY SCORE 96.4

I have cloned a logical partition with valuable data from an MBR partition from one HD to a new 4Tbt HD. Now I realise that I am stuck with a 2 Tbt partition limit if I leave it as a MBR partition. Is it possible just to convert from an MBR to a GPT partition without deleting the partitions and the data and starting from scratch? Also what are some recommended programs for partitioning?

Kind Regards
Chris

A:How to Convert MBR Partition to GPT Partition Table on 4Tbt HD

As far as I know, you cannot convert from MBR to GPT without deleting ALL partitions and starting over. So, you'd have to backup up all your data.

You should be able to do that with Diskpart which you can access from the Windows install media by hitting shift F10 at the first screen where you are asked to choose a language.

Or use a third party application---the most commonly recommended one here is Partition Wizard, a free download.

Read other 3 answers
RELEVANCY SCORE 95.6

This is an update of a closed thread, which itself was an update of another closed thread (I work for the government, so everything takes forever ). U can see pt2 here: http://forums.techguy.org/business-applications/876775-word-2007-macro-convert-file.html#post7030254

Anyway, issues 1 and 3 in that thread were resolved w/ the advice that Rollin_Again gave me. Only issue 2 remains:

2. It would be really helpful to get it to create PDF, rtf, and txt files all in the same folders.
Are you saying that you want to run the macro one time and have it create all 3 files types at the same time without having to modify the code and change the file output manually?Click to expand...

Yes... virtually every time we run this macro, we will need pdf, rtf, and txt versions of the original file in the same folder. So if the input file is in FOLDER1 and is named FILE1.docx, then the output folder should also be called FOLDER1 and it should contain FILE1.pdf, FILE1.rtf, and FILE1.txt.

I've pasted the macro below... it looks to me like some portion of the do-loop that creates the RTF file needs to be replicated twice more and each of those replications needs to be modified slightly to create PDF and TXT files.

'**OPEN THE MICROSOFT VISUAL BASIC EDITOR, CLICK TOOLS >> REFERENCES, AND MAKE
'**SURE THAT "MICROSOFT SCRIPTING RUNTIME" IS CHECKED.

Sub ConvertDocs()

'**CHANGE TO DESIRED DIRECTORY**
Call GetFiles("D:\Desktop\test\", True, True)

En... Read more

A:Word 2007 macro to convert file types (pt3)

Read other 16 answers
RELEVANCY SCORE 95.6

This is an update of a closed thread... u can see the original here: http://forums.techguy.org/business-applications/856041-solved-word-2007-macro-convert.html

So I've got the macro and it works great -- for converting doc/docx to PDF or rtf. But there are 3 issues that still need to be addressed.

1. I can't get it to work to convert to txt properly -- it gives me an output txt file that includes a bunch of formatting instructions like font, color, spacing, etc.

2. It would be really helpful to get it to create PDF, rtf, and txt files all in the same folders. So for instance, I've got Folder1 and inside that is SubfolderA (which contains A.doc) and SubfolderB (which contains B.doc). I'd like the output to be Folder1\SubfolderA, and inside SubfolderA is A.pdf, A.txt, and A.rtf. SubfolderB would contain B.pdf, B.txt, and B.rtf.

3. So far, 3 other people on this committee have tried the macro on their computers, but it only works on mine (and all 3 of them have checked "Microsoft Scripting Runtime"). And I had to delete all the existing macros in Word to get mine to work -- it seems like I can only have 1 macro at a time. 1 of the computers doesn't do anything when we try to run the macro, and the other 2 give this error: Run-time error '76': Path not found" even though the path in the macro was edited to be correct for that machine. This section below was highlighted after clicking “Debug”...

FSO.CopyFolder Left(FolderNa... Read more

A:Word 2007 macro to convert file types?

1. I can't get it to work to convert to txt properly -- it gives me an output txt file that includes a bunch of formatting instructions like font, color, spacing, etc.Click to expand...

When you run the macro to save the files as text are you changing the actual output format type in the macro? My guess is that you are only changing the portion of the code that replaces the filename extension and not the actual file type. The portion of the code that I highlighted in red below should also be changed to FileFormat:=wdFormatText.


2. It would be really helpful to get it to create PDF, rtf, and txt files all in the same folders. Click to expand...

Are you saying that you want to run the macro one time and have it create all 3 files types at the same time without having to modify the code and change the file output manually?


3. So far, 3 other people on this committee have tried the macro on their computers, but it only works on mine (and all 3 of them have checked "Microsoft Scripting Runtime") Click to expand...

Are all 3 computers running the same version of Word?

Have you checked to make sure all upper and lower case letter match what is listed in the the folder path since it IS case sensitive. Did you also make sure there is a backslash at the end of the directory path? Call GetFiles("D:\maddenb\Desktop\test\", True, True)

Also, there is also no reason for you to have to delete other macros on your computer for this macro to run. Where... Read more

Read other 1 answers
RELEVANCY SCORE 94.4

So I have a batch of about 750 Word documents that need to be converted to RTF. I recorded a macro that looks something like this:

quote:

Sub rtf3()
'
' rtf3 Macro
'
'
Documents.Open FileName:="D:\user\Desktop\test\1.docx", ConfirmConversions:=False, ReadOnly:= _
False, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:= _
"", Revert:=False, WritePasswordDocument:="", WritePasswordTemplate:="", _
Format:=wdOpenFormatAuto, XMLTransform:=""
ActiveDocument.SaveAs FileName:="D:\user\Desktop\test\1.rtf", FileFormat:=wdFormatRTF, _
LockComments:=False, Password:="", AddToRecentFiles:=True, WritePassword _
:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _
SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _
False
ActiveDocument.Close
It works fine, but there are a couple of problems w/ it. 1, I have to repeat it over and over for each file, and 2, each repetition has to be edited w/ the next filename, the path to that file, and the new filename. I figured out a way to partially automate that process, but it's still a PITA .

Can't I just tell it to get all the .docx files in this folder and all its subfolders and save them as an RTF w/ the original filename?
 

A:Solved: Word 2007 macro to convert file types?

Read other 10 answers
RELEVANCY SCORE 86.4

I have a Make Table query that when I run it and view the table in the query it shows only the data I want. But when I go and open the table that theis query made, there are entries that should not be there.

It is putting in rows with blank fields, I am not sure how to stop it. I have tired to put something in the query for that field but I get back the error "Invalid Use of Null"

If I could put in the criteria that worked I would be all set.

Any ideas?
 

A:Solved: Access (Make Table) Query Results Returned not Same as Table

Read other 6 answers
RELEVANCY SCORE 86

A previous thread indicated problems encountered when trying to update a Table of Contents and Table of Figures, etc. using Word 2007. I couldn't find any solutions to that message. I am having the same problem. I tell it to update the Table of Contents or Table of Figures, and it does that correctly, but as soon as I click "print" the page numbers all change to 2! Any ideas?
 

A:Solved: Word 2007 - Page Number Issues Updating Table of Contents and Table of Figure

Read other 12 answers
RELEVANCY SCORE 86

I would like to populate an excel sheet with the values that are there in another adjoining sheet (The excel file is the same). The issue here is the data in the adjoining sheet table is pivoted. So what I want is:
Sheet 1 (Columns): Server_Name, Oracle - Category backup etc
Sheet 2 (Columns): Server_Name, Monitors only and the monitors here have different values for each server.

Sample for Sheet 2:

Here is an excerpt from the first pivoted data sheet. This is my sheet 2 (the pivoted table) and my first sheet is the same as above.
sDisplayName sMonitorTypeName sMonitorTypeDescription (Placeholder?)
AQUA3 AQUA3 - AOL Jobs Monitors the ETL jobs on AQUA3
RPC Service NT Service Monitor
SNMP Test availability of SNMP
AQUA4 Oracle - Category backup Active Script Monitor
Oracle - DataPump backup Active Script Monitor
Oracle - DBA account created Active Script Monitor
Oracle - Keep Cache Active Script Monitor
Oracle - locked accounts Active Script Monitor
Oracle - RMAN backup Active Script Monitor
OracleDBConsoleORCL NT Service Monitor
AQUAMARINE3 RPC Service NT Service Monitor
SNMP Test availability of SNMP
BASIL3 RPC Service NT Service Monitor
SNMP Test availability of SNMP
BERYLLIUM1 Beryllium 1 - Eon Incremental Monitors the ETL jobs on Beryllium 1
RPC Service NT Service Monitor
SNMP Test availability of SNMP
BERYLLIUM2 Oracle - DBA account created Active Script Monitor
Oracle - Keep Cache Active Script Monitor
Oracle - locked accounts Active Script Monitor
OracleDBConsoleCBORC... Read more

Read other answers
RELEVANCY SCORE 86

If I move a table row in Word 2007, it seems to split the table at the point it is inserted. The row above gets the table bottom formatting, the row I insert gets both table top and table bottom, and the next row gets table top. If I hover the mouse at the start of the inserted row it offers me the table start marker, as does hovering over the next row. This happens whether I drag and drop or cut and paste.

What’s going on, and how can I insert the row as part of the existing table, or at least re-merge the tables back to one again? I never had this problem with 2003.

Thanks,

Ian
 

Read other answers
RELEVANCY SCORE 86

hi,

Just wondering if anyone could tell me if and how i can revert back to an older version of a table.

I had a table saved contain product details
whilst i was away a work mate accessed the table deleted some colums and saved over the table.
i was just wondering if the was anyway to undo this save, or if a back of the previous table could be found somewhere.

using Access 2000 on Win XP (no restore point available).

thx in adv.
Dam
 

A:Access 2000 table backups? / undo a save to a table

No.
Not unless it's on a drive where you have been backing up the entire database or have specifically set up for the database to backup the data...
 

Read other 1 answers
RELEVANCY SCORE 85.2

Hi there,
I am not that cluey with access vba programming and I need some help please.
I have a Table called (Parts) with columns (PartName), (PartNumber), (PartCost), (Quantity)...
I have (Parts) table linked to (Repairs) table in one to many relationship.
I have a Form linked to the table (Repairs) with different fields to enter different repair details.
Among these fields is: combo box (PartsNameCombo) where you can select the Part Name from values listed in (PartName) column in table (Parts), and I have used the following codes to populate the selected part's cost accordingly:

Private Sub PartNameCombo_Change()
'Auto populate Part cost based on Part Name
Me.PartCost.Value = Me.PartNameCombo.Column(2)
End Sub

I have repeated the above combo box three times (in case different parts used in one repair).

My Question: I would like to add code to automatically subtract (1) from part's Quantity in (Parts) table whenever a particular (PartName) is selected in the combo box.
so for example, if in a repair, I selected: (front case) in the first combo box and (display screen) in second combo box, I want the cases quantity to drop by one and also screens quantity to drop by 1?
Any one can please help?
 

A:Updating table value when different table form field updated

Read other 16 answers
RELEVANCY SCORE 85.2

http://www.mediafire.com/?8bbfjsbun24m74z

In this database, i have a data entry form called "Information Requested" and all information in this form when entered are added into table Information Requested. In the form, 3 fields Names, Business Units and Emails are drop down lists based on table Contact List. However, what the form does now is i have to pick the name, business unit and email manually. It's not really efficient this way. what i want is when i pick the name, the corresponding business unit and email of that person will automatically show up in the box. How can I achieve this?
 

A:[Access 2010] How to append record from one table to another table.

The data should NOT be transferred to the table, only displayed on the Form, as it should only be entered once.
You can display it on the form by including the data in the Combo as a "Concatenated" field or you can transfer the data to "Unbound" fields.
 

Read other 1 answers
RELEVANCY SCORE 85.2

Hi there,
I am not that cluey with access vba programming and I need some help please.
I have a Table called (Parts) with columns (PartName), (PartNumber), (PartCost), (Quantity)...
I have (Parts) table linked to (Repairs) table in one to many relationship.
I have a Form linked to the table (Repairs) with different fields to enter different repair details.
Among these fields is: combo box (PartsNameCombo) where you can select the Part Name from values listed in (PartName) column in table (Parts), and I have used the following codes to populate the selected part's cost accordingly:

Private Sub PartNameCombo_Change()
'Auto populate Part cost based on Part Name
Me.PartCost.Value = Me.PartNameCombo.Column(2)
End Sub

I have repeated the above combo box three times (in case different parts used in one repair).

My Question: I would like to add code to automatically subtract (1) from part's Quantity in (Parts) table whenever a particular (PartName) is selected in the combo box.
so for example, if in a repair, I selected: (front case) in the first combo box and (display screen) in second combo box, I want the cases quantity to drop by one and also screens quantity to drop by 1?
Any one can please help?
 

A:Updating table value when different table form field updated

At least two ways to do this but I wouldn't make it automatic. What if the wrong Part name was inadvertently selected? I would ad a button to the form "Take one from Inventory" and execute an update query that basically does Quantity= Quantity-1 . This query would need to link to PartNumber on the active form.

The other way would be to write the SQL to do the update in VBA and run the EXEC SQL command under the new button.
 

Read other 2 answers
RELEVANCY SCORE 85.2

I'm trying to run a clear table query (to keep the table, but delete the data), and then an append query to repopulate the table, and it's not working.

...any idea what I'm doing wrong?
 

A:ACCESS clear table/append table not working?

Read other 11 answers
RELEVANCY SCORE 85.2

Hey there folks...
I am in need of some assistance. Obviously!

I need a form which allows a user to select a record from one table and completely move the record to a totally separate table in the same database. I need it to transfer all the data for the selected record.

AutoNumber will not be an issue as each record has unique identifiers.

I found this article online but it seems it will append ALL data and doesn't allow a user to select the correct record. This uses an Append Query which makes sense but again it seems as though it will transfer ALL records. All I need is for it to transfer a specific record depending on the user's selection in the form.
 

A:MS Access 2007: Moving a record from one table to another table...

Is this to "Archive" the record?
It is not normally necessary to actually "Move" a record, as you can just have a tick box called archive or similar that can be used to exclude that record from normal display and to display it as an Archived record.
There are 2 ways to do what you want, if it is really necessary, one is using an Append query, you can Identify the currently selected record on the Form using
forms![Form Name]![name of Key Field]
in the First Criteria row of your Key field, where Form name is the actual name of your form and name of Key Field is the actual name of your Key Field.
The other version is to use a VBA recordset Clone to do the same thing.
The
 

Read other 1 answers
RELEVANCY SCORE 85.2

I am having trouble updating data from one table to another. I am not Appending the data.

I've linked the two tables on an ID field.
I created a select query to see the data I would update.
I changed the query to an Update query.
In the Update To field I placed the following: [table].[field name]

After running the query I noticed the update did not work. The data from the first Table did not get updated to the second Table it wound up being deleted from the first Table.

Your help is appreciated.

Buttercup
 

A:Solved: Access 2003 Update Table from another Table

Buttercup1, welcome to the Forum.
I am not sure why you wan to update the second table with data from the first table.
Can you show me a screenshot of your query with the table(s) in and also your Table relationships?
 

Read other 3 answers
RELEVANCY SCORE 85.2

I put a table into a doc file and decided later I didn't need it there, so I used the Control key and down arrow to highlight it then hit Delete. The table disappeared, BUT now, every time I open the .doc, I get the following warning.
How do I get rid of it without having to print out the entire 5 page document then retyping it?

 

A:Wodrd2K fives warning about corupted table in a .doc, but there's NO table!

Try saving the document as a text file (*.txt). This will get rid of all the formatting, leaving just the text. Hopefully, this will get rid of the reminants of the table. Take it back into Word and then redo the formatting.
 

Read other 2 answers
RELEVANCY SCORE 85.2

hello,
I have created a make table via a parameter query. The parameters are defined correctly and I am prompted each time to enter them. the DeptNo does work as my query is filtered based on a value entered, but when I enter the tablename parameter, the make table query always saves the table as @tablename, and not any text i enter for the @tablename like "mynewtable" or something. Here is the SQL code.
Any ideas? Ignore the complexity of the query, my main concern is being able to loop through some VBA code and continually change the tablename each time (along with the DeptNo. I think this will save me time vs creating a new sql statement each time and doing a docmd.runsql ...
Thanks.

PARAMETERS DeptNo Text ( 255 ), [@TableName] Text ( 255 );
SELECT AUMaster.Lawson, ChgMstr.DEPT, ChgMstr.[CHG CD], ChgMstr.[REVENUE DESCRIPTION], [Prior and Curr Year Revenue - Qty].Price, ChargeCodeProfile.[Count per Charge] AS Weight, [Prior and Curr Year Revenue - Qty].[2006 Projected Quantity], [Prior and Curr Year Revenue - Qty].[2006 Projected Revenue], [Prior and Curr Year Revenue - Qty].[2007 Projected Quantity], [Prior and Curr Year Revenue - Qty].[2007 Projected Revenue] INTO [@TableName]
FROM ((ChgMstr LEFT JOIN [Prior and Curr Year Revenue - Qty] ON ChgMstr.[CHG CD] = [Prior and Curr Year Revenue - Qty].ChargeCode) LEFT JOIN ChargeCodeProfile ON ChgMstr.[CHG CD] = ChargeCodeProfile.[CHG CD]) LEFT JOIN AUMaster ON ChgMstr.DEPT = AUMaster.Affinity
WHERE (((ChgMstr.DEPT)=[D... Read more

A:Parameter Make Table Query-passing the table name - HELP!

Read other 10 answers
RELEVANCY SCORE 85.2

I have different mailing lists that I want to add to a mailing list in my database. There may be duplicate addresses in these lists. I want to only add an Address, FirstName, LastName record once. So how do I combine these lists with my original list without adding a duplicate Address, FirstName, LastName record?
 

A:importing data from a table to another table without adding duplicates?

Read other 6 answers
RELEVANCY SCORE 85.2

I am starting this Access database from scratch. I have to import/upload a sales file weekly. I will be adding this file to a main sales data table. The issue I have is that this file does not have any dates on it. I need to be able to add a start and end date to the table.

Example fields that I would need/have

Need:
start date
end date

Have:
Item #
Store #
Sales Units
Sales Dollars

What is the best way to handle this? I have an idea - just not sure what order I should put my steps for importing the file, asking for the date range, adding the date to the table, etc....
 

A:Solved: Access - import table - add date to table

Read other 9 answers
RELEVANCY SCORE 84.8

I have a macro that creates a pivot table from data on a worksheet. The problem I have is that I want the pivot table created on the same worksheet as the data. Anyone know how I can do this?

The code is below.........

Sub Macro6()
'

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
Worksheets("Raw Data").Range("C1").CurrentRegion).CreatePivotTable _
TableDestination:="Raw Data", TableName:="PivotTable1", _
DefaultVersion:=xlPivotTableVersion10
ActiveWorkbook.ShowPivotTableFieldList = True
With ActiveSheet.PivotTables("PivotTable1").PivotFields("Error Code")
.Orientation = xlRowField
.Position = 1
End With
ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _
"PivotTable1").PivotFields("Description"), "Count of Description", xlCount
ActiveWorkbook.ShowPivotTableFieldList = False
Application.CommandBars("PivotTable").Visible = False
ActiveSheet.Range("E1").Select
ActiveSheet.Range("A1").Select
End Sub
 

A:Pivot Table macro problems

I can't run your code, I have an earlier version.

You have a (partial) line:

TableDestination:="Raw Data"

When I record pivot table creation & specify same sheet, I get:

TableDestination:=Range("G1")

, so try something like that. Of course you'll need to be sure that the destination is a "safe" area.

ETA: welcome to the board.
 

Read other 2 answers
RELEVANCY SCORE 84.8

Hello,

I am trying to record a macro that will create a pivot table based on a
spreadsheet.

I am receiving error Num: 1004

Unable to get the PivotField property of the PivotTable Class.

The code that recorded is below. I am much more familiar with coding in
Access, so don't even know where to start here.

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"tempPO_ExpSumm!C1:C4").CreatePivotTable TableDestination:="",
TableName:= _
"PivotTable4", DefaultVersion:=xlPivotTableVersion10
ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
ActiveSheet.Cells(3, 1).Select
With ActiveSheet.PivotTables("PivotTable4").PivotFields("Expeditor")
.Orientation = xlColumnField
.Position = 1
End With
With ActiveSheet.PivotTables("PivotTable4").PivotFields("LS_Date")
.Orientation = xlRowField
.Position = 1
End With
With ActiveSheet.PivotTables("PivotTable4").PivotFields("PO_Type")
.Orientation = xlRowField
.Position = 2
End With
ActiveSheet.PivotTables("PivotTable4").AddDataField
ActiveSheet.PivotTables( _
"PivotTable4").PivotFields("PO_Count"), "Count of PO_Count", xlCount

Thank you,
Roger
 

A:Solved: Pivot Table Via Macro

Read other 12 answers
RELEVANCY SCORE 84.8

Hello,

First off thanks for reading this far , I am using Microsoft Word 2011 (Mac) and I have numerous reports that all reside off a basic template; the majority of the document and has various tables ranging from a width of 2 cells, and the height varies.

Is there a way to create a macro or a toggle to delete (or hide) a particular row in conjunction with the toggle? Instead of the repetitive deleting each row one by one.

Thanks for the help!
 

Read other answers
RELEVANCY SCORE 84.8

I have very limited programming skills and while I have searched the site and found some code I am not able to decipher enough as to what I can and cannot use. I have a macro that I run to format a pivot table to remove any ability of the receiver to view anything other than what I send. I want to be able to automate the sending of this pivot table to the selected salesrep via Microsoft outlook 2003. I do not have the email address within the pivot table but it should be able to be populated within outlook using the same salesrep field, [I attached a shell of what the pivot table looks likes]. I have to run the macro individually for each salesrep that appears in the table for that day and then send it. I would like the email subject line to read Daily Order report and insert the date from the pivot table, I would want the email To: populated with the sales rep name from the pivot table and then for the pivot table copy to be attached to the email.

I work on a Maxspeed terminal
Using MIcrosoft office 2003 and Microsoft outlook 2003

I hope I have given enough info in an understandable format.

Please help.
 

Read other answers
RELEVANCY SCORE 83.6

Hello,

I have managed to write a macro that copies a table from excel into a new document in word, here is the code:

Sub controlword()

Dim appwd As Word.Application

Set appwd = CreateObject("word.application.9")

appwd.Visible = True

appwd.Documents.Add

Set wdApp = New Word.Application

Range("a1:j7").Copy

appwd.Selection.Paste

End Sub

I would like to make it so that the table copies into word NOT into a new document but into any open document at the location of the cursor...

Could anybody help me out with the code for this...

Thanks
 

A:Macro to copy a table from excel into word

You need to Set appwd to use the currently open Word Document not CreateObject.

Sub Controlword()

Dim Appwd As Object

Set Appwd = GetObject(, "Word.Application")

Set wdApp = Appwd.ActiveDocument

Range("a1:j7").Copy

Appwd.Selection.Paste

End Sub
I didn't test for the cursor location.
 

Read other 1 answers
RELEVANCY SCORE 83.6

I have a dump from a text file in two single columns. The first column is a block of 55 labels that repeat for every group of data, the second is the data for 110 transducers. Every transducer produce 55 single values (numerical or status(text)). I need to order this two columns dumps into a table. Where the first column are the labels and the rest 110 column the corresponding data one column per transducer.
How can we do this? Can any body help me?
 

A:Excel macro to move two Columns into a table

Hi and welcome to TSG!

Can you upload a sample of the textfile? I just need a few lines. It doesn't have to be real data. Just want to see the data structure.If you can provide this, I'm sure we will solve the problem.

Jimmy
 

Read other 1 answers
RELEVANCY SCORE 83.6

Hi there,

I have excel 2007 and I am trying to delete a table I put in. (Insert > Table) The problem is when i do this it deletes the data within the table. I dont want to have to delete the table and put in all the information again. Is there an easy way to do this? I looked at a similar post and it said to press the filter button on the data tab. This does nothing.

Any help or suggestions would be greatly aprreciated.

cheers.
 

A:Removing a Table without deleting the data within the table!

Read other 16 answers
RELEVANCY SCORE 83.6

Hi, i'm new in using excel macro and vba. In my workbook, there are large amount of uncluttered data in many table in one worksheet. I need help how to combine/merge/join multiple table in one worksheet into one master table into another worksheet using userform? i'm sorry if my explanation is confusing because I'm not so good in English. thank you for any help.
 

Read other answers
RELEVANCY SCORE 82.8

Hi,

I am trying to create a button for inputting rows of data into a table.

I need the table to input a set amount of rows on the next available space in the table, and populate 1 of the columns with data given in a list.

I know I need a macro of some sort but am not sure how to go about creating it.

I have attached an example spreadsheet for reference.

Any help would be greatly appreciated!
 

Read other answers
RELEVANCY SCORE 82.8

I've recorded a macro to update the Table of contents in my document, but when I run the macro it duplicates the headings. The document is somewhat complicated in that it is an access report that is saved as RIch Text Format and inserted into the word document. There is macro in word that is used to clear all page breaks and another that formats all the main topics as "heading 1". Here is the code to update the TOC as well as the code at formats the headings:
Sub Update_TOC()
'
'
Selection.GoTo What:=wdGoToBookmark, Name:="Table_Of_Contents"
Selection.Find.ClearFormatting
Selection.Find.Style = ActiveDocument.Styles("Heading 1")
With Selection.Find
.Text = ""
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Fields.Update
End Sub

Sub Heading_1()
'
'
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
Selection.Find.Replacement.Style = ActiveDocument.Styles("Heading 1")
With Selection.Find
.Text = "#*#*"
.Replacement.Text = "^m"
.Forward = True
.Wrap = wdFindContinue
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute Replace:=wdReplaceAll
Selection.Find.ClearFormatting
Sel... Read more

A:Update table of Contents Macro - MS Word 2000

Read other 6 answers
RELEVANCY SCORE 82.8

I have several queries that I run daily to update sales, shipments, etc. How do I set up a macro to run a make table query and then export the table to another access database? (The query deletes the records already in the table before re-populating.) If possible, I would prefer to not open the query, just run it. Please know that I am a very new user of Access, so I may need step-by-step examples.
Thanks for your help!
 

A:Access 2010 Macro to run make table query

Are you sure that you need a maketable query?
Won't an append or update query work?
Also why do you then need to export the table, can't this be done in the other database?
 

Read other 3 answers
RELEVANCY SCORE 82.8

In my work environment we are writing test cases and for the test steps we use a word table. Its the same 4 columns so we can load them into the Quality Center environment. One issue we had was our review tool doesn't support word but does text documents. The format of the table was kind of messy when we saved as a text document in the sense it would lump all the stuff together with no clean breaks. As a solution people making every other row and column blank so there would be a break in the text format. Once the review was complete you would have to then go back into that word doc and delete all the blank rows and columns to load into Quality Center. Not hard but time consuming with the number of test we would deal with. I wrote a quick macro that would delete the header in the table plus all the blank rows and columns.

Now what we have is we are re using these test and adding to them. Currently we are pulling them out of quality center, adding the blank rows and columns back in, adding our updates, sending back out for review, deleting the blank rows and columns (macro does this), load back into Quality Center.

There may be a better way to go about this but what I am after is this. A macro that will insert a blank row and column every other row and column. I have been off and on playing with this for a few days but really have gotten no where with it. Posted on a few non technical forum and they suggested posting on this site for some help. I tried searching and did... Read more

Read other answers
RELEVANCY SCORE 82.8

Hi,

I'm hoping that someone can help me.

Through Oracle forms I create a temporary table and populate it with data from the db. The temp table may have a different structure each time it is created. One time it may have just an id column. The next id, name and city, the next time it is created it may just have id and name, etc. The table is a dynamic table that is only in the database while the user is in this portion of the application.

From the Oracle form where the temp table is created and populated a call to Excel is made, and Excel starts opening up the called Excel report. After the user closes excel and goes back to the Oracle form the temp table is dropped from the db.

What I am trying to do next is get Excel to select all from the temp table and show the results automatically when the called report is first opened. Keeping in mind that the table structure may not be the same way twice.

If anyone has any ideas/code how it would be appreciated.

I am not totally familiar with Excel and have been bouncing around trying a couple of ways. One way was to create a macro stepping through creating a database query. But this way seems to blow up as soon as the table structure is changed. And when I went into the macro and edited the macro to make the select statement Select * (all) from the temp table, it didn't like that syntax. The macro syntax uses the specific column names, which is no good as the table structure changes. I need it to take the generic sele... Read more

A:Auto macro or sql request - Select all from temp table

Read other 7 answers
RELEVANCY SCORE 82

Hi,

I want to convert Excel macro to Executables, so that i can call that from another application to run.

let me know, if u have idea on it..

Nagarajan S
 

A:Convert Excel Macro to Executables

you need to put your code in the "This Workbook" section of the project.

Private Sub Workbook_Open()


End Sub

You can easily access this by right clicking on the Excel icon in the top right corner of the Excel window...choose "View code".

Any code there will execute when the book is opened, set your Excel Security (Tools/macro/Security) to "LOW" so it will not be held up by the pop up to enable macros
 

Read other 3 answers
RELEVANCY SCORE 82

Hi everyone,

Let me just start by saying this forum is awesome. Nothing like getting a new perspective to solving a problem!

Here's the scenario:
I have 3 sheets: Input Sheet, Output Sheet, Translation Table

Both the Input Sheet and Output Sheet has columns of data with a header row in row 1. I need to move entire columns of data from the Input Sheet to the Output Sheet based on the header row.

This is where the Translation Table comes into play. I need to move the columns of data based on what is defined in the Translation Table.

For example, all data in column "Column A" of the Input Sheet should be moved to column "Albert Column" of the Output Sheet.

A sample file is attached to better illustrate.

Thanks in advance for the help!

Simon
 

A:Solved: Excel Macro - Cut/Paste Data via Translation Table

Read other 6 answers
RELEVANCY SCORE 81.2

Hi all, I am new to your site. it very difficult to explain my request without using a spreadsheet so I posted my file and specification at below link

http://wikisend.com/download/481566/attachments_2011_02_12.zip

Can someone help me with this fairly quickly?

I would greatly appreciate it

Brian
 

A:macro to change source data of pivot table per user entry

Hey, nice service, could we upload documents using this?
 

Read other 1 answers
RELEVANCY SCORE 80.8

Hello!

I am new to the IE Forum!

I would like help with IE 7 keyboard/mouse commands for choosing tables and table elements (i.e. <TD>). I know this is no problem in Firefox. If I want to choose a <TD> element in FF, all I have to do is point to the element I want and press the Ctrl + <left mouse> and the element is chosen. If I want to choose a whole table in FF, all I have to do is place my mouse beside the table and press the Ctrl + <left mouse> and the complete table is chosen.

My question is, can I do something similar with Internet Explorer? I hope so, I am running another application that works better in IE.

Thanks for any help on this matter!

Gary

Read other answers
RELEVANCY SCORE 80.8

I have two access tables I would like to merge data into one table. How to do?

I tried blank database importing one by one but result is I get two tables not one.
 

A:Importing data from one table into another table

You are going to have to write an insert query. If you view it in SQL mode it would look something like:

INSERT INTO MyTable1
SELECT *
FROM MyTable2;
 

Read other 2 answers
RELEVANCY SCORE 80.4

Hi,
I have understood and tried formulas to get the total hours an employee worked in a week. The file attached has the raw data, the requirement on which I tried to built the formula and the solutions.
I need a macro which selects the file that has the new data every week and displays the total hours in the output.
Thanks
 

A:Macro to convert the formulas used to get hours worked in a week

duplicate closed
continue in your other thread
http://forums.techguy.org/business-applications/1119145-macro-get-desired-output.html
 

Read other 1 answers